//保存按钮
private void btnSave_Click(object sender, EventArgs e)
{
if (txtGYSMC.Text.strReplace().IsNullOrEmpty())
{
ComForm.DspMsg("W002", "供应商名称");
txtGYSMC.Focus();
return;
}
if (DBHelper.Exists(TableName, "and GYSMC='" + txtGYSMC.Text.strReplace() + "'"))
{
ComForm.DspMsg("W068", "供应商名称");
txtGYSMC.Focus();
return;
}
if (ComConst.LING == ComForm.DspMsg("Q004", ""))
{
try
{
Model.fmd030 _modelFMD030 = new Model.fmd030();
_modelFMD030.ID = iID;
_modelFMD030.GYSMC = txtGYSMC.Text.strReplace();
_modelFMD030.GYSSLMC = txtGYSSLMC.Text.strReplace();
_modelFMD030.DZ = txtDZ.Text.strReplace();
_modelFMD030.DH = txtDH.Text.strReplace();
_modelFMD030.LXR = txtLXR.Text.strReplace();
if (_modelFMD030.ID != -1)
{
//更新数据
_modelFMD030.GXZBH = ComForm.strUserName;
_modelFMD030.GXR = PublicFun.GetSystemDateTime(Const.Date, Const.dateStyle_YMD);
_modelFMD030.GXSJ = PublicFun.GetSystemDateTime(Const.Time, string.Empty);
_modelFMD030.GXDMM = systemdate.Get_SysDNBH();
DbHelperMySql.ExecuteSql(DBHelper.Update(TableName, _modelFMD030, " and ID=" + _modelFMD030.ID + ""));
//_bllFMD030.Update(_modelFMD030);
ComForm.DspMsg("M002", "");
txtGYSMC.Focus();
}
else
{
//插入数据
_modelFMD030.ID = null;
_modelFMD030.RLZBH = ComForm.strUserName;
_modelFMD030.RLR = PublicFun.GetSystemDateTime(Const.Date, Const.dateStyle_YMD);
_modelFMD030.RLSJ = PublicFun.GetSystemDateTime(Const.Time, string.Empty);
_modelFMD030.RLDMM = systemdate.Get_SysDNBH();
DbHelperMySql.ExecuteSql(DBHelper.Add(TableName, _modelFMD030));
ComForm.DspMsg("M002", "");
txtGYSMC.Focus();
}
}
catch (Exception ew)
{
ComForm.DspMsg("E001", "");
ComForm.InsertErrLog(ew.ToString(), this.Name);
return;
}
Init();
}
}
//保存按钮
private void btnSave_Click(object sender, EventArgs e)
{
if (txtGYSMC.Text.strReplace().IsNullOrEmpty())
{
ComForm.DspMsg("W002", "供应商名称");
txtGYSMC.Focus();
return;
}
if (DBHelper.Exists(TableName, "and GYSMC='"+txtGYSMC.Text.strReplace()+"'"))
{
ComForm.DspMsg("W068", "供应商名称");
txtGYSMC.Focus();
return;
}
if (ComConst.LING == ComForm.DspMsg("Q004", ""))
{
try
{
Model.fmd030 _modelFMD030 = new Model.fmd030();
_modelFMD030.ID = iID;
_modelFMD030.GYSMC = txtGYSMC.Text.strReplace();
_modelFMD030.GYSSLMC = txtGYSSLMC.Text.strReplace();
_modelFMD030.DZ = txtDZ.Text.strReplace();
_modelFMD030.DH = txtDH.Text.strReplace();
_modelFMD030.LXR = txtLXR.Text.strReplace();
if (_modelFMD030.ID!=-1)
{
//更新数据
_modelFMD030.GXZBH = ComForm.strUserName;
_modelFMD030.GXR = PublicFun.GetSystemDateTime(Const.Date, Const.dateStyle_YMD);
_modelFMD030.GXSJ = PublicFun.GetSystemDateTime(Const.Time, string.Empty);
_modelFMD030.GXDMM = systemdate.Get_SysDNBH();
DbHelperMySql.ExecuteSql(DBHelper.Update(TableName,_modelFMD030," and ID="+_modelFMD030.ID+""));
//_bllFMD030.Update(_modelFMD030);
ComForm.DspMsg("M002", "");
txtGYSMC.Focus();
}
else
{
//插入数据
_modelFMD030.ID = null;
_modelFMD030.RLZBH = ComForm.strUserName;
_modelFMD030.RLR = PublicFun.GetSystemDateTime(Const.Date, Const.dateStyle_YMD);
_modelFMD030.RLSJ = PublicFun.GetSystemDateTime(Const.Time, string.Empty);
_modelFMD030.RLDMM = systemdate.Get_SysDNBH();
DbHelperMySql.ExecuteSql(DBHelper.Add(TableName,_modelFMD030));
ComForm.DspMsg("M002", "");
txtGYSMC.Focus();
}
}
catch (Exception ew)
{
ComForm.DspMsg("E001", "");
ComForm.InsertErrLog(ew.ToString(), this.Name);
return;
}
Init();
}
}
