public 工装编号录入窗体(string billno, int goodsID, CE_BusinessBillType businessType, bool isShow)
{
InitializeComponent();
m_strBillNo = billno;
m_intGoodsID = goodsID;
m_businessType = businessType;
if (isShow)
{
btnAdd.Visible = true;
btnUpdate.Visible = true;
btnDelete.Visible = true;
}
dataGridView1.DataSource = m_serverFrockStandingBook.GetFrockNumberFromBillNo(billno, goodsID);
}
public 量检具编号录入窗体(string billID, int goodsID, decimal goodsCount, CE_BusinessBillType businessType, bool isControlVisible)
{
InitializeComponent();
m_strBillID = billID;
m_intGoodsID = goodsID;
_GoodsCount = goodsCount;
string strSql = " and 物品ID = " + goodsID;
if (businessType == CE_BusinessBillType.入库)
{
txtGaugeCoding.ShowResultForm = false;
}
else
{
txtGaugeCoding.ShowResultForm = true;
if (!Convert.ToBoolean((int)businessType))
{
strSql += " and 在库 = 1 ";
}
else
{
strSql += " and 在库 = 0 ";
}
}
txtGaugeCoding.StrEndSql = strSql;
if (isControlVisible)
{
btnAdd.Visible = true;
btnUpdate.Visible = true;
btnDelete.Visible = true;
}
dataGridView1.DataSource = m_serverGaugeManage.GetGaugeCodingFromBillNo(billID, goodsID);
}
/// <summary>
/// 批量插入工装业务表
/// </summary>
/// <param name="billNo">业务单据号</param>
/// <param name="goodsID">物品ID</param>
/// <param name="frockNumberTable">单据业务的工装编码数据集</param>
/// <param name="businessType">业务类型</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>操作成功返回True，操作失败返回False</returns>
public bool UpdateFrockOperation(string billNo, int goodsID, DataTable frockNumberTable, CE_BusinessBillType businessType, out string error)
{
error = null;
try
{
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
var varData = from a in ctx.S_FrockOperation
where a.BillID == billNo &&
a.GoodsID == goodsID
select a;
ctx.S_FrockOperation.DeleteAllOnSubmit(varData);
for (int i = 0; i < frockNumberTable.Rows.Count; i++)
{
S_FrockOperation lnqOperation = new S_FrockOperation();
lnqOperation.BillID = billNo;
lnqOperation.BillTime = ServerTime.Time;
lnqOperation.BillType = businessType.ToString();
lnqOperation.FrockNumber = frockNumberTable.Rows[i]["FrockNumber"].ToString();
lnqOperation.GoodsID = goodsID;
lnqOperation.IsTrue = false;
ctx.S_FrockOperation.InsertOnSubmit(lnqOperation);
}
ctx.SubmitChanges();
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
