/// <summary>
/// 根据规格书编号查询相关信息
/// </summary>
/// <param name="modelgt"></param>
/// <param name="ghs"></param>
private void SelectSpec(Maticsoft.Model.tsuhan_sg_gt modelgt, string ghs)
{
//Maticsoft.Model.tsuhan_spec spec1 = sp.GetModel(ghs);
Maticsoft.Model.tsuhan_spec spec = specbll.GetModel(ghs);
if (modelgt.规格书编号 == spec.规格书)
{
this.txtCPBM.Text = spec.成品编码;
this.txtCPXH.Text = spec.产品型号;
this.tbKHDM.Text = spec.客户代码;
this.tbLDKINK.Text = Convert.ToString(spec.Pkinkmin);
this.tbPTKINK.Text = Convert.ToString(spec.Kimomin);
this.tbCSTJ.Text = spec.码型;
this.tbCSPL.Text = Convert.ToString(spec.速率);
this.tbLMDtype.Text = spec.PT方法;
this.tbLMDvalue.Text = Convert.ToString(spec.Sen);
this.tbICCmin.Text = Convert.ToString(spec.Iccmin);
this.tbICCmax.Text = Convert.ToString(spec.Iccmax);
this.tbIf.Text = Convert.ToString(spec.LD方法);
this.tbCCGLmin.Text = Convert.ToString(spec.Pomin);
this.tbCCGLmax.Text = Convert.ToString(spec.Pomax);
this.tbIMOmin.Text = Convert.ToString(spec.Imomin);
this.tbIMOmax.Text = Convert.ToString(spec.Imomax);
this.tbITHmin.Text = Convert.ToString(spec.Ithmin);
this.tbITHmax.Text = Convert.ToString(spec.Ithmax);
this.tbVFmin.Text = Convert.ToString(spec.Vfmin);
this.tbVFmax.Text = Convert.ToString(spec.Vfmax);
this.tbPTSL.Text = Convert.ToString(spec.速率);
this.tbVBRmin.Text = Convert.ToString(spec.Vbrmin);
this.tbVBRmax.Text = Convert.ToString(spec.Vbrmax);
}
}
/// <summary>
/// 查询单条记录
/// </summary>
/// <param name="备货单号"></param>
/// <returns></returns>
public tsuhan_sg_gt GetModel(string 备货单号)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,备货单号,交货日期,下单日期,表格编号,合同编号,规格书编号,产品名称,备货单数量,随工卡数量,产品图号,产品类型,成品编码,BK_A,BK_B,BK_C,LD_LDjj,GX_hjfs,OH_hqPomin,OH_hqPomax,OH_hqBFB,OH_hhPomin,OH_hhPomax,OH_hhBFB,DM_dmzl,PT_rqgl,PT_gdlmin,PT_gdlmax,GDW_xhcs,LD_CSPomin,LD_CSPomax,LD_CSBFB,LD_LDKINK,LD_PDKINK,PT_CStj,PT_CSpl,PT_LMd,PT_LMd2,PT_ICCmin,PT_ICCmax,BZ_QJbq,GD_if,GD_ccglMin,GD_ccglMax,GD_imoMin,GD_imoMax,GD_ithMin,GD_ithMax,GD_vfMin,GD_vfMax,GD_ptsl,GD_vbrMin,GD_vbrMax,JX_wdMin,JX_wdMax,JX_zz,JX_pthigh,JX_ptwwj,JX_ldgj,JX_ptgj,fh产品名称,Description,物料代码,型号属性,Specification,客户型号,LD芯片型号,PT芯片型号,Quantity1,Quantity2,数量,计划编制,技术审核,生产审核,录入员,录入时间,客户代码,生产日期 from tsuhan_sg_gt");
strSql.Append(" where 备货单号=@备货单号 ");
SqlParameter[] parameters =
{
new SqlParameter("@备货单号", SqlDbType.NVarChar, 30)
};
parameters[0].Value = 备货单号;
Maticsoft.Model.tsuhan_sg_gt model = new Maticsoft.Model.tsuhan_sg_gt();
DataSet ds = dbhelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnCHANGE_Click(object sender, EventArgs e)
{
DialogResult dr = MessageBox.Show("确定要修改吗？？？","提示",MessageBoxButtons.YesNo);
if (dr == DialogResult.Yes)
{
if (tbsgdxh1.Text.Trim() != "")
{
Maticsoft.Model.tsuhan_sg_gt mogt = new Maticsoft.Model.tsuhan_sg_gt();
var bhd = this.tbBHDH.Text;
var gt = gtbll.GetModel(bhd);
mogt.id = gt.id;
mogt.合同编号 = this.tbHTBH.Text;
mogt.备货单号 = this.tbBHDH.Text;
if (this.tbBHDSL.Text=="")
{
this.tbBHDSL.Text = "0";
}
mogt.备货单数量 = Convert.ToInt32(this.tbBHDSL.Text);
mogt.表格编号 = this.tbBGBH1.Text + "-" + this.tbBGBH2.Text;
mogt.产品名称 = this.cbCPMC.Text;
mogt.产品类型 = this.txtCPXH.Text;
mogt.成品编码 = this.txtCPBM.Text;
mogt.产品图号 = this.cbCPTH.Text;
mogt.客户代码 = this.tbKHDM.Text;
mogt.规格书编号 = this.cbGGSBH.Text;
mogt.计划编制 = this.tbJHBZ.Text;
mogt.技术审核 = this.tbJSSH.Text;
mogt.生产审核 = this.tbSCSH.Text;
mogt.交货日期 = Convert.ToDateTime(this.dTPjh.Text);
mogt.下单日期 = Convert.ToDateTime(this.dTPxd.Text);
mogt.录入时间 = Convert.ToDateTime(this.tsslLRTIMEtxt.Text);
mogt.录入员 = this.tsslLRYtxt.Text;
mogt.BK_A = this.tbAM.Text;
mogt.BK_B = this.tbBM.Text;
#region
if (this.tbCM2.Text == "")
{
this.tbCM2.Text = "0000";
}
mogt.BK_C = this.tbCM1.Text + "-" + this.tbCM2.Text;
if (this.tbSGKSL.Text == "")
{
mogt.随工卡数量 = null;
}
else
{
mogt.随工卡数量 = Convert.ToInt32(this.tbSGKSL.Text);
}
if (this.tbJJ.Text == "")
{
mogt.LD_LDjj = null;
}
else
{
mogt.LD_LDjj = Convert.ToDecimal(this.tbJJ.Text);
}
if (this.tbHQGLmin.Text == "")
{
mogt.GDW_xhcs = null;
}
else
{
mogt.GDW_xhcs = Convert.ToInt32(this.tbXHCS.Text);
}
if (this.tbHQGLmin.Text == "")
{
mogt.OH_hqPomin = null;
}
else
{
mogt.OH_hqPomin = Convert.ToDecimal(this.tbHQGLmin.Text);
}
if (this.tbHQGLmax.Text == "")
{
mogt.OH_hqPomax = null;
}
else
{
mogt.OH_hqPomax = Convert.ToDecimal(this.tbHQGLmax.Text);
}
if (this.tbHHGLmin.Text == "")
{
mogt.OH_hhPomin = null;
}
else
{
mogt.OH_hhPomin = Convert.ToDecimal(this.tbHHGLmin.Text);
}
if (this.tbHHGLmax.Text == "")
{
mogt.OH_hhPomax = null;
}
else
{
mogt.OH_hhPomax = Convert.ToDecimal(this.tbHHGLmax.Text);
}
if (this.tbRXGL.Text == "")
{
mogt.PT_rqgl = null;
}
else
{
mogt.PT_rqgl = Convert.ToInt32(this.tbRXGL.Text);
}
if (this.tbGDLmin.Text == "")
{
mogt.PT_gdlmin = null;
}
else
{
mogt.PT_gdlmin =this.tbGDLmin.Text;
}
if (this.tbGDLmax.Text == "")
{
mogt.PT_gdlmax = null;
}
else
{
mogt.PT_gdlmax = this.tbGDLmax.Text;
}
if (this.tbHQPo.Text == "")
{
mogt.OH_hqBFB = null;
}
else if (Convert.ToInt32(this.tbHQPo.Text.Trim()) > 100)
{
MessageBox.Show("输入的" + lblHQ.Text + "不能大于100", "提示");
return;
}
else if (Convert.ToInt32(this.tbHQPo.Text.Trim()) < 0)
{
MessageBox.Show("输入的" + lblHQ.Text + "不能小于0", "提示");
return;
}
else
{
mogt.OH_hqBFB = Convert.ToInt32(this.tbHQPo.Text);
}
if (this.tbHHPo.Text == "")
{
mogt.OH_hhBFB = null;
}
else if (Convert.ToInt32(this.tbHHPo.Text.Trim()) > 100)
{
MessageBox.Show("输入的" + lblHH.Text + "不能大于100", "提示");
return;
}
else if (Convert.ToInt32(this.tbHHPo.Text.Trim()) < 0)
{
MessageBox.Show("输入的" + lblHH.Text + "不能小于0", "提示");
return;
}
else
{
mogt.OH_hhBFB = Convert.ToInt32(this.tbHHPo.Text);
}
if (this.tbCSPo.Text == "")
{
mogt.LD_CSBFB = null;
}
else if (Convert.ToInt32(this.tbCSPo.Text.Trim()) > 100)
{
MessageBox.Show("输入的" + lblCS.Text + "不能大于100", "提示");
return;
}
else if (Convert.ToInt32(this.tbCSPo.Text.Trim()) < 0)
{
MessageBox.Show("输入的" + lblCS.Text + "不能小于0", "提示");
return;
}
else
{
mogt.LD_CSBFB = Convert.ToInt32(this.tbCSPo.Text);
}
if (this.tbCSWDmin.Text == "")
{
mogt.JX_wdMin = null;
}
else
{
mogt.JX_wdMin = Convert.ToInt32(this.tbCSWDmin.Text);
}
if (this.tbCSWDmax.Text == "")
{
mogt.JX_wdMax = null;
}
else
{
mogt.JX_wdMax = Convert.ToInt32(this.tbCSWDmax.Text);
}
#endregion
mogt.GX_hjfs = this.tbHJFS.Text;
mogt.DM_dmzl = this.tbDMZL.Text;
mogt.JX_ptwwj = this.tbPTWWJ.Text;
mogt.JX_zz = this.tbZZFX.Text;
mogt.JX_pthigh = this.tbPTGD.Text;
mogt.JX_ptgj = this.tbPTtype.Text;
mogt.JX_ldgj = this.tbLDtype.Text;
mogt.BZ_QJbq = this.cbQJBQ.Text;
if (this.tbLDKINK.Text == "")
{
this.tbLDKINK.Text = "0";
}
if (this.tbPTKINK.Text == "")
{
this.tbPTKINK.Text = "0";
}
if (this.tbICCmin.Text == "")
{
this.tbICCmin.Text = "0";
}
if (this.tbICCmax.Text == "")
{
this.tbICCmax.Text = "0";
}
if (this.tbIMOmin.Text == "")
{
this.tbIMOmin.Text = "0";
}
if (this.tbIMOmax.Text == "")
{
this.tbIMOmax.Text = "0";
}
if (this.tbCCGLmin.Text == "")
{
this.tbCCGLmin.Text = "0";
}
if (this.tbCCGLmax.Text == "")
{
this.tbCCGLmax.Text = "0";
}
if (this.tbITHmin.Text == "")
{
this.tbITHmin.Text = "0";
}
if (this.tbITHmax.Text == "")
{
this.tbITHmax.Text = "0";
}
if (this.tbVFmin.Text == "")
{
this.tbVFmin.Text = "0";
}
if (this.tbVFmax.Text == "")
{
this.tbVFmax.Text = "0";
}
if (this.tbVBRmin.Text == "")
{
this.tbVBRmin.Text = "0";
}
if (this.tbVBRmax.Text == "")
{
this.tbVBRmax.Text = "0";
}
if (this.tbCSmin.Text == "")
{
this.tbCSmin.Text = "0";
}
if (this.tbCSmax.Text == "")
{
this.tbCSmax.Text = "0";
}
mogt.LD_CSPomin = Convert.ToDecimal(this.tbCSmin.Text);
mogt.LD_CSPomax = Convert.ToDecimal(this.tbCSmax.Text);
mogt.LD_LDKINK = Convert.ToInt32(this.tbLDKINK.Text);
mogt.LD_PDKINK = Convert.ToInt32(this.tbPTKINK.Text);
mogt.GD_if = this.tbIf.Text;
mogt.PT_ICCmin = Convert.ToInt32(this.tbICCmin.Text);
mogt.PT_ICCmax = Convert.ToInt32(this.tbICCmax.Text);
mogt.GD_imoMin = Convert.ToInt32(this.tbIMOmin.Text);
mogt.GD_imoMax = Convert.ToInt32(this.tbIMOmax.Text);
mogt.GD_ccglMin = Convert.ToDecimal(this.tbCCGLmin.Text);
mogt.GD_ccglMax = Convert.ToDecimal(this.tbCCGLmax.Text);
mogt.GD_ithMin = Convert.ToInt32(this.tbITHmin.Text);
mogt.GD_ithMax = Convert.ToInt32(this.tbITHmax.Text);
mogt.GD_vfMin = Convert.ToDecimal(this.tbVFmin.Text);
mogt.GD_vfMax = Convert.ToDecimal(this.tbVFmax.Text);
mogt.GD_ptsl = this.tbPTSL.Text;
mogt.GD_vbrMin = Convert.ToInt32(this.tbVBRmin.Text);
mogt.GD_vbrMax = Convert.ToInt32(this.tbVBRmax.Text);
mogt.fh产品名称 = this.rtbCPMC.Text;
mogt.Description = this.tbDESCEIP.Text;
mogt.物料代码 = this.cbWLDM.Text;
mogt.型号属性 = this.cbXHSX.Text;
mogt.Specification = this.cbSPEC.Text;
mogt.客户型号 = this.cbKHXH.Text;
mogt.LD芯片型号 = this.cbLDCHIPXH.Text;
mogt.PT芯片型号 = this.cbPTCHIPXH.Text;
mogt.生产日期 = Convert.ToDateTime(this.textBox1.Text);
mogt.Quantity1 = this.tbQUA_PO.Text;
mogt.Quantity2 = this.tbQUA_SEN.Text;
mogt.数量 = this.tbSL.Text;
bool result = false;
try
{
result = gtbll.Update(mogt);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
if (result == true)
{
MessageBox.Show("修改成功", "提示");
}
else
{
MessageBox.Show("修改失败", "提示");
}
}
}
else if (dr==DialogResult.No)
{
return;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public tsuhan_sg_gt DataRowToModel(DataRow row)
{
Maticsoft.Model.tsuhan_sg_gt model = new Maticsoft.Model.tsuhan_sg_gt();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["备货单号"] != null)
{
model.备货单号 = row["备货单号"].ToString();
}
if (row["交货日期"] != null && row["交货日期"].ToString() != "")
{
model.交货日期 = DateTime.Parse(row["交货日期"].ToString());
}
if (row["下单日期"] != null && row["下单日期"].ToString() != "")
{
model.单日期 = DateTime.Parse(row["下单日期"].ToString());
}
if (row["表格编号"] != null)
{
model.表格编号 = row["表格编号"].ToString();
}
if (row["合同编号"] != null)
{
model.合同编号 = row["合同编号"].ToString();
}
if (row["规格书编号"] != null)
{
model.规格书编号 = row["规格书编号"].ToString();
}
if (row["产品名称"] != null)
{
model.产品名称 = row["产品名称"].ToString();
}
if (row["备货单数量"] != null && row["备货单数量"].ToString() != "")
{
model.备货单数量 = int.Parse(row["备货单数量"].ToString());
}
if (row["随工卡数量"] != null && row["随工卡数量"].ToString() != "")
{
model.随工卡数量 = int.Parse(row["随工卡数量"].ToString());
}
if (row["产品图号"] != null)
{
model.产品图号 = row["产品图号"].ToString();
}
if (row["产品类型"] != null)
{
model.产品类型 = row["产品类型"].ToString();
}
if (row["成品编码"] != null)
{
model.成品编码 = row["成品编码"].ToString();
}
if (row["BK_A"] != null)
{
model.BK_A = row["BK_A"].ToString();
}
if (row["BK_B"] != null)
{
model.BK_B = row["BK_B"].ToString();
}
if (row["BK_C"] != null)
{
model.BK_C = row["BK_C"].ToString();
}
if (row["LD_LDjj"] != null && row["LD_LDjj"].ToString() != "")
{
model.LD_LDjj = decimal.Parse(row["LD_LDjj"].ToString());
}
if (row["GX_hjfs"] != null)
{
model.GX_hjfs = row["GX_hjfs"].ToString();
}
if (row["OH_hqPomin"] != null && row["OH_hqPomin"].ToString() != "")
{
model.OH_hqPomin = decimal.Parse(row["OH_hqPomin"].ToString());
}
if (row["OH_hqPomax"] != null && row["OH_hqPomax"].ToString() != "")
{
model.OH_hqPomax = decimal.Parse(row["OH_hqPomax"].ToString());
}
if (row["OH_hqBFB"] != null && row["OH_hqBFB"].ToString() != "")
{
model.OH_hqBFB = int.Parse(row["OH_hqBFB"].ToString());
}
if (row["OH_hhPomin"] != null && row["OH_hhPomin"].ToString() != "")
{
model.OH_hhPomin = decimal.Parse(row["OH_hhPomin"].ToString());
}
if (row["OH_hhPomax"] != null && row["OH_hhPomax"].ToString() != "")
{
model.OH_hhPomax = decimal.Parse(row["OH_hhPomax"].ToString());
}
if (row["OH_hhBFB"] != null && row["OH_hhBFB"].ToString() != "")
{
model.OH_hhBFB = int.Parse(row["OH_hhBFB"].ToString());
}
if (row["DM_dmzl"] != null)
{
model.DM_dmzl = row["DM_dmzl"].ToString();
}
if (row["PT_rqgl"] != null && row["PT_rqgl"].ToString() != "")
{
model.PT_rqgl = int.Parse(row["PT_rqgl"].ToString());
}
if (row["PT_gdlmin"] != null)
{
model.PT_gdlmin = row["PT_gdlmin"].ToString();
}
if (row["PT_gdlmax"] != null)
{
model.PT_gdlmax = row["PT_gdlmax"].ToString();
}
if (row["GDW_xhcs"] != null && row["GDW_xhcs"].ToString() != "")
{
model.GDW_xhcs = int.Parse(row["GDW_xhcs"].ToString());
}
if (row["LD_CSPomin"] != null && row["LD_CSPomin"].ToString() != "")
{
model.LD_CSPomin = decimal.Parse(row["LD_CSPomin"].ToString());
}
if (row["LD_CSPomax"] != null && row["LD_CSPomax"].ToString() != "")
{
model.LD_CSPomax = decimal.Parse(row["LD_CSPomax"].ToString());
}
if (row["LD_CSBFB"] != null && row["LD_CSBFB"].ToString() != "")
{
model.LD_CSBFB = int.Parse(row["LD_CSBFB"].ToString());
}
if (row["LD_LDKINK"] != null && row["LD_LDKINK"].ToString() != "")
{
model.LD_LDKINK = int.Parse(row["LD_LDKINK"].ToString());
}
if (row["LD_PDKINK"] != null && row["LD_PDKINK"].ToString() != "")
{
model.LD_PDKINK = int.Parse(row["LD_PDKINK"].ToString());
}
if (row["PT_CStj"] != null)
{
model.PT_CStj = row["PT_CStj"].ToString();
}
if (row["PT_CSpl"] != null && row["PT_CSpl"].ToString() != "")
{
model.PT_CSpl = decimal.Parse(row["PT_CSpl"].ToString());
}
if (row["PT_LMd"] != null)
{
model.PT_LMd = row["PT_LMd"].ToString();
}
if (row["PT_LMd2"] != null)
{
model.PT_LMd2 = row["PT_LMd2"].ToString();
}
if (row["PT_ICCmin"] != null && row["PT_ICCmin"].ToString() != "")
{
model.PT_ICCmin = int.Parse(row["PT_ICCmin"].ToString());
}
if (row["PT_ICCmax"] != null && row["PT_ICCmax"].ToString() != "")
{
model.PT_ICCmax = int.Parse(row["PT_ICCmax"].ToString());
}
if (row["BZ_QJbq"] != null)
{
model.BZ_QJbq = row["BZ_QJbq"].ToString();
}
if (row["GD_if"] != null)
{
model.GD_if = row["GD_if"].ToString();
}
if (row["GD_ccglMin"] != null && row["GD_ccglMin"].ToString() != "")
{
model.GD_ccglMin = decimal.Parse(row["GD_ccglMin"].ToString());
}
if (row["GD_ccglMax"] != null && row["GD_ccglMax"].ToString() != "")
{
model.GD_ccglMax = decimal.Parse(row["GD_ccglMax"].ToString());
}
if (row["GD_imoMin"] != null && row["GD_imoMin"].ToString() != "")
{
model.GD_imoMin = int.Parse(row["GD_imoMin"].ToString());
}
if (row["GD_imoMax"] != null && row["GD_imoMax"].ToString() != "")
{
model.GD_imoMax = int.Parse(row["GD_imoMax"].ToString());
}
if (row["GD_ithMin"] != null && row["GD_ithMin"].ToString() != "")
{
model.GD_ithMin = int.Parse(row["GD_ithMin"].ToString());
}
if (row["GD_ithMax"] != null && row["GD_ithMax"].ToString() != "")
{
model.GD_ithMax = int.Parse(row["GD_ithMax"].ToString());
}
if (row["GD_vfMin"] != null && row["GD_vfMin"].ToString() != "")
{
model.GD_vfMin = decimal.Parse(row["GD_vfMin"].ToString());
}
if (row["GD_vfMax"] != null && row["GD_vfMax"].ToString() != "")
{
model.GD_vfMax = decimal.Parse(row["GD_vfMax"].ToString());
}
if (row["GD_ptsl"] != null)
{
model.GD_ptsl = row["GD_ptsl"].ToString();
}
if (row["GD_vbrMin"] != null && row["GD_vbrMin"].ToString() != "")
{
model.GD_vbrMin = int.Parse(row["GD_vbrMin"].ToString());
}
if (row["GD_vbrMax"] != null && row["GD_vbrMax"].ToString() != "")
{
model.GD_vbrMax = int.Parse(row["GD_vbrMax"].ToString());
}
if (row["JX_wdMin"] != null && row["JX_wdMin"].ToString() != "")
{
model.JX_wdMin = int.Parse(row["JX_wdMin"].ToString());
}
if (row["JX_wdMax"] != null && row["JX_wdMax"].ToString() != "")
{
model.JX_wdMax = int.Parse(row["JX_wdMax"].ToString());
}
if (row["JX_zz"] != null)
{
model.JX_zz = row["JX_zz"].ToString();
}
if (row["JX_pthigh"] != null)
{
model.JX_pthigh = row["JX_pthigh"].ToString();
}
if (row["JX_ptwwj"] != null)
{
model.JX_ptwwj = row["JX_ptwwj"].ToString();
}
if (row["JX_ldgj"] != null)
{
model.JX_ldgj = row["JX_ldgj"].ToString();
}
if (row["JX_ptgj"] != null)
{
model.JX_ptgj = row["JX_ptgj"].ToString();
}
if (row["fh产品名称"] != null)
{
model.fh产品名称 = row["fh产品名称"].ToString();
}
if (row["Description"] != null)
{
model.Description = row["Description"].ToString();
}
if (row["物料代码"] != null)
{
model.物料代码 = row["物料代码"].ToString();
}
if (row["型号属性"] != null)
{
model.型号属性 = row["型号属性"].ToString();
}
if (row["Specification"] != null)
{
model.Specification = row["Specification"].ToString();
}
if (row["客户型号"] != null)
{
model.客户型号 = row["客户型号"].ToString();
}
if (row["LD芯片型号"] != null)
{
model.LD芯片型号 = row["LD芯片型号"].ToString();
}
if (row["PT芯片型号"] != null)
{
model.PT芯片型号 = row["PT芯片型号"].ToString();
}
if (row["Quantity1"] != null)
{
model.Quantity1 = row["Quantity1"].ToString();
}
if (row["Quantity2"] != null)
{
model.Quantity2 = row["Quantity2"].ToString();
}
if (row["数量"] != null)
{
model.数量 = row["数量"].ToString();
}
if (row["计划编制"] != null)
{
model.计划编制 = row["计划编制"].ToString();
}
if (row["技术审核"] != null)
{
model.技术审核 = row["技术审核"].ToString();
}
if (row["生产审核"] != null)
{
model.生产审核 = row["生产审核"].ToString();
}
if (row["录入员"] != null)
{
model.录入员 = row["录入员"].ToString();
}
if (row["录入时间"] != null && row["录入时间"].ToString() != "")
{
model.录入时间 = DateTime.Parse(row["录入时间"].ToString());
}
if (row["客户代码"] != null)
{
model.客户代码 = row["客户代码"].ToString();
}
if (row["生产日期"] != null && row["生产日期"].ToString() != "")
{
model.生产日期 = DateTime.Parse(row["生产日期"].ToString());
}
}
return(model);
}
/// <summary>
/// 修改tsuhan_sg_gt表信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Update(Maticsoft.Model.tsuhan_sg_gt model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tsuhan_sg_gt set ");
strSql.Append("交货日期=@交货日期,");
strSql.Append("下单日期=@下单日期,");
strSql.Append("表格编号=@表格编号,");
strSql.Append("合同编号=@合同编号,");
strSql.Append("规格书编号=@规格书编号,");
strSql.Append("产品名称=@产品名称,");
strSql.Append("备货单数量=@备货单数量,");
strSql.Append("随工卡数量=@随工卡数量,");
strSql.Append("产品图号=@产品图号,");
strSql.Append("产品类型=@产品类型,");
strSql.Append("成品编码=@成品编码,");
strSql.Append("BK_A=@BK_A,");
strSql.Append("BK_B=@BK_B,");
strSql.Append("BK_C=@BK_C,");
strSql.Append("LD_LDjj=@LD_LDjj,");
strSql.Append("GX_hjfs=@GX_hjfs,");
strSql.Append("OH_hqPomin=@OH_hqPomin,");
strSql.Append("OH_hqPomax=@OH_hqPomax,");
strSql.Append("OH_hqBFB=@OH_hqBFB,");
strSql.Append("OH_hhPomin=@OH_hhPomin,");
strSql.Append("OH_hhPomax=@OH_hhPomax,");
strSql.Append("OH_hhBFB=@OH_hhBFB,");
strSql.Append("DM_dmzl=@DM_dmzl,");
strSql.Append("PT_rqgl=@PT_rqgl,");
strSql.Append("PT_gdlmin=@PT_gdlmin,");
strSql.Append("PT_gdlmax=@PT_gdlmax,");
strSql.Append("GDW_xhcs=@GDW_xhcs,");
strSql.Append("LD_CSPomin=@LD_CSPomin,");
strSql.Append("LD_CSPomax=@LD_CSPomax,");
strSql.Append("LD_CSBFB=@LD_CSBFB,");
strSql.Append("LD_LDKINK=@LD_LDKINK,");
strSql.Append("LD_PDKINK=@LD_PDKINK,");
strSql.Append("PT_CStj=@PT_CStj,");
strSql.Append("PT_CSpl=@PT_CSpl,");
strSql.Append("PT_LMd=@PT_LMd,");
strSql.Append("PT_LMd2=@PT_LMd2,");
strSql.Append("PT_ICCmin=@PT_ICCmin,");
strSql.Append("PT_ICCmax=@PT_ICCmax,");
strSql.Append("BZ_QJbq=@BZ_QJbq,");
strSql.Append("GD_if=@GD_if,");
strSql.Append("GD_ccglMin=@GD_ccglMin,");
strSql.Append("GD_ccglMax=@GD_ccglMax,");
strSql.Append("GD_imoMin=@GD_imoMin,");
strSql.Append("GD_imoMax=@GD_imoMax,");
strSql.Append("GD_ithMin=@GD_ithMin,");
strSql.Append("GD_ithMax=@GD_ithMax,");
strSql.Append("GD_vfMin=@GD_vfMin,");
strSql.Append("GD_vfMax=@GD_vfMax,");
strSql.Append("GD_ptsl=@GD_ptsl,");
strSql.Append("GD_vbrMin=@GD_vbrMin,");
strSql.Append("GD_vbrMax=@GD_vbrMax,");
strSql.Append("JX_wdMin=@JX_wdMin,");
strSql.Append("JX_wdMax=@JX_wdMax,");
strSql.Append("JX_zz=@JX_zz,");
strSql.Append("JX_pthigh=@JX_pthigh,");
strSql.Append("JX_ptwwj=@JX_ptwwj,");
strSql.Append("JX_ldgj=@JX_ldgj,");
strSql.Append("JX_ptgj=@JX_ptgj,");
strSql.Append("fh产品名称=@fh产品名称,");
strSql.Append("Description=@Description,");
strSql.Append("物料代码=@物料代码,");
strSql.Append("型号属性=@型号属性,");
strSql.Append("Specification=@Specification,");
strSql.Append("客户型号=@客户型号,");
strSql.Append("LD芯片型号=@LD芯片型号,");
strSql.Append("PT芯片型号=@PT芯片型号,");
strSql.Append("Quantity1=@Quantity1,");
strSql.Append("Quantity2=@Quantity2,");
strSql.Append("数量=@数量,");
strSql.Append("计划编制=@计划编制,");
strSql.Append("技术审核=@技术审核,");
strSql.Append("生产审核=@生产审核,");
strSql.Append("录入员=@录入员,");
strSql.Append("录入时间=@录入时间,");
strSql.Append("客户代码=@客户代码,");
strSql.Append("生产日期=@生产日期");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@交货日期", SqlDbType.DateTime),
new SqlParameter("@下单日期", SqlDbType.DateTime),
new SqlParameter("@表格编号", SqlDbType.NVarChar, 20),
new SqlParameter("@合同编号", SqlDbType.NVarChar, 40),
new SqlParameter("@规格书编号", SqlDbType.NVarChar, 40),
new SqlParameter("@产品名称", SqlDbType.NVarChar, 50),
new SqlParameter("@备货单数量", SqlDbType.Int, 4),
new SqlParameter("@随工卡数量", SqlDbType.Int, 4),
new SqlParameter("@产品图号", SqlDbType.NVarChar, 20),
new SqlParameter("@产品类型", SqlDbType.NVarChar, 10),
new SqlParameter("@成品编码", SqlDbType.NVarChar, 40),
new SqlParameter("@BK_A", SqlDbType.NVarChar, 40),
new SqlParameter("@BK_B", SqlDbType.NVarChar, 40),
new SqlParameter("@BK_C", SqlDbType.NVarChar, 40),
new SqlParameter("@LD_LDjj", SqlDbType.Float, 8),
new SqlParameter("@GX_hjfs", SqlDbType.NVarChar, 15),
new SqlParameter("@OH_hqPomin", SqlDbType.Float, 8),
new SqlParameter("@OH_hqPomax", SqlDbType.Float, 8),
new SqlParameter("@OH_hqBFB", SqlDbType.Int, 4),
new SqlParameter("@OH_hhPomin", SqlDbType.Float, 8),
new SqlParameter("@OH_hhPomax", SqlDbType.Float, 8),
new SqlParameter("@OH_hhBFB", SqlDbType.Int, 4),
new SqlParameter("@DM_dmzl", SqlDbType.NVarChar, 40),
new SqlParameter("@PT_rqgl", SqlDbType.Int, 4),
new SqlParameter("@PT_gdlmin", SqlDbType.NVarChar, 20),
new SqlParameter("@PT_gdlmax", SqlDbType.NVarChar, 20),
new SqlParameter("@GDW_xhcs", SqlDbType.Int, 4),
new SqlParameter("@LD_CSPomin", SqlDbType.Float, 8),
new SqlParameter("@LD_CSPomax", SqlDbType.Float, 8),
new SqlParameter("@LD_CSBFB", SqlDbType.Int, 4),
new SqlParameter("@LD_LDKINK", SqlDbType.Int, 4),
new SqlParameter("@LD_PDKINK", SqlDbType.Int, 4),
new SqlParameter("@PT_CStj", SqlDbType.NVarChar, 20),
new SqlParameter("@PT_CSpl", SqlDbType.Float, 8),
new SqlParameter("@PT_LMd", SqlDbType.NVarChar, 10),
new SqlParameter("@PT_LMd2", SqlDbType.NVarChar, 10),
new SqlParameter("@PT_ICCmin", SqlDbType.Int, 4),
new SqlParameter("@PT_ICCmax", SqlDbType.Int, 4),
new SqlParameter("@BZ_QJbq", SqlDbType.NVarChar, 20),
new SqlParameter("@GD_if", SqlDbType.NVarChar, 10),
new SqlParameter("@GD_ccglMin", SqlDbType.Float, 8),
new SqlParameter("@GD_ccglMax", SqlDbType.Float, 8),
new SqlParameter("@GD_imoMin", SqlDbType.Int, 4),
new SqlParameter("@GD_imoMax", SqlDbType.Int, 4),
new SqlParameter("@GD_ithMin", SqlDbType.Int, 4),
new SqlParameter("@GD_ithMax", SqlDbType.Int, 4),
new SqlParameter("@GD_vfMin", SqlDbType.Float, 8),
new SqlParameter("@GD_vfMax", SqlDbType.Float, 8),
new SqlParameter("@GD_ptsl", SqlDbType.NVarChar, 10),
new SqlParameter("@GD_vbrMin", SqlDbType.Int, 4),
new SqlParameter("@GD_vbrMax", SqlDbType.Int, 4),
new SqlParameter("@JX_wdMin", SqlDbType.Int, 4),
new SqlParameter("@JX_wdMax", SqlDbType.Int, 4),
new SqlParameter("@JX_zz", SqlDbType.NVarChar, 10),
new SqlParameter("@JX_pthigh", SqlDbType.NVarChar, 20),
new SqlParameter("@JX_ptwwj", SqlDbType.NVarChar, 20),
new SqlParameter("@JX_ldgj", SqlDbType.NVarChar, 2),
new SqlParameter("@JX_ptgj", SqlDbType.NVarChar, 2),
new SqlParameter("@fh产品名称", SqlDbType.NVarChar, 50),
new SqlParameter("@Description", SqlDbType.NVarChar, 50),
new SqlParameter("@物料代码", SqlDbType.NVarChar, 30),
new SqlParameter("@型号属性", SqlDbType.NVarChar, 30),
new SqlParameter("@Specification", SqlDbType.NVarChar, 30),
new SqlParameter("@客户型号", SqlDbType.NVarChar, 50),
new SqlParameter("@LD芯片型号", SqlDbType.NVarChar, 20),
new SqlParameter("@PT芯片型号", SqlDbType.NVarChar, 20),
new SqlParameter("@Quantity1", SqlDbType.NVarChar, 50),
new SqlParameter("@Quantity2", SqlDbType.NVarChar, 50),
new SqlParameter("@数量", SqlDbType.NVarChar, 10),
new SqlParameter("@计划编制", SqlDbType.NVarChar, 10),
new SqlParameter("@技术审核", SqlDbType.NVarChar, 10),
new SqlParameter("@生产审核", SqlDbType.NVarChar, 10),
new SqlParameter("@录入员", SqlDbType.NVarChar, 10),
new SqlParameter("@录入时间", SqlDbType.DateTime),
new SqlParameter("@客户代码", SqlDbType.NVarChar, 10),
new SqlParameter("@生产日期", SqlDbType.DateTime),
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@备货单号", SqlDbType.NVarChar, 30)
};
parameters[0].Value = model.交货日期;
parameters[1].Value = model.单日期;
parameters[2].Value = model.表格编号;
parameters[3].Value = model.合同编号;
parameters[4].Value = model.规格书编号;
parameters[5].Value = model.产品名称;
parameters[6].Value = model.备货单数量;
parameters[7].Value = model.随工卡数量;
parameters[8].Value = model.产品图号;
parameters[9].Value = model.产品类型;
parameters[10].Value = model.成品编码;
parameters[11].Value = model.BK_A;
parameters[12].Value = model.BK_B;
parameters[13].Value = model.BK_C;
parameters[14].Value = model.LD_LDjj;
parameters[15].Value = model.GX_hjfs;
parameters[16].Value = model.OH_hqPomin;
parameters[17].Value = model.OH_hqPomax;
parameters[18].Value = model.OH_hqBFB;
parameters[19].Value = model.OH_hhPomin;
parameters[20].Value = model.OH_hhPomax;
parameters[21].Value = model.OH_hhBFB;
parameters[22].Value = model.DM_dmzl;
parameters[23].Value = model.PT_rqgl;
parameters[24].Value = model.PT_gdlmin;
parameters[25].Value = model.PT_gdlmax;
parameters[26].Value = model.GDW_xhcs;
parameters[27].Value = model.LD_CSPomin;
parameters[28].Value = model.LD_CSPomax;
parameters[29].Value = model.LD_CSBFB;
parameters[30].Value = model.LD_LDKINK;
parameters[31].Value = model.LD_PDKINK;
parameters[32].Value = model.PT_CStj;
parameters[33].Value = model.PT_CSpl;
parameters[34].Value = model.PT_LMd;
parameters[35].Value = model.PT_LMd2;
parameters[36].Value = model.PT_ICCmin;
parameters[37].Value = model.PT_ICCmax;
parameters[38].Value = model.BZ_QJbq;
parameters[39].Value = model.GD_if;
parameters[40].Value = model.GD_ccglMin;
parameters[41].Value = model.GD_ccglMax;
parameters[42].Value = model.GD_imoMin;
parameters[43].Value = model.GD_imoMax;
parameters[44].Value = model.GD_ithMin;
parameters[45].Value = model.GD_ithMax;
parameters[46].Value = model.GD_vfMin;
parameters[47].Value = model.GD_vfMax;
parameters[48].Value = model.GD_ptsl;
parameters[49].Value = model.GD_vbrMin;
parameters[50].Value = model.GD_vbrMax;
parameters[51].Value = model.JX_wdMin;
parameters[52].Value = model.JX_wdMax;
parameters[53].Value = model.JX_zz;
parameters[54].Value = model.JX_pthigh;
parameters[55].Value = model.JX_ptwwj;
parameters[56].Value = model.JX_ldgj;
parameters[57].Value = model.JX_ptgj;
parameters[58].Value = model.fh产品名称;
parameters[59].Value = model.Description;
parameters[60].Value = model.物料代码;
parameters[61].Value = model.型号属性;
parameters[62].Value = model.Specification;
parameters[63].Value = model.客户型号;
parameters[64].Value = model.LD芯片型号;
parameters[65].Value = model.PT芯片型号;
parameters[66].Value = model.Quantity1;
parameters[67].Value = model.Quantity2;
parameters[68].Value = model.数量;
parameters[69].Value = model.计划编制;
parameters[70].Value = model.技术审核;
parameters[71].Value = model.生产审核;
parameters[72].Value = model.录入员;
parameters[73].Value = model.录入时间;
parameters[74].Value = model.客户代码;
parameters[75].Value = model.生产日期;
parameters[76].Value = model.id;
parameters[77].Value = model.备货单号;
int rows = dbhelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 修改tsuhan_sg_gt表信息
/// </summary>
/// <param name="mogt"></param>
/// <returns></returns>
public bool Update(tsuhan_sg_gt mogt)
{
return gtdal.Update(mogt);
}
/// <summary>
/// 新增tsuhan_sg_gt表信息
/// </summary>
/// <param name="mogt"></param>
/// <returns></returns>
public bool Add(tsuhan_sg_gt mogt)
{
return gtdal.Add(mogt);
}
//private void tbsgdxh1_MouseLeave(object sender, EventArgs e)
//{
// SelectDan();
//}
/// <summary>
/// 根据备货单号查询
/// </summary>
private void SelectDan()
{
if (tbsgdxh1.Text == string.Empty || tbsgdxh1.Text == "00000")
{
MessageBox.Show("请填写备货单号", "警告");
this.btnOK.Enabled = false;
return;
}
else
{
var tbs = this.tbsgdxh1.Text.Trim();
bool result;
//根据备货单号查询信息
result = gtbll.Exists(tbs);
if (result != true)
{
MessageBox.Show("此单号还没有录入数据", "提示");
var gt = yhbll.GetModel(gh);
this.tsslLRYtxt.Text = gt.姓名;
this.tsslLRTIMEtxt.Text = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
this.tbFHBHDH.Text = this.tbsgdxh1.Text;
this.tbHTH.Text = this.tbHTBH.Text;
btnUPDATA.Enabled = true;
btnCHANGE.BackColor = Color.SlateBlue;
btnCHANGE.Enabled = false;
btnCHANGE.BackColor = Color.Gray;
btnOK.Enabled = true;
btnOK.BackColor = Color.SlateBlue;
this.tbBHDH.Text = this.tbsgdxh1.Text;
SelectSpec2();
return;
}
else
{
btnUPDATA.Enabled = false;
btnUPDATA.BackColor = Color.Gray;
btnCHANGE.Enabled = true;
btnCHANGE.BackColor = Color.SlateBlue;
btnOK.Enabled = false;
btnOK.BackColor = Color.Gray;
Maticsoft.Model.tsuhan_sg_gt modelgt = gtbll.GetModel(tbs);
this.tbHTBH.Text = modelgt.合同编号;
var ghs = this.cbGGSBH.Text = modelgt.规格书编号;
SelectSpec(modelgt, ghs);
#region tsuhan_sg_gt
this.cbQJBQ.Text = modelgt.BZ_QJbq;
this.dTPjh.Text = Convert.ToString(modelgt.交货日期);
this.dTPxd.Text = Convert.ToString(modelgt.单日期);
string tb = modelgt.表格编号;
string[] tbbgbh = tb.Split(new char[1] {
'-'
});
this.tbBGBH1.Text = tbbgbh[0];
this.tbBGBH2.Text = tbbgbh[1];
this.cbCPMC.Text = modelgt.产品名称;
this.tbBHDH.Text = modelgt.备货单号;
this.tbBHDSL.Text = Convert.ToString(modelgt.备货单数量);
this.cbCPTH.Text = modelgt.产品图号;
this.txtCPXH.Text = modelgt.产品类型;
this.txtCPBM.Text = modelgt.成品编码;
this.tbKHDM.Text = modelgt.客户代码;
this.tbSGKSL.Text = Convert.ToString(modelgt.随工卡数量);
this.tbAM.Text = modelgt.BK_A;
this.tbBM.Text = modelgt.BK_B;
string tbcm = modelgt.BK_C;
string[] tbCM = tbcm.Split(new char[1] {
'-'
});
this.tbCM1.Text = tbCM[0];
this.tbCM2.Text = tbCM[1];
this.tbJJ.Text = Convert.ToString(modelgt.LD_LDjj);
this.tbHJFS.Text = modelgt.GX_hjfs;
this.tbDMZL.Text = modelgt.DM_dmzl;
this.tbXHCS.Text = Convert.ToString(modelgt.GDW_xhcs);
this.tbHQGLmin.Text = Convert.ToString(modelgt.OH_hqPomin);
this.tbHQGLmax.Text = Convert.ToString(modelgt.OH_hqPomax);
this.tbHHGLmin.Text = Convert.ToString(modelgt.OH_hhPomin);
this.tbHHGLmax.Text = Convert.ToString(modelgt.OH_hhPomax);
this.tbRXGL.Text = Convert.ToString(modelgt.PT_rqgl);;
this.tbGDLmin.Text = Convert.ToString(modelgt.PT_gdlmin);
this.tbGDLmax.Text = Convert.ToString(modelgt.PT_gdlmax);
this.tbCSWDmin.Text = Convert.ToString(modelgt.JX_wdMin);
this.tbCSWDmax.Text = Convert.ToString(modelgt.JX_wdMax);
this.tbZZFX.Text = modelgt.JX_zz;
this.tbPTGD.Text = modelgt.JX_pthigh;
this.tbPTWWJ.Text = modelgt.JX_ptwwj;
this.tbLDtype.Text = modelgt.JX_ldgj;
this.tbPTtype.Text = modelgt.JX_ptgj;
this.tbHQPo.Text = Convert.ToString(modelgt.OH_hqBFB);
this.tbHHPo.Text = Convert.ToString(modelgt.OH_hhBFB);
this.tbCSPo.Text = Convert.ToString(modelgt.LD_CSBFB);
this.tbCSmin.Text = Convert.ToString(modelgt.LD_CSPomin);
this.tbCSmax.Text = Convert.ToString(modelgt.LD_CSPomax);
this.rtbCPMC.Text = modelgt.fh产品名称;
this.tbDESCEIP.Text = modelgt.Description;
this.cbWLDM.Text = modelgt.物料代码;
this.cbXHSX.Text = modelgt.型号属性;
this.cbSPEC.Text = modelgt.Specification;
this.cbKHXH.Text = modelgt.客户型号;
this.cbLDCHIPXH.Text = modelgt.LD芯片型号;
this.cbPTCHIPXH.Text = modelgt.PT芯片型号;
this.textBox1.Text = Convert.ToString(modelgt.生产日期);
this.tbQUA_PO.Text = modelgt.Quantity1;
this.tbQUA_SEN.Text = modelgt.Quantity2;
this.tbSL.Text = modelgt.数量;
this.tbFHBHDH.Text = modelgt.备货单号;
this.tbHTH.Text = modelgt.合同编号;
this.tbJHBZ.Text = modelgt.计划编制;
this.tbJSSH.Text = modelgt.技术审核;
this.tbSCSH.Text = modelgt.生产审核;
this.tsslLRTIMEtxt.Text = Convert.ToString(modelgt.录入时间);
this.tsslLRYtxt.Text = modelgt.录入员;
#endregion
//审核人
//修改按钮不可用
}
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnCHANGE_Click(object sender, EventArgs e)
{
DialogResult dr = MessageBox.Show("确定要修改吗？？？", "提示", MessageBoxButtons.YesNo);
if (dr == DialogResult.Yes)
{
if (tbsgdxh1.Text.Trim() != "")
{
Maticsoft.Model.tsuhan_sg_gt mogt = new Maticsoft.Model.tsuhan_sg_gt();
var bhd = this.tbBHDH.Text;
var gt = gtbll.GetModel(bhd);
mogt.id = gt.id;
mogt.合同编号 = this.tbHTBH.Text;
mogt.备货单号 = this.tbBHDH.Text;
if (this.tbBHDSL.Text == "")
{
this.tbBHDSL.Text = "0";
}
mogt.备货单数量 = Convert.ToInt32(this.tbBHDSL.Text);
mogt.表格编号 = this.tbBGBH1.Text + "-" + this.tbBGBH2.Text;
mogt.产品名称 = this.cbCPMC.Text;
mogt.产品类型 = this.txtCPXH.Text;
mogt.成品编码 = this.txtCPBM.Text;
mogt.产品图号 = this.cbCPTH.Text;
mogt.客户代码 = this.tbKHDM.Text;
mogt.规格书编号 = this.cbGGSBH.Text;
mogt.计划编制 = this.tbJHBZ.Text;
mogt.技术审核 = this.tbJSSH.Text;
mogt.生产审核 = this.tbSCSH.Text;
mogt.交货日期 = Convert.ToDateTime(this.dTPjh.Text);
mogt.单日期 = Convert.ToDateTime(this.dTPxd.Text);
mogt.录入时间 = Convert.ToDateTime(this.tsslLRTIMEtxt.Text);
mogt.录入员 = this.tsslLRYtxt.Text;
mogt.BK_A = this.tbAM.Text;
mogt.BK_B = this.tbBM.Text;
#region
if (this.tbCM2.Text == "")
{
this.tbCM2.Text = "0000";
}
mogt.BK_C = this.tbCM1.Text + "-" + this.tbCM2.Text;
if (this.tbSGKSL.Text == "")
{
mogt.随工卡数量 = null;
}
else
{
mogt.随工卡数量 = Convert.ToInt32(this.tbSGKSL.Text);
}
if (this.tbJJ.Text == "")
{
mogt.LD_LDjj = null;
}
else
{
mogt.LD_LDjj = Convert.ToDecimal(this.tbJJ.Text);
}
if (this.tbHQGLmin.Text == "")
{
mogt.GDW_xhcs = null;
}
else
{
mogt.GDW_xhcs = Convert.ToInt32(this.tbXHCS.Text);
}
if (this.tbHQGLmin.Text == "")
{
mogt.OH_hqPomin = null;
}
else
{
mogt.OH_hqPomin = Convert.ToDecimal(this.tbHQGLmin.Text);
}
if (this.tbHQGLmax.Text == "")
{
mogt.OH_hqPomax = null;
}
else
{
mogt.OH_hqPomax = Convert.ToDecimal(this.tbHQGLmax.Text);
}
if (this.tbHHGLmin.Text == "")
{
mogt.OH_hhPomin = null;
}
else
{
mogt.OH_hhPomin = Convert.ToDecimal(this.tbHHGLmin.Text);
}
if (this.tbHHGLmax.Text == "")
{
mogt.OH_hhPomax = null;
}
else
{
mogt.OH_hhPomax = Convert.ToDecimal(this.tbHHGLmax.Text);
}
if (this.tbRXGL.Text == "")
{
mogt.PT_rqgl = null;
}
else
{
mogt.PT_rqgl = Convert.ToInt32(this.tbRXGL.Text);
}
if (this.tbGDLmin.Text == "")
{
mogt.PT_gdlmin = null;
}
else
{
mogt.PT_gdlmin = this.tbGDLmin.Text;
}
if (this.tbGDLmax.Text == "")
{
mogt.PT_gdlmax = null;
}
else
{
mogt.PT_gdlmax = this.tbGDLmax.Text;
}
if (this.tbHQPo.Text == "")
{
mogt.OH_hqBFB = null;
}
else if (Convert.ToInt32(this.tbHQPo.Text.Trim()) > 100)
{
MessageBox.Show("输入的" + lblHQ.Text + "不能大于100", "提示");
return;
}
else if (Convert.ToInt32(this.tbHQPo.Text.Trim()) < 0)
{
MessageBox.Show("输入的" + lblHQ.Text + "不能小于0", "提示");
return;
}
else
{
mogt.OH_hqBFB = Convert.ToInt32(this.tbHQPo.Text);
}
if (this.tbHHPo.Text == "")
{
mogt.OH_hhBFB = null;
}
else if (Convert.ToInt32(this.tbHHPo.Text.Trim()) > 100)
{
MessageBox.Show("输入的" + lblHH.Text + "不能大于100", "提示");
return;
}
else if (Convert.ToInt32(this.tbHHPo.Text.Trim()) < 0)
{
MessageBox.Show("输入的" + lblHH.Text + "不能小于0", "提示");
return;
}
else
{
mogt.OH_hhBFB = Convert.ToInt32(this.tbHHPo.Text);
}
if (this.tbCSPo.Text == "")
{
mogt.LD_CSBFB = null;
}
else if (Convert.ToInt32(this.tbCSPo.Text.Trim()) > 100)
{
MessageBox.Show("输入的" + lblCS.Text + "不能大于100", "提示");
return;
}
else if (Convert.ToInt32(this.tbCSPo.Text.Trim()) < 0)
{
MessageBox.Show("输入的" + lblCS.Text + "不能小于0", "提示");
return;
}
else
{
mogt.LD_CSBFB = Convert.ToInt32(this.tbCSPo.Text);
}
if (this.tbCSWDmin.Text == "")
{
mogt.JX_wdMin = null;
}
else
{
mogt.JX_wdMin = Convert.ToInt32(this.tbCSWDmin.Text);
}
if (this.tbCSWDmax.Text == "")
{
mogt.JX_wdMax = null;
}
else
{
mogt.JX_wdMax = Convert.ToInt32(this.tbCSWDmax.Text);
}
#endregion
mogt.GX_hjfs = this.tbHJFS.Text;
mogt.DM_dmzl = this.tbDMZL.Text;
mogt.JX_ptwwj = this.tbPTWWJ.Text;
mogt.JX_zz = this.tbZZFX.Text;
mogt.JX_pthigh = this.tbPTGD.Text;
mogt.JX_ptgj = this.tbPTtype.Text;
mogt.JX_ldgj = this.tbLDtype.Text;
mogt.BZ_QJbq = this.cbQJBQ.Text;
if (this.tbLDKINK.Text == "")
{
this.tbLDKINK.Text = "0";
}
if (this.tbPTKINK.Text == "")
{
this.tbPTKINK.Text = "0";
}
if (this.tbICCmin.Text == "")
{
this.tbICCmin.Text = "0";
}
if (this.tbICCmax.Text == "")
{
this.tbICCmax.Text = "0";
}
if (this.tbIMOmin.Text == "")
{
this.tbIMOmin.Text = "0";
}
if (this.tbIMOmax.Text == "")
{
this.tbIMOmax.Text = "0";
}
if (this.tbCCGLmin.Text == "")
{
this.tbCCGLmin.Text = "0";
}
if (this.tbCCGLmax.Text == "")
{
this.tbCCGLmax.Text = "0";
}
if (this.tbITHmin.Text == "")
{
this.tbITHmin.Text = "0";
}
if (this.tbITHmax.Text == "")
{
this.tbITHmax.Text = "0";
}
if (this.tbVFmin.Text == "")
{
this.tbVFmin.Text = "0";
}
if (this.tbVFmax.Text == "")
{
this.tbVFmax.Text = "0";
}
if (this.tbVBRmin.Text == "")
{
this.tbVBRmin.Text = "0";
}
if (this.tbVBRmax.Text == "")
{
this.tbVBRmax.Text = "0";
}
if (this.tbCSmin.Text == "")
{
this.tbCSmin.Text = "0";
}
if (this.tbCSmax.Text == "")
{
this.tbCSmax.Text = "0";
}
mogt.LD_CSPomin = Convert.ToDecimal(this.tbCSmin.Text);
mogt.LD_CSPomax = Convert.ToDecimal(this.tbCSmax.Text);
mogt.LD_LDKINK = Convert.ToInt32(this.tbLDKINK.Text);
mogt.LD_PDKINK = Convert.ToInt32(this.tbPTKINK.Text);
mogt.GD_if = this.tbIf.Text;
mogt.PT_ICCmin = Convert.ToInt32(this.tbICCmin.Text);
mogt.PT_ICCmax = Convert.ToInt32(this.tbICCmax.Text);
mogt.GD_imoMin = Convert.ToInt32(this.tbIMOmin.Text);
mogt.GD_imoMax = Convert.ToInt32(this.tbIMOmax.Text);
mogt.GD_ccglMin = Convert.ToDecimal(this.tbCCGLmin.Text);
mogt.GD_ccglMax = Convert.ToDecimal(this.tbCCGLmax.Text);
mogt.GD_ithMin = Convert.ToInt32(this.tbITHmin.Text);
mogt.GD_ithMax = Convert.ToInt32(this.tbITHmax.Text);
mogt.GD_vfMin = Convert.ToDecimal(this.tbVFmin.Text);
mogt.GD_vfMax = Convert.ToDecimal(this.tbVFmax.Text);
mogt.GD_ptsl = this.tbPTSL.Text;
mogt.GD_vbrMin = Convert.ToInt32(this.tbVBRmin.Text);
mogt.GD_vbrMax = Convert.ToInt32(this.tbVBRmax.Text);
mogt.fh产品名称 = this.rtbCPMC.Text;
mogt.Description = this.tbDESCEIP.Text;
mogt.物料代码 = this.cbWLDM.Text;
mogt.型号属性 = this.cbXHSX.Text;
mogt.Specification = this.cbSPEC.Text;
mogt.客户型号 = this.cbKHXH.Text;
mogt.LD芯片型号 = this.cbLDCHIPXH.Text;
mogt.PT芯片型号 = this.cbPTCHIPXH.Text;
mogt.生产日期 = Convert.ToDateTime(this.textBox1.Text);
mogt.Quantity1 = this.tbQUA_PO.Text;
mogt.Quantity2 = this.tbQUA_SEN.Text;
mogt.数量 = this.tbSL.Text;
bool result = false;
try
{
result = gtbll.Update(mogt);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
if (result == true)
{
MessageBox.Show("修改成功", "提示");
}
else
{
MessageBox.Show("修改失败", "提示");
}
}
}
else if (dr == DialogResult.No)
{
return;
}
}
