/// <summary>
/// 增加一条数据
/// </summary>
public decimal Add(MyERP.Model.VIP_INFO model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into VIP_INFO(");
strSql.Append("COMPANY_CODE,USER_CODE,USER_NAME,VIP_CARD_CODE,PASSWORD,BEGIN_DATE,END_DATE,VIP_TYPE,TOTAL_SALES,salesno,CREATE_NAME,CREATE_DATE,UPDATE_NAME,UPDATE_DATE,REMARK)");
strSql.Append(" values (");
strSql.Append("@COMPANY_CODE,@USER_CODE,@USER_NAME,@VIP_CARD_CODE,@PASSWORD,@BEGIN_DATE,@END_DATE,@VIP_TYPE,@TOTAL_SALES,@salesno,@CREATE_NAME,@CREATE_DATE,@UPDATE_NAME,@UPDATE_DATE,@REMARK)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@COMPANY_CODE", SqlDbType.VarChar, 50),
new SqlParameter("@USER_CODE", SqlDbType.VarChar, 50),
new SqlParameter("@USER_NAME", SqlDbType.VarChar, 50),
new SqlParameter("@VIP_CARD_CODE", SqlDbType.VarChar, 50),
new SqlParameter("@PASSWORD", SqlDbType.VarChar, 10),
new SqlParameter("@BEGIN_DATE", SqlDbType.DateTime),
new SqlParameter("@END_DATE", SqlDbType.DateTime),
new SqlParameter("@VIP_TYPE", SqlDbType.VarChar, 20),
new SqlParameter("@TOTAL_SALES", SqlDbType.Decimal, 17),
new SqlParameter("@salesno", SqlDbType.VarChar, 200),
new SqlParameter("@CREATE_NAME", SqlDbType.VarChar, 20),
new SqlParameter("@CREATE_DATE", SqlDbType.SmallDateTime),
new SqlParameter("@UPDATE_NAME", SqlDbType.VarChar, 20),
new SqlParameter("@UPDATE_DATE", SqlDbType.SmallDateTime),
new SqlParameter("@REMARK", SqlDbType.VarChar, 100)
};
parameters[0].Value = model.COMPANY_CODE;
parameters[1].Value = model.USER_CODE;
parameters[2].Value = model.USER_NAME;
parameters[3].Value = model.VIP_CARD_CODE;
parameters[4].Value = model.PASSWORD;
parameters[5].Value = model.BEGIN_DATE;
parameters[6].Value = model.END_DATE;
parameters[7].Value = model.VIP_TYPE;
parameters[8].Value = model.TOTAL_SALES;
parameters[9].Value = model.salesno;
parameters[10].Value = model.CREATE_NAME;
parameters[11].Value = model.CREATE_DATE;
parameters[12].Value = model.UPDATE_NAME;
parameters[13].Value = model.UPDATE_DATE;
parameters[14].Value = model.REMARK;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToDecimal(obj));
}
}
private void ShowInfo(decimal VIP_TEMP_CARD_CODE)
{
MyERP.BLL.VIP_INFO bll = new MyERP.BLL.VIP_INFO();
MyERP.Model.VIP_INFO model = bll.GetModel(VIP_TEMP_CARD_CODE);
this.txtCOMPANY_CODE.Text = model.COMPANY_CODE;
this.txtUSER_CODE.Text = model.USER_CODE;
this.txtUSER_NAME.Text = model.USER_NAME;
this.lblVIP_CARD_CODE.Text = model.VIP_CARD_CODE;
this.lblVIP_TEMP_CARD_CODE.Text = model.VIP_TEMP_CARD_CODE.ToString();
this.txtPASSWORD.Text = model.PASSWORD;
this.txtBEGIN_DATE.Text = model.BEGIN_DATE.ToString();
this.txtEND_DATE.Text = model.END_DATE.ToString();
this.txtVIP_TYPE.Text = model.VIP_TYPE;
this.txtTOTAL_SALES.Text = model.TOTAL_SALES.ToString();
this.txtsalesno.Text = model.salesno;
this.txtCREATE_NAME.Text = model.CREATE_NAME;
this.txtCREATE_DATE.Text = model.CREATE_DATE.ToString();
this.txtUPDATE_NAME.Text = model.UPDATE_NAME;
this.txtUPDATE_DATE.Text = model.UPDATE_DATE.ToString();
this.txtREMARK.Text = model.REMARK;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MyERP.Model.VIP_INFO GetModel(decimal VIP_TEMP_CARD_CODE)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 COMPANY_CODE,USER_CODE,USER_NAME,VIP_CARD_CODE,VIP_TEMP_CARD_CODE,PASSWORD,BEGIN_DATE,END_DATE,VIP_TYPE,TOTAL_SALES,salesno,CREATE_NAME,CREATE_DATE,UPDATE_NAME,UPDATE_DATE,REMARK from VIP_INFO ");
strSql.Append(" where VIP_TEMP_CARD_CODE=@VIP_TEMP_CARD_CODE");
SqlParameter[] parameters =
{
new SqlParameter("@VIP_TEMP_CARD_CODE", SqlDbType.Decimal)
};
parameters[0].Value = VIP_TEMP_CARD_CODE;
MyERP.Model.VIP_INFO model = new MyERP.Model.VIP_INFO();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtCOMPANY_CODE.Text.Trim().Length == 0)
{
strErr += "COMPANY_CODE不能为空！\\n";
}
if (this.txtUSER_CODE.Text.Trim().Length == 0)
{
strErr += "USER_CODE不能为空！\\n";
}
if (this.txtUSER_NAME.Text.Trim().Length == 0)
{
strErr += "USER_NAME不能为空！\\n";
}
if (this.txtPASSWORD.Text.Trim().Length == 0)
{
strErr += "PASSWORD不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtBEGIN_DATE.Text))
{
strErr += "BEGIN_DATE格式错误！\\n";
}
if (!PageValidate.IsDateTime(txtEND_DATE.Text))
{
strErr += "END_DATE格式错误！\\n";
}
if (this.txtVIP_TYPE.Text.Trim().Length == 0)
{
strErr += "VIP_TYPE不能为空！\\n";
}
if (!PageValidate.IsDecimal(txtTOTAL_SALES.Text))
{
strErr += "TOTAL_SALES格式错误！\\n";
}
if (this.txtsalesno.Text.Trim().Length == 0)
{
strErr += "salesno不能为空！\\n";
}
if (this.txtCREATE_NAME.Text.Trim().Length == 0)
{
strErr += "CREATE_NAME不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtCREATE_DATE.Text))
{
strErr += "CREATE_DATE格式错误！\\n";
}
if (this.txtUPDATE_NAME.Text.Trim().Length == 0)
{
strErr += "UPDATE_NAME不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtUPDATE_DATE.Text))
{
strErr += "UPDATE_DATE格式错误！\\n";
}
if (this.txtREMARK.Text.Trim().Length == 0)
{
strErr += "REMARK不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string COMPANY_CODE = this.txtCOMPANY_CODE.Text;
string USER_CODE = this.txtUSER_CODE.Text;
string USER_NAME = this.txtUSER_NAME.Text;
string VIP_CARD_CODE = this.lblVIP_CARD_CODE.Text;
decimal VIP_TEMP_CARD_CODE = decimal.Parse(this.lblVIP_TEMP_CARD_CODE.Text);
string PASSWORD = this.txtPASSWORD.Text;
DateTime BEGIN_DATE = DateTime.Parse(this.txtBEGIN_DATE.Text);
DateTime END_DATE = DateTime.Parse(this.txtEND_DATE.Text);
string VIP_TYPE = this.txtVIP_TYPE.Text;
decimal TOTAL_SALES = decimal.Parse(this.txtTOTAL_SALES.Text);
string salesno = this.txtsalesno.Text;
string CREATE_NAME = this.txtCREATE_NAME.Text;
DateTime CREATE_DATE = DateTime.Parse(this.txtCREATE_DATE.Text);
string UPDATE_NAME = this.txtUPDATE_NAME.Text;
DateTime UPDATE_DATE = DateTime.Parse(this.txtUPDATE_DATE.Text);
string REMARK = this.txtREMARK.Text;
MyERP.Model.VIP_INFO model = new MyERP.Model.VIP_INFO();
model.COMPANY_CODE = COMPANY_CODE;
model.USER_CODE = USER_CODE;
model.USER_NAME = USER_NAME;
model.VIP_CARD_CODE = VIP_CARD_CODE;
model.VIP_TEMP_CARD_CODE = VIP_TEMP_CARD_CODE;
model.PASSWORD = PASSWORD;
model.BEGIN_DATE = BEGIN_DATE;
model.END_DATE = END_DATE;
model.VIP_TYPE = VIP_TYPE;
model.TOTAL_SALES = TOTAL_SALES;
model.salesno = salesno;
model.CREATE_NAME = CREATE_NAME;
model.CREATE_DATE = CREATE_DATE;
model.UPDATE_NAME = UPDATE_NAME;
model.UPDATE_DATE = UPDATE_DATE;
model.REMARK = REMARK;
MyERP.BLL.VIP_INFO bll = new MyERP.BLL.VIP_INFO();
bll.Update(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "list.aspx");
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MyERP.Model.VIP_INFO model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update VIP_INFO set ");
strSql.Append("COMPANY_CODE=@COMPANY_CODE,");
strSql.Append("USER_CODE=@USER_CODE,");
strSql.Append("USER_NAME=@USER_NAME,");
strSql.Append("PASSWORD=@PASSWORD,");
strSql.Append("BEGIN_DATE=@BEGIN_DATE,");
strSql.Append("END_DATE=@END_DATE,");
strSql.Append("VIP_TYPE=@VIP_TYPE,");
strSql.Append("TOTAL_SALES=@TOTAL_SALES,");
strSql.Append("salesno=@salesno,");
strSql.Append("CREATE_NAME=@CREATE_NAME,");
strSql.Append("CREATE_DATE=@CREATE_DATE,");
strSql.Append("UPDATE_NAME=@UPDATE_NAME,");
strSql.Append("UPDATE_DATE=@UPDATE_DATE,");
strSql.Append("REMARK=@REMARK");
strSql.Append(" where VIP_TEMP_CARD_CODE=@VIP_TEMP_CARD_CODE");
SqlParameter[] parameters =
{
new SqlParameter("@COMPANY_CODE", SqlDbType.VarChar, 50),
new SqlParameter("@USER_CODE", SqlDbType.VarChar, 50),
new SqlParameter("@USER_NAME", SqlDbType.VarChar, 50),
new SqlParameter("@PASSWORD", SqlDbType.VarChar, 10),
new SqlParameter("@BEGIN_DATE", SqlDbType.DateTime),
new SqlParameter("@END_DATE", SqlDbType.DateTime),
new SqlParameter("@VIP_TYPE", SqlDbType.VarChar, 20),
new SqlParameter("@TOTAL_SALES", SqlDbType.Decimal, 17),
new SqlParameter("@salesno", SqlDbType.VarChar, 200),
new SqlParameter("@CREATE_NAME", SqlDbType.VarChar, 20),
new SqlParameter("@CREATE_DATE", SqlDbType.SmallDateTime),
new SqlParameter("@UPDATE_NAME", SqlDbType.VarChar, 20),
new SqlParameter("@UPDATE_DATE", SqlDbType.SmallDateTime),
new SqlParameter("@REMARK", SqlDbType.VarChar, 100),
new SqlParameter("@VIP_CARD_CODE", SqlDbType.VarChar, 50),
new SqlParameter("@VIP_TEMP_CARD_CODE", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.COMPANY_CODE;
parameters[1].Value = model.USER_CODE;
parameters[2].Value = model.USER_NAME;
parameters[3].Value = model.PASSWORD;
parameters[4].Value = model.BEGIN_DATE;
parameters[5].Value = model.END_DATE;
parameters[6].Value = model.VIP_TYPE;
parameters[7].Value = model.TOTAL_SALES;
parameters[8].Value = model.salesno;
parameters[9].Value = model.CREATE_NAME;
parameters[10].Value = model.CREATE_DATE;
parameters[11].Value = model.UPDATE_NAME;
parameters[12].Value = model.UPDATE_DATE;
parameters[13].Value = model.REMARK;
parameters[14].Value = model.VIP_CARD_CODE;
parameters[15].Value = model.VIP_TEMP_CARD_CODE;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MyERP.Model.VIP_INFO DataRowToModel(DataRow row)
{
MyERP.Model.VIP_INFO model = new MyERP.Model.VIP_INFO();
if (row != null)
{
if (row["COMPANY_CODE"] != null)
{
model.COMPANY_CODE = row["COMPANY_CODE"].ToString();
}
if (row["USER_CODE"] != null)
{
model.USER_CODE = row["USER_CODE"].ToString();
}
if (row["USER_NAME"] != null)
{
model.USER_NAME = row["USER_NAME"].ToString();
}
if (row["VIP_CARD_CODE"] != null)
{
model.VIP_CARD_CODE = row["VIP_CARD_CODE"].ToString();
}
if (row["VIP_TEMP_CARD_CODE"] != null && row["VIP_TEMP_CARD_CODE"].ToString() != "")
{
model.VIP_TEMP_CARD_CODE = decimal.Parse(row["VIP_TEMP_CARD_CODE"].ToString());
}
if (row["PASSWORD"] != null)
{
model.PASSWORD = row["PASSWORD"].ToString();
}
if (row["BEGIN_DATE"] != null && row["BEGIN_DATE"].ToString() != "")
{
model.BEGIN_DATE = DateTime.Parse(row["BEGIN_DATE"].ToString());
}
if (row["END_DATE"] != null && row["END_DATE"].ToString() != "")
{
model.END_DATE = DateTime.Parse(row["END_DATE"].ToString());
}
if (row["VIP_TYPE"] != null)
{
model.VIP_TYPE = row["VIP_TYPE"].ToString();
}
if (row["TOTAL_SALES"] != null && row["TOTAL_SALES"].ToString() != "")
{
model.TOTAL_SALES = decimal.Parse(row["TOTAL_SALES"].ToString());
}
if (row["salesno"] != null)
{
model.salesno = row["salesno"].ToString();
}
if (row["CREATE_NAME"] != null)
{
model.CREATE_NAME = row["CREATE_NAME"].ToString();
}
if (row["CREATE_DATE"] != null && row["CREATE_DATE"].ToString() != "")
{
model.CREATE_DATE = DateTime.Parse(row["CREATE_DATE"].ToString());
}
if (row["UPDATE_NAME"] != null)
{
model.UPDATE_NAME = row["UPDATE_NAME"].ToString();
}
if (row["UPDATE_DATE"] != null && row["UPDATE_DATE"].ToString() != "")
{
model.UPDATE_DATE = DateTime.Parse(row["UPDATE_DATE"].ToString());
}
if (row["REMARK"] != null)
{
model.REMARK = row["REMARK"].ToString();
}
}
return(model);
}
