/// <summary>
///物料条码规则 根据条件进行连接查询
/// </summary>
/// <param name="objs"></param>
/// <returns></returns>
public DataTable GetList(params object[] objs)
{
MdcdatMaterial mdcMt = new MdcdatMaterial();
T_Bllb_keyType_tbkt tbkt = new T_Bllb_keyType_tbkt();
mdcMt = (MdcdatMaterial)objs[0];
tbkt = (T_Bllb_keyType_tbkt)objs[1];
StringBuilder strSql = new StringBuilder();
strSql.Append(@" SELECT TBKM.TBKM_ID,TBKM.TBKT_ID,TBKM.MaterialCode,TBKT.KEY_NAME,TBKT.KEY_TYPE
FROM
T_Bllb_keyMaterial_tbkm AS TBKM
INNER JOIN
T_Bllb_keyType_tbkt AS TBKT
ON TBKM.TBKT_ID=TBKT.TBKT_ID" );
if (mdcMt.MaterialCode != null || tbkt.KeyName != null || tbkt.KeyType != null)
{
strSql.Append(" WHERE");
if (mdcMt.MaterialCode != null)
{
strSql.Append(string.Format(" TBKM.MaterialCode='{0}'", mdcMt.MaterialCode));
if (tbkt.KeyName != null)
{
strSql.Append(string.Format(" AND TBKT.KEY_NAME='{0}'", tbkt.KeyName));
}
if (tbkt.KeyType != null)
{
strSql.Append(string.Format(" AND TBKT.KEY_TYPE='{0}'", tbkt.KeyType));
}
}
else if (mdcMt.MaterialCode == null && tbkt.KeyName != null)
{
strSql.Append(string.Format(" TBKT.KEY_NAME='{0}'", tbkt.KeyName));
if (tbkt.KeyType != null)
{
strSql.Append(string.Format(" AND TBKT.KEY_TYPE='{0}'", tbkt.KeyType));
}
}
else if (mdcMt.MaterialCode == null && tbkt.KeyName == null && tbkt.KeyType != null)
{
strSql.Append(string.Format(" TBKT.KEY_TYPE='{0}'", tbkt.KeyType));
}
}
return(NMS.QueryDataTable(PubUtils.uContext, strSql.ToString()));
}
/// <summary>
/// 修改
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public static bool Update(MdcdatMaterial M)
{
string strSql = string.Format(@"update MdcdatMaterial set MaterialCode='{0}',MaterialName='{1}',Type='{2}',HouseCode='{3}',HouseCode1='{4}',HouseCode2='{5}',IsMSD='{6}',IsSendCheck='{7}',SecondMaterialClass='{8}',IncomingType='{9}',PackageType='{10}',PackagingMax='{11}',PackagingMin='{12}',ShelfLifeTime='{13}',SafeQty='{14}',Updator='{15}',UpdateTime=getdate() where MaterialCode='{0}'", M.MaterialCode, M.MaterialName, M.Type, M.HouseCode, M.HouseCode1, M.HouseCode2, M.IsMSD, M.IsSendCheck, M.SecondMaterialClass, M.INCOMINGTYPE, M.PackageType, M.PackagingMax, M.PackagingMin, SqlInput.ChangeNullToInt(M.ShelfLifeTime, 0), SqlInput.ChangeNullToInt(M.SafeQty, 0), PubUtils.uContext.UserID);
return(NMS.ExecTransql(PubUtils.uContext, strSql));
}
/// <summary>
/// 新增
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public static bool Insert(MdcdatMaterial M)
{
string strSql = string.Format("Insert into MdcdatMaterial(MaterialCode,MaterialName,Type,HouseCode,HouseCode1,HouseCode2,IsMSD,IsSendCheck,SecondMaterialClass,IncomingType,PackageType,PackagingMax,PackagingMin,ShelfLifeTime,SafeQty,Creator,CreateTime) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}',getdate())", M.MaterialCode, M.MaterialName, M.Type, M.HouseCode, M.HouseCode1, M.HouseCode2, M.IsMSD, M.IsSendCheck, M.SecondMaterialClass, M.INCOMINGTYPE, M.PackageType, M.PackagingMax, M.PackagingMin, M.ShelfLifeTime, M.SafeQty, PubUtils.uContext.UserID);
return(NMS.ExecTransql(PubUtils.uContext, strSql));
}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_ok_Click(object sender, EventArgs e)
{
MdcdatMaterial M = new MdcdatMaterial();
bool isSucess = false;
if (txt_materialCode.Text == string.Empty)
{
new PubUtils().ShowNoteNGMsg("料号不能为空", 1, grade.OrdinaryError);
return;
}
if (cbo_houseCode.SelectedValue.ToString() == string.Empty)
{
if (cbo_houseCode1.SelectedValue.ToString() != string.Empty || cbo_houseCode2.SelectedValue.ToString() != string.Empty)
{
MsgBox.Waring("请先选择默认仓库！");
return;
}
}
if (cbo_houseCode.SelectedValue.ToString() == cbo_houseCode1.SelectedValue.ToString() || cbo_houseCode.SelectedValue.ToString() == cbo_houseCode2.SelectedValue.ToString())
{
new PubUtils().ShowNoteNGMsg("备用仓库不能跟默认仓库相同", 2, grade.RepeatedError);
return;
}
if (cbo_houseCode1.SelectedValue.ToString() != string.Empty && cbo_houseCode2.SelectedValue.ToString() != string.Empty)
{
if (cbo_houseCode1.SelectedValue.ToString() == cbo_houseCode2.SelectedValue.ToString())
{
new PubUtils().ShowNoteNGMsg("备用仓库1不能跟备用仓库2相同", 2, grade.RepeatedError);
return;
}
}
M.MaterialCode = txt_materialCode.Text.Trim();
M.MaterialName = txt_materialName.Text.Trim();
if (cbo_Type.SelectedValue.ToString() != "-1")//类型
{
M.Type = cbo_Type.Text.ToString();
}
if (cbo_houseCode.SelectedValue.ToString() != "-1")//默认苍库
{
M.HouseCode = cbo_houseCode.SelectedValue.ToString();
}
M.HouseCode1 = cbo_houseCode1.SelectedValue.ToString();
M.HouseCode2 = cbo_houseCode2.SelectedValue.ToString();
if (cbo_isMSD.SelectedValue.ToString() != "-1")//是否MSD
{
M.IsMSD = cbo_isMSD.SelectedValue.ToString();
}
if (cbo_isSendCheck.SelectedValue.ToString() != "-1")//是否送检
{
M.IsSendCheck = cbo_isSendCheck.Text.Trim();
}
if (cbo_inComingType.SelectedValue.ToString() != "-1")//供料模式
{
M.INCOMINGTYPE = cbo_inComingType.SelectedValue.ToString();
}
if (cbo_secMateiralClass.Text != "")//辅材等级
{
M.SecondMaterialClass = cbo_secMateiralClass.Text.Trim();
}
M.PackageType = txt_packType.Text.Trim();
M.PackagingMax = txt_packMax.Text.Trim();
M.PackagingMin = txt_packMin.Text.Trim();
M.ShelfLifeTime = StringChange.ChangeNullToInt(txt_shelfLifeTime.Text.Trim(), 0);
M.SafeQty = StringChange.ChangeNullToInt(txt_safeQty.Text.Trim(), 0);
if (_isAddOrEdit == false)
{
string strSql = string.Format(@"select * from MdcdatMaterial where MaterialCode='{0}'", txt_materialCode.Text.Trim());
DataTable dt = NMS.QueryDataTable(PubUtils.uContext, strSql);
if (dt.Rows.Count > 0)
{
new PubUtils().ShowNoteNGMsg("料号已存在", 2, grade.RepeatedError);
return;
}
isSucess = MdcdatMaterial_DAL.Insert(M);
}
else
{
M.MaterialCode = obj.MaterialCode;
isSucess = MdcdatMaterial_DAL.Update(M);
}
if (isSucess)
{
new PubUtils().ShowNoteOKMsg("保存成功！");
this.result = DialogResult.OK;
this.Close();
}
}
