public static void SaveToDB(string CurrentForm, MemoryStream s) { string SQL = "select * from t_FormFormat where F_FormName = '" + CurrentForm + "'"; DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = myHelper.GetDs(SQL); DataRow dr = null; if (ds.Tables[0].Rows.Count == 0) { dr = ds.Tables[0].NewRow(); dr["F_FormName"] = CurrentForm; dr["F_Stream"] = s.ToArray(); ds.Tables[0].Rows.Add(dr); } else { dr = ds.Tables[0].Rows[0]; dr.BeginEdit(); dr["F_Stream"] = s.ToArray(); dr.EndEdit(); } myHelper.SaveData(ds, SQL); }
private void Add(object sender, EventArgs e) { if (comboBoxEdit1.SelectedIndex < 0) { MessageBox.Show(this, "请选择审核步骤!", "提示"); return; } if (lookUpEdit2.EditValue == DBNull.Value) { MessageBox.Show(this, "请选择审核人!", "提示"); return; } if (comboBoxEdit3.SelectedIndex < 0) { MessageBox.Show(this, "请选择下一步!", "提示"); return; } DataLib.DataHelper myHelper = new DataLib.DataHelper(); string sSQL = string.Format("insert into t_MultCheck(F_BillType,F_CheckLevel,F_CheckMan,F_NextLevel) values('{0}',{1},'{2}',{3})", comboBoxEdit2.Text, comboBoxEdit1.Text, lookUpEdit2.EditValue, comboBoxEdit3.Text); if (myHelper.ExecuteSQL(sSQL) == 0) { DataBind(comboBoxEdit2.Text); } }
/// <summary> /// 提取客户订单明细 /// </summary> private void GetOrderDetail() { DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = myHelper.GetDs("exec sp_SellOrderTmp"); gcTmp.DataSource = ds.Tables[0].DefaultView; }
/// <summary> /// 取得已设置字段 /// </summary> private void LoadField() { string strSQL = "select F_MasterField,F_SlaverField from t_BillImport where F_Type = '" + strType + "' and F_Class = '" + strClass + "'"; DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = myHelper.GetDs(strSQL); if (ds.Tables[0].Rows.Count == 0) { return; } string strDes = ds.Tables[0].Rows[0]["F_MasterField"].ToString(); string strDes1 = ds.Tables[0].Rows[0]["F_SlaverField"].ToString(); string[] strMaster = strDes.Split(','); string[] strSlaver = strDes1.Split(','); for (int i = 0; i < strMaster.Length - 1; i++) { lbDes.Items.Add(strMaster[i]); } for (int i = 0; i < strSlaver.Length - 1; i++) { lbDes1.Items.Add(strSlaver[i]); } ds.Dispose(); }
/// <summary> /// 数据绑定 /// </summary> private void DataBind() { int intMonth = cbMonth.SelectedIndex + 1; string strMonth = "0" + intMonth.ToString(); if (strMonth.Length == 3) { strMonth = strMonth.Substring(1, 2); } string strSQL = ""; strSQL = @"select a.AID,a.F_Date,Convert(varchar(10),a.F_Time,120) as F_Time,a.F_GroupID,b.F_Name as F_GroupName, a.F_ItemID,c.F_Name as F_ItemName,a.F_DeptID,f.F_Name as F_DeptName,a.F_ProcID, g.F_Name as F_ProcName,a.F_Qty,a.F_Price,a.F_Money,a.F_Remark from t_WageInput a left join t_WorkGroup b on a.F_GroupID = b.F_ID left join t_Item c on a.F_ItemID = c.F_ID left join t_Class f on a.F_DeptID = f.F_ID left join t_Process g on a.F_ProcID = g.F_ID where a.F_Flag = 1 and a.F_Date = '" + spYear.Text + strMonth + "'"; DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = myHelper.GetDs(strSQL); this.gcList.DataSource = ds.Tables[0].DefaultView; DataLib.sysClass.LoadFormatFromDB(gvList, this.Name, 0); }
/// <summary> /// 绑定下拉数据源 /// </summary> private void SetDropSource() { string strSQL = "select F_ID,F_Name from t_Client"; DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = myHelper.GetDs(strSQL); lupControl1.LookUpDataSource = ds.Tables[0].DefaultView; lupControl1.LookUpDisplayField = "F_Name"; lupControl1.LookUpKeyField = "F_ID"; ds.Dispose(); strSQL = "select F_ID,F_Name from t_BalanceType"; ds = myHelper.GetDs(strSQL); lupControl4.LookUpDataSource = ds.Tables[0].DefaultView; lupControl4.LookUpDisplayField = "F_Name"; lupControl4.LookUpKeyField = "F_ID"; ds.Dispose(); strSQL = "select F_ID,F_Name from t_Assist where F_Type = '送货方式'"; ds = myHelper.GetDs(strSQL); lupControl2.LookUpDataSource = ds.Tables[0].DefaultView; lupControl2.LookUpDisplayField = "F_Name"; lupControl2.LookUpKeyField = "F_ID"; ds.Dispose(); decTaxRate = DataLib.SysVar.GetDecParmValue("F_C2"); }
/// <summary> /// 删除 /// </summary> protected override void Del() { base.Del(); if (gvList.FocusedRowHandle < 0) { return; } DataRow dr = gvList.GetDataRow(gvList.FocusedRowHandle); /* * if (Convert.ToBoolean(dr["F_Check"]) == true) * { * MessageBox.Show(this, "不能删除已审核的记录!!", "提示"); * return; * } */ if (MessageBox.Show(this, "真的要删除选定记录吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No) { return; } DataLib.DataHelper myHelper = new DataLib.DataHelper(); if (myHelper.ExecuteSQL("delete from t_AssetReduce where Aid = '" + dr["Aid"].ToString() + "'") == 0) { gvList.DeleteRow(gvList.FocusedRowHandle); } }
private void BindData() { string strSQL = ""; strSQL = "select a.*,b.F_Name as F_Storage,c.F_Name as F_Unit "; strSQL = strSQL + "from t_Item a "; strSQL = strSQL + "left join t_Storage b "; strSQL = strSQL + "on a.F_StorageID = b.F_ID "; strSQL = strSQL + "left join t_Unit c "; strSQL = strSQL + "on a.F_ID = c.F_ItemID "; strSQL = strSQL + "and c.F_Main = 1 "; strSQL = strSQL + "where a.F_Kind = '" + cbKind.Text + "'"; if (lupType.Text.Length > 0) { if (lupType.EditValue.ToString().Length > 0) { strSQL = strSQL + "and a.F_Type = '" + lupType.EditValue.ToString() + "'"; } } if (txtValue.Text.Length > 0) { strSQL = strSQL + "and ((a.F_ID = '" + txtValue.Text + "') or (a.F_Name like '%" + txtValue.Text + "%') or (a.F_Spec like '%" + txtValue.Text + "%'))"; } DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = myHelper.GetDs(strSQL); gcMain.DataSource = ds.Tables[0].DefaultView; }
private void BindStore() { string strSQL = ""; strSQL = "select b.F_Name as F_Storage,c.F_ID,c.F_Name,c.F_Spec,"; strSQL = strSQL + "a.F_Unit,a.F_BatchNo,a.F_Grade,a.F_ColorNum as F_Color,a.F_Qty,c.F_Price "; strSQL = strSQL + "from t_StorageQty a,t_Storage b,t_Item c "; strSQL = strSQL + "where a.F_StorageID = b.F_ID "; strSQL = strSQL + "and a.F_ItemID = c.F_ID "; strSQL = strSQL + "and c.F_Kind = '" + cbKind.Text + "'"; if (lupType.Text.Length > 0) { if (lupType.EditValue.ToString().Length > 0) { strSQL = strSQL + "and c.F_Type = '" + lupType.EditValue.ToString() + "'"; } } if (txtValue.Text.Length > 0) { strSQL = strSQL + "and ((c.F_ID = '" + txtValue.Text + "') or (c.F_Name like '%" + txtValue.Text + "%') or (c.F_Spec like '%" + txtValue.Text + "%'))"; } DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = myHelper.GetDs(strSQL); gcStore.DataSource = ds.Tables[0].DefaultView; }
private void sbFind_Click(object sender, EventArgs e) { string strCon = "", strSQL = ""; //if (gvCon.RowCount == 0) return; for (int i = 0; i < gvCon.RowCount; i++) { DataRow dr = gvCon.GetDataRow(i); strCon = strCon + dr["F_Con"].ToString() + " and "; } if (strCon.Length > 0) { strCon = strCon.Substring(0, strCon.Length - 5); } DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet dsSQL = myHelper.GetDs("select F_SQL from t_FindSQL where F_Table = '" + strTable + "'"); strSQL = dsSQL.Tables[0].Rows[0]["F_SQL"].ToString(); if (strCon.Length > 0) { strSQL = strSQL + " where " + strCon; } DataSet ds = myHelper.GetDs(strSQL); gcMain.DataSource = ds.Tables[0].DefaultView; }
/// <summary> /// 将格式保存入数据库 /// </summary> public static int SaveGridToDB(GridView gv, string sName, int iTag) { MemoryStream stream = new MemoryStream(); gv.SaveLayoutToStream(stream); DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = myHelper.GetDs("select * from t_Format where F_Name = '" + sName + "' and F_Tag = " + iTag.ToString()); DataRow dr = null; if (ds.Tables[0].Rows.Count == 0) { dr = ds.Tables[0].NewRow(); dr["F_Name"] = sName; dr["F_Tag"] = iTag; dr["F_Stream"] = stream.ToArray(); dr["F_SQL"] = ""; ds.Tables[0].Rows.Add(dr); } else { dr = ds.Tables[0].Rows[0]; dr.BeginEdit(); dr["F_Stream"] = stream.ToArray(); dr.EndEdit(); } return(myHelper.SaveData(ds, "select * from t_Format where F_Name = '" + sName + "' and F_Tag = " + iTag.ToString())); }
private bool CheckRate(DataTable dt) { decimal decRate = DataLib.SysVar.GetDecParmValue("F_C3"); if (decRate == 0) { return(true); } foreach (DataRow dr in dt.Rows) { if (dr["F_LinkBill"] == DBNull.Value) { return(true); } DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = myHelper.GetDs("select isnull(F_Qty,0) as F_Qty from t_StockOrderDetail where F_BillID = '" + dr["F_LinkBill"].ToString() + "' and Aid = " + dr["PAid"].ToString()); if (ds.Tables[0].Rows[0][0] == DBNull.Value) { return(true); } decimal decQty = Convert.ToDecimal(dr["F_Qty"]) - Convert.ToDecimal(ds.Tables[0].Rows[0][0]); if ((decQty / Convert.ToDecimal(ds.Tables[0].Rows[0][0])) * 100 > 5) { MessageBox.Show(this, "物料[" + dr["F_ItemID"].ToString() + "]超过了订单数的" + decRate.ToString() + "%!", "提示"); return(false); } return(true); } return(false); }
private void SetDropSource() { string strSQL = "select F_ID,F_Name,dbo.fn_GetPy(F_Name) as F_Spell from t_Supplier"; DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = myHelper.GetDs(strSQL); lupControl1.LookUpDataSource = ds.Tables[0].DefaultView; lupControl1.LookUpDisplayField = "F_Name"; lupControl1.LookUpKeyField = "F_ID"; ds.Dispose(); strSQL = "select F_ID,F_Name from t_BalanceType"; ds = myHelper.GetDs(strSQL); lupControl4.LookUpDataSource = ds.Tables[0].DefaultView; lupControl4.LookUpDisplayField = "F_Name"; lupControl4.LookUpKeyField = "F_ID"; ds.Dispose(); strSQL = strSQL = "select F_ID,F_Name from t_Class where left(F_UPID,2) like '03%'"; ds = myHelper.GetDs(strSQL); lupControl2.LookUpDataSource = ds.Tables[0].DefaultView; lupControl2.LookUpDisplayField = "F_Name"; lupControl2.LookUpKeyField = "F_ID"; ds.Dispose(); strSQL = strSQL = "select F_ID,F_Name from t_Emp"; ds = myHelper.GetDs(strSQL); lupControl3.LookUpDataSource = ds.Tables[0].DefaultView; lupControl3.LookUpDisplayField = "F_Name"; lupControl3.LookUpKeyField = "F_ID"; ds.Dispose(); }
private void ReadEmpPic(string sEmpID) { string sSQL = "select F_ID,F_Name,F_Pic from t_Emp where F_ID = '" + sEmpID + "'"; DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataTable dt = myHelper.GetDs(sSQL).Tables[0]; if (dt.Rows.Count > 0) { textBox2.Text = dt.Rows[0]["F_Name"].ToString(); if (dt.Rows[0]["F_Pic"] != DBNull.Value) { Image img = null; ImageConverter imgCvt = new ImageConverter(); object obj = imgCvt.ConvertFrom((byte[])dt.Rows[0]["F_Pic"]); img = (Image)obj; pictureBox1.Image = img; } else { pictureBox1.Image = null; } } else { MessageBox.Show(this, "没此员工!", "提示"); textBox2.Text = ""; pictureBox1.Image = null; } }
/// <summary> /// 刷新摘要类别 /// </summary> private void RefreshType() { DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = myHelper.GetDs("select * from t_AbstractType"); gcType.DataSource = ds.Tables[0].DefaultView; }
protected override bool Save() { //return base.Save(); gvEmp.CloseEditor(); binData.EndEdit(); if (SavePre() == false) { return(false); } DataSet ds = ((DataView)binData.DataSource).Table.DataSet; DataSet dsEmp = ((DataView)gcEmp.DataSource).Table.DataSet; DataSet[] dsData = new DataSet[2]; dsData[0] = ds; dsData[1] = dsEmp; string[] strSQL = new string[2]; strSQL[0] = strSaveSlaverSQL; strSQL[1] = "select * from t_WageEmp"; DataLib.DataHelper myHelper = new DataLib.DataHelper(); if (myHelper.SaveMuteData(dsData, strSQL).Length == 0) { ds.AcceptChanges(); dsEmp.AcceptChanges(); return(true); } else { return(false); } }
/// <summary> /// 绑定摘要信息 /// </summary> /// <param name="sType"></param> private void BindSlaver(string sType) { DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = myHelper.GetDs("select * from t_Abstract where (F_Type = '" + sType + "' or '" + sType + "' = '《所有类别》')"); gcAbstract.DataSource = ds.Tables[0].DefaultView; }
private void SaveReport(DevExpress.XtraReports.UI.XtraReport r) { MemoryStream stream = new MemoryStream(); r.SaveLayout(stream); DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = myHelper.GetDs("select * from t_Report where FType = '" + this.Name + "'"); DataRow dr = null; if (ds.Tables[0].Rows.Count == 0) { dr = ds.Tables[0].NewRow(); dr["FType"] = this.Name; dr["FName"] = this.Text; dr["FReport"] = stream.ToArray(); dr["FDefault"] = 1; ds.Tables[0].Rows.Add(dr); } else { dr = ds.Tables[0].Rows[0]; dr.BeginEdit(); dr["FReport"] = stream.ToArray(); dr.EndEdit(); } myHelper.SaveData(ds, "select * from t_Report where FType = '" + this.Name + "'"); }
/// <summary> /// 绑定库存信息 /// </summary> private void BindData() { DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds; string strSQL = @"select c.F_Name as F_StorageName,b.F_ID,b.F_Name,b.F_Spec,a.F_Unit, a.F_Grade,a.F_BatchNo,a.F_Color,b.F_Brand,b.F_Material,a.F_Qty,case when isnull(d.F_StockQty,0) < 0 then 0 else d.F_StockQty end as F_StockQty,d.F_TaskQty,d.F_SellQty, (case when isnull(a.F_Qty,0) - isnull(d.F_SellQty,0) < 0 then 0 else isnull(a.F_Qty,0) - isnull(d.F_SellQty,0) end) as F_EvaQty, b.F_Price from t_StorageQty a left join t_Item b on a.F_ItemID = b.F_ID left join t_Storage c on a.F_StorageID = c.F_ID left join v_ItemOtherStore d on a.F_ItemID = d.F_ItemID and a.F_Unit = d.F_Unit where a.F_ItemID in (" + strItemID + ")"; myHelper = new DataLib.DataHelper(); ds = myHelper.GetDs(strSQL); gcMain.DataSource = ds.Tables[0].DefaultView; //AssignField("", gvMain); DataLib.sysClass.LoadFormatFromDB(gvMain, this.Name, 0); }
/// <summary> /// 设置下拉框数据源 /// </summary> private void SetDropSource() { string strSQL = "select * from t_AssetType"; DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = myHelper.GetDs(strSQL); lupControl1.LookUpDataSource = ds.Tables[0].DefaultView; lupControl1.LookUpDisplayField = "F_Name"; lupControl1.LookUpKeyField = "F_Name"; ds.Dispose(); strSQL = "select F_ID,F_Name from t_Class where left(F_UPID,2) like '03%'"; ds = myHelper.GetDs(strSQL); lupControl2.LookUpDataSource = ds.Tables[0].DefaultView; lupControl2.LookUpDisplayField = "F_Name"; lupControl2.LookUpKeyField = "F_ID"; ds.Dispose(); strSQL = "select F_Name from t_AddType"; ds = myHelper.GetDs(strSQL); lupControl3.LookUpDataSource = ds.Tables[0].DefaultView; lupControl3.LookUpDisplayField = "F_Name"; lupControl3.LookUpKeyField = "F_Name"; ds.Dispose(); strSQL = "select F_Name from t_UseInfo"; ds = myHelper.GetDs(strSQL); lupControl4.LookUpDataSource = ds.Tables[0].DefaultView; lupControl4.LookUpDisplayField = "F_Name"; lupControl4.LookUpKeyField = "F_Name"; ds.Dispose(); }
protected override bool Save() { binData.EndEdit(); if (SavePre() == false) { return(false); } DataSet dsMaster = ((DataView)binData.DataSource).Table.DataSet; DataSet dsSlaver = ((DataView)gcDetail.DataSource).Table.DataSet; foreach (DataRow dr in dsSlaver.Tables[0].Rows) { dr["F_ID"] = editControl1.GetValue().ToString(); } DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet[] dsData = new DataSet[2]; dsData[0] = dsMaster; dsData[1] = dsSlaver; string[] strMSQL = new string[2]; strMSQL[0] = strSQL; strMSQL[1] = strSlaverSQL; if (myHelper.SaveMuteData(dsData, strMSQL).Length == 0) { return(true); } else { return(false); } }
private void DataBind(string strType) { DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = myHelper.GetDs("select * from t_Assist where F_Type = '" + strType + "'"); gcAssist.DataSource = ds.Tables[0].DefaultView; }
protected override void DataDel() { base.DataDel(); frmDelLog myDelLog = new frmDelLog(); if (myDelLog.ShowDialog() == DialogResult.OK) { DataLib.DataHelper myHeler = new DataLib.DataHelper(); if (myDelLog.ckAll.Checked == true) { if (myHeler.ExecuteSQL("truncate table t_UserLog") == 0) { BindData(); } } else { string strStart = myDelLog.deStart.EditValue.ToString() + " 00:00:00"; string strEnd = myDelLog.deEnd.EditValue.ToString() + " 23:59:59"; if (myHeler.ExecuteSQL("delete from t_UserLog where F_Time >= '" + strStart + "' and F_Time <='" + strEnd + "'") == 0) { BindData(); } } } myDelLog.Dispose(); }
/// <summary> /// 数据绑定 /// </summary> private void BindData() { DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = myHelper.GetDs("select * from t_BillCode order by F_ID"); GridBillCode.DataSource = ds.Tables[0].DefaultView; }
private void DataBind(string sBillType) { DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = myHelper.GetDs("select a.*,b.F_Name as F_Man from t_MultCheck a,t_User b where a.F_CheckMan = b.F_ID and a.F_BillType = '" + sBillType + "'"); gridCheck.DataSource = ds.Tables[0]; }
private void cbBill_SelectedIndexChanged(object sender, EventArgs e) { if (cbBill.Text.Length == 0) { return; } DataRow[] dr = dsTmp.Tables[0].Select("F_Class = '" + cbBill.Text + "'"); if (dr.Length == 0) { return; } strMasterSQL = dr[0]["F_MasterSQL"].ToString(); strSlaverSQL = dr[0]["F_SlaverSQL"].ToString(); DataLib.DataHelper myHelper = new DataLib.DataHelper(); if (strMasterSQL.Length > 0) { DataSet dsMaster; if (strValue == "") { dsMaster = myHelper.GetOtherDs(strMasterSQL, GetParm2()); } else { dsMaster = myHelper.GetOtherDs(strMasterSQL, GetParm3()); } gcMaster.DataSource = dsMaster.Tables[0].DefaultView; } }
private void lupDept_ValueChanged(object sender, EventArgs e) { if (lupDept.GetValue() == DBNull.Value) { return; } string strSQL = "select F_ID,F_Name from t_WorkGroup where F_DeptID = '" + lupDept.GetValue().ToString() + "'"; DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = myHelper.GetDs(strSQL); lupGroup.LookUpDataSource = ds.Tables[0].DefaultView; lupGroup.LookUpDisplayField = "F_Name"; lupGroup.LookUpKeyField = "F_ID"; ds.Dispose(); strSQL = "select F_ID,F_Name from t_Emp where F_Type = '" + lupDept.GetValue().ToString() + "'"; myHelper = new DataLib.DataHelper(); ds = myHelper.GetDs(strSQL); lupEmp.LookUpDataSource = ds.Tables[0].DefaultView; lupEmp.LookUpDisplayField = "F_Name"; lupEmp.LookUpKeyField = "F_ID"; ds.Dispose(); strSQL = strSQL = "select F_ID,F_Name from t_Process where F_DeptID = '" + lupDept.GetValue().ToString() + "'"; ds = myHelper.GetDs(strSQL); lupProcess.LookUpDataSource = ds.Tables[0].DefaultView; lupProcess.LookUpDisplayField = "F_Name"; lupProcess.LookUpKeyField = "F_ID"; ds.Dispose(); }
/// <summary> /// 是否一次性出库 /// </summary> /// <param name="dt"></param> /// <returns></returns> private bool TestOneOut(DataTable dt) { foreach (DataRow dr in dt.Rows) { if (dr["F_LinkBill"] == DBNull.Value) { return(true); } DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = myHelper.GetDs("select F_OneOut from t_Item where F_ID = '" + dr["F_ItemID"] + "'"); if (ds.Tables[0].Rows[0][0] == DBNull.Value) { return(true); } if (Convert.ToBoolean(ds.Tables[0].Rows[0][0]) == true) { DataSet dsOrder = myHelper.GetDs("select top 1 F_Qty from t_SellOrderDetail where F_BillID = '" + dr["F_LinkBill"].ToString() + "' and Aid = " + dr["PAid"].ToString()); if (dsOrder.Tables[0].Rows.Count > 0) { if (Convert.ToDecimal(dsOrder.Tables[0].Rows[0][0]) > Convert.ToDecimal(dr["F_Qty"])) { MessageBox.Show(this, "物料[" + dr["F_ItemID"].ToString() + "]设置了一次性出库,出库数量不能小于订单数量,订单数为" + dsOrder.Tables[0].Rows[0][0].ToString(), "提示"); return(false); } return(true); } return(true); } return(true); } return(true); }
/// <summary> /// 自定义 /// </summary> private void BindNeed() { DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = myHelper.GetDs("exec sp_NeedTmp"); gcItem.DataSource = ds.Tables[0].DefaultView; }
private void DataBind() { DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = myHelper.GetDs("select * from t_BankAccount"); gcList.DataSource = ds.Tables[0].DefaultView; }