/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MyERP.Model.ORDER_YSJZ model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ORDER_YSJZ set ");
strSql.Append("FDID=@FDID,");
strSql.Append("customcode=@customcode,");
strSql.Append("customname=@customname,");
strSql.Append("SJJZ=@SJJZ,");
strSql.Append("QZZK=@QZZK,");
strSql.Append("QZYS=@QZYS,");
strSql.Append("YSJE=@YSJE,");
strSql.Append("YSWS=@YSWS,");
strSql.Append("begindate=@begindate,");
strSql.Append("enddate=@enddate,");
strSql.Append("createname=@createname,");
strSql.Append("createdate=@createdate,");
strSql.Append("remark=@remark");
strSql.Append(" where ");
SqlParameter[] parameters =
{
new SqlParameter("@FDID", SqlDbType.NVarChar, 10),
new SqlParameter("@customcode", SqlDbType.VarChar, 50),
new SqlParameter("@customname", SqlDbType.VarChar, 50),
new SqlParameter("@SJJZ", SqlDbType.Float, 8),
new SqlParameter("@QZZK", SqlDbType.Float, 8),
new SqlParameter("@QZYS", SqlDbType.Float, 8),
new SqlParameter("@YSJE", SqlDbType.Float, 8),
new SqlParameter("@YSWS", SqlDbType.Float, 8),
new SqlParameter("@begindate", SqlDbType.NVarChar, 10),
new SqlParameter("@enddate", SqlDbType.NVarChar, 10),
new SqlParameter("@createname", SqlDbType.NVarChar, 10),
new SqlParameter("@createdate", SqlDbType.NVarChar, 10),
new SqlParameter("@remark", SqlDbType.NVarChar, 30)
};
parameters[0].Value = model.FDID;
parameters[1].Value = model.customcode;
parameters[2].Value = model.customname;
parameters[3].Value = model.SJJZ;
parameters[4].Value = model.QZZK;
parameters[5].Value = model.QZYS;
parameters[6].Value = model.YSJE;
parameters[7].Value = model.YSWS;
parameters[8].Value = model.begindate;
parameters[9].Value = model.enddate;
parameters[10].Value = model.createname;
parameters[11].Value = model.createdate;
parameters[12].Value = model.remark;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MyERP.Model.ORDER_YSJZ DataRowToModel(DataRow row)
{
MyERP.Model.ORDER_YSJZ model = new MyERP.Model.ORDER_YSJZ();
if (row != null)
{
if (row["FDID"] != null)
{
model.FDID = row["FDID"].ToString();
}
if (row["customcode"] != null)
{
model.customcode = row["customcode"].ToString();
}
if (row["customname"] != null)
{
model.customname = row["customname"].ToString();
}
if (row["SJJZ"] != null && row["SJJZ"].ToString() != "")
{
model.SJJZ = decimal.Parse(row["SJJZ"].ToString());
}
if (row["QZZK"] != null && row["QZZK"].ToString() != "")
{
model.QZZK = decimal.Parse(row["QZZK"].ToString());
}
if (row["QZYS"] != null && row["QZYS"].ToString() != "")
{
model.QZYS = decimal.Parse(row["QZYS"].ToString());
}
if (row["YSJE"] != null && row["YSJE"].ToString() != "")
{
model.YSJE = decimal.Parse(row["YSJE"].ToString());
}
if (row["YSWS"] != null && row["YSWS"].ToString() != "")
{
model.YSWS = decimal.Parse(row["YSWS"].ToString());
}
if (row["begindate"] != null)
{
model.begindate = row["begindate"].ToString();
}
if (row["enddate"] != null)
{
model.enddate = row["enddate"].ToString();
}
if (row["createname"] != null)
{
model.createname = row["createname"].ToString();
}
if (row["createdate"] != null)
{
model.createdate = row["createdate"].ToString();
}
if (row["remark"] != null)
{
model.remark = row["remark"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MyERP.Model.ORDER_YSJZ model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ORDER_YSJZ(");
strSql.Append("FDID,customcode,customname,SJJZ,QZZK,QZYS,YSJE,YSWS,begindate,enddate,createname,createdate,remark)");
strSql.Append(" values (");
strSql.Append("@FDID,@customcode,@customname,@SJJZ,@QZZK,@QZYS,@YSJE,@YSWS,@begindate,@enddate,@createname,@createdate,@remark)");
SqlParameter[] parameters =
{
new SqlParameter("@FDID", SqlDbType.NVarChar, 10),
new SqlParameter("@customcode", SqlDbType.VarChar, 50),
new SqlParameter("@customname", SqlDbType.VarChar, 50),
new SqlParameter("@SJJZ", SqlDbType.Float, 8),
new SqlParameter("@QZZK", SqlDbType.Float, 8),
new SqlParameter("@QZYS", SqlDbType.Float, 8),
new SqlParameter("@YSJE", SqlDbType.Float, 8),
new SqlParameter("@YSWS", SqlDbType.Float, 8),
new SqlParameter("@begindate", SqlDbType.NVarChar, 10),
new SqlParameter("@enddate", SqlDbType.NVarChar, 10),
new SqlParameter("@createname", SqlDbType.NVarChar, 10),
new SqlParameter("@createdate", SqlDbType.NVarChar, 10),
new SqlParameter("@remark", SqlDbType.NVarChar, 30)
};
parameters[0].Value = model.FDID;
parameters[1].Value = model.customcode;
parameters[2].Value = model.customname;
parameters[3].Value = model.SJJZ;
parameters[4].Value = model.QZZK;
parameters[5].Value = model.QZYS;
parameters[6].Value = model.YSJE;
parameters[7].Value = model.YSWS;
parameters[8].Value = model.begindate;
parameters[9].Value = model.enddate;
parameters[10].Value = model.createname;
parameters[11].Value = model.createdate;
parameters[12].Value = model.remark;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
private void ShowInfo()
{
MyERP.BLL.ORDER_YSJZ bll = new MyERP.BLL.ORDER_YSJZ();
MyERP.Model.ORDER_YSJZ model = bll.GetModel();
this.txtFDID.Text = model.FDID;
this.txtcustomcode.Text = model.customcode;
this.txtcustomname.Text = model.customname;
this.txtSJJZ.Text = model.SJJZ.ToString();
this.txtQZZK.Text = model.QZZK.ToString();
this.txtQZYS.Text = model.QZYS.ToString();
this.txtYSJE.Text = model.YSJE.ToString();
this.txtYSWS.Text = model.YSWS.ToString();
this.txtbegindate.Text = model.begindate;
this.txtenddate.Text = model.enddate;
this.txtcreatename.Text = model.createname;
this.txtcreatedate.Text = model.createdate;
this.txtremark.Text = model.remark;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MyERP.Model.ORDER_YSJZ GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 FDID,customcode,customname,SJJZ,QZZK,QZYS,YSJE,YSWS,begindate,enddate,createname,createdate,remark from ORDER_YSJZ ");
strSql.Append(" where ");
SqlParameter[] parameters =
{
};
MyERP.Model.ORDER_YSJZ model = new MyERP.Model.ORDER_YSJZ();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtFDID.Text.Trim().Length == 0)
{
strErr += "FDID不能为空！\\n";
}
if (this.txtcustomcode.Text.Trim().Length == 0)
{
strErr += "customcode不能为空！\\n";
}
if (this.txtcustomname.Text.Trim().Length == 0)
{
strErr += "customname不能为空！\\n";
}
if (!PageValidate.IsDecimal(txtSJJZ.Text))
{
strErr += "SJJZ格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtQZZK.Text))
{
strErr += "QZZK格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtQZYS.Text))
{
strErr += "QZYS格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtYSJE.Text))
{
strErr += "YSJE格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtYSWS.Text))
{
strErr += "YSWS格式错误！\\n";
}
if (this.txtbegindate.Text.Trim().Length == 0)
{
strErr += "begindate不能为空！\\n";
}
if (this.txtenddate.Text.Trim().Length == 0)
{
strErr += "enddate不能为空！\\n";
}
if (this.txtcreatename.Text.Trim().Length == 0)
{
strErr += "createname不能为空！\\n";
}
if (this.txtcreatedate.Text.Trim().Length == 0)
{
strErr += "createdate不能为空！\\n";
}
if (this.txtremark.Text.Trim().Length == 0)
{
strErr += "remark不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string FDID = this.txtFDID.Text;
string customcode = this.txtcustomcode.Text;
string customname = this.txtcustomname.Text;
decimal SJJZ = decimal.Parse(this.txtSJJZ.Text);
decimal QZZK = decimal.Parse(this.txtQZZK.Text);
decimal QZYS = decimal.Parse(this.txtQZYS.Text);
decimal YSJE = decimal.Parse(this.txtYSJE.Text);
decimal YSWS = decimal.Parse(this.txtYSWS.Text);
string begindate = this.txtbegindate.Text;
string enddate = this.txtenddate.Text;
string createname = this.txtcreatename.Text;
string createdate = this.txtcreatedate.Text;
string remark = this.txtremark.Text;
MyERP.Model.ORDER_YSJZ model = new MyERP.Model.ORDER_YSJZ();
model.FDID = FDID;
model.customcode = customcode;
model.customname = customname;
model.SJJZ = SJJZ;
model.QZZK = QZZK;
model.QZYS = QZYS;
model.YSJE = YSJE;
model.YSWS = YSWS;
model.begindate = begindate;
model.enddate = enddate;
model.createname = createname;
model.createdate = createdate;
model.remark = remark;
MyERP.BLL.ORDER_YSJZ bll = new MyERP.BLL.ORDER_YSJZ();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
}
