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;
}
