| | |
| | | { |
| | | oFrm = new Gy_ProcPrice(); |
| | | oFrm.ShowDialog(); |
| | | if (oFrm.BillChange) |
| | | { |
| | | if (MessageBox.Show("鍗曟嵁鍒楄〃宸茬粡鍙戠敓鍙樺寲,鏄惁鍒锋柊", "鎻愮ず", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) |
| | | { |
| | | timer1.Enabled = true; |
| | | } |
| | | } |
| | | } |
| | | //淇敼 |
| | | private void Sub_ShowBill() |
| | |
| | | { |
| | | if (wl.Checked == false) |
| | | { |
| | | sSql = "Select top 10000 * from " + ViewName + " where 宸ュ簭浠g爜 like '" + HParentID.ToString() + "%' order by " + ModName + "浠g爜"; |
| | | sSql = "Select top 10000 * from " + ViewName + " where 宸ュ簭浠g爜 like '%" + HParentID.ToString() + "%' order by " + ModName + "浠g爜"; |
| | | } |
| | | else |
| | | { |
| | | sSql = "Select top 10000 * from " + ViewName + " where 鐗╂枡浠g爜 like '" + HParentID.ToString() + "%' order by " + ModName + "浠g爜"; |
| | | sSql = "Select top 10000 * from " + ViewName + " where 鐗╂枡浠g爜 like '%" + HParentID.ToString() + "%' order by " + ModName + "浠g爜"; |
| | | } |
| | | |
| | | } |
| | |
| | | try |
| | | { |
| | | sNode.Nodes.Clear(); |
| | | DataSet Ds = oCn.RunProcReturn("select hitemid,hnumber,hname from " + sBill + " where HStopflag=0 and HParentID=" + sNode.Name.Trim().Substring(1, sNode.Name.Trim().Length-1) + " order by HNumber ", sBill); |
| | | DataSet Ds = oCn.RunProcReturn("select hitemid,hnumber,hname from " + sBill + " where isnull(HStopflag,'')='' and HParentID=" + sNode.Name.Trim().Substring(1, sNode.Name.Trim().Length-1) + " order by HNumber ", sBill); |
| | | for (int i = 0; i < Ds.Tables[0].Rows.Count; i++) |
| | | { |
| | | TreeNode oNode = sNode.Nodes.Add("T" + Ds.Tables[0].Rows[i]["HItemID"].ToString(), Ds.Tables[0].Rows[i]["HNumber"].ToString() + spChar + Ds.Tables[0].Rows[i]["HName"].ToString(), 0, 1); |