/// <summary>
/// 删除自动入库附表记录
/// </summary>
/// <param name="info"></param>
public void Del_AutoCreatePutIn_Subsidiary(ProductCode_AutoCreatePutIn_Subsidiary info)
{
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
var varData = from a in ctx.ProductCode_AutoCreatePutIn_Subsidiary
where a.GoodsID == info.GoodsID &&
a.ProductCode == info.ProductCode &&
a.PutInType == info.PutInType &&
a.StorageID == info.StorageID
select a;
ctx.ProductCode_AutoCreatePutIn_Subsidiary.DeleteAllOnSubmit(varData);
ctx.SubmitChanges();
}
/// <summary>
/// 添加自动入库附表记录
/// </summary>
/// <param name="info"></param>
public void Add_AutoCreatePutIn_Subsidiary(ProductCode_AutoCreatePutIn_Subsidiary info)
{
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
ProductCode_AutoCreatePutIn_Subsidiary newInfo = new ProductCode_AutoCreatePutIn_Subsidiary();
newInfo.GoodsID = info.GoodsID;
newInfo.ProductCode = info.ProductCode;
newInfo.PutInType = info.PutInType;
newInfo.StorageID = info.StorageID;
ctx.ProductCode_AutoCreatePutIn_Subsidiary.InsertOnSubmit(newInfo);
ctx.SubmitChanges();
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (dataGridView1.CurrentRow == null)
{
return;
}
ProductCode_AutoCreatePutIn_Subsidiary lnqTemp = new ProductCode_AutoCreatePutIn_Subsidiary();
lnqTemp.GoodsID = Convert.ToInt32(dataGridView1.CurrentRow.Cells["物品ID"].Value);
lnqTemp.ProductCode = dataGridView1.CurrentRow.Cells["箱体编号"].Value.ToString();
lnqTemp.PutInType = dataGridView1.CurrentRow.Cells["入库方式"].Value.ToString();
lnqTemp.StorageID = dataGridView1.CurrentRow.Cells["库房ID"].Value.ToString();
m_dtProductCodes.Rows.RemoveAt(dataGridView1.CurrentRow.Index);
dataGridView1.DataSource = m_dtProductCodes;
m_serverProductCode.Del_AutoCreatePutIn_Subsidiary(lnqTemp);
}
/// <summary>
/// 获得序号
/// </summary>
/// <param name="Dt">数据集</param>
/// <returns>返回获得序号后的数据集</returns>
//DataTable GetCountNumber(DataTable Dt)
//{
// for (int i = 0; i < Dt.Rows.Count; i++)
// {
// Dt.Rows[i]["序号"] = i + 1;
// }
// return Dt;
//}
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
txtProductCode.Text = txtProductCode.Text.ToUpper();
if (!CheckForm())
{
return;
}
//获得入库方式
cmbRKFS.Text = m_findSellIn.GetInStockWay(cmbProduct.Text.ToString(), txtProductCode.Text.ToString());
//检测钢印规则
if (!m_serverProductCode.VerifyProductCodesInfo(Convert.ToInt32(cmbProduct.Tag),
txtProductCode.Text.Trim(), GlobalObject.CE_BarCodeType.内部钢印码,
out m_err))
{
MessageDialog.ShowPromptMessage(m_err);
return;
}
if (!m_findSellIn.IsProductCodeOperationStandard(CE_MarketingType.入库.ToString(), typeof(CE_MarketingType),
Convert.ToInt32(cmbProduct.Tag), txtProductCode.Text,
cmbStorage.Tag.ToString(), out m_err))
{
MessageDialog.ShowPromptMessage(m_err);
return;
}
Service_Manufacture_WorkShop.IWorkShopBasic serverWorkShopBasic =
Service_Manufacture_WorkShop.ServerModuleFactory.GetServerModule <Service_Manufacture_WorkShop.IWorkShopBasic>();
WS_WorkShopCode tempWorkCode = serverWorkShopBasic.GetPersonnelWorkShop(BasicInfo.LoginID);
if (tempWorkCode == null)
{
throw new Exception("您不是车间人员，无法执行产品入库业务");
}
if (!m_findSellIn.IsProductCodeOperationStandard(CE_SubsidiaryOperationType.营销入库.ToString(), typeof(CE_SubsidiaryOperationType),
Convert.ToInt32(cmbProduct.Tag), txtProductCode.Text,
tempWorkCode.WSCode, out m_err))
{
MessageDialog.ShowPromptMessage(m_err);
return;
}
if (dataGridView1.DataSource != null)
{
m_dtProductCodes = (DataTable)dataGridView1.DataSource;
}
DataRow dr = m_dtProductCodes.NewRow();
dr["产品名称"] = cmbProduct.Text.ToString();
dr["箱体编号"] = txtProductCode.Text;
dr["入库方式"] = cmbRKFS.Text.ToString();
dr["入库库房"] = cmbStorage.Text.ToString();
dr["物品ID"] = Convert.ToInt32(cmbProduct.Tag);
dr["库房ID"] = cmbStorage.Tag.ToString();
ProductCode_AutoCreatePutIn_Subsidiary lnqTemp = new ProductCode_AutoCreatePutIn_Subsidiary();
lnqTemp.GoodsID = Convert.ToInt32(dr["物品ID"]);
lnqTemp.ProductCode = dr["箱体编号"].ToString();
lnqTemp.PutInType = dr["入库方式"].ToString();
lnqTemp.StorageID = dr["库房ID"].ToString();
if (!CheckSameGoods(dr))
{
return;
}
m_dtProductCodes.Rows.Add(dr);
dataGridView1.DataSource = m_dtProductCodes;
m_serverProductCode.Add_AutoCreatePutIn_Subsidiary(lnqTemp);
PositioningRecord(dr);
}
catch (Exception ex)
{
MessageDialog.ShowPromptMessage(ex.Message);
}
}
