/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.Currentaccount model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Currentaccount(");
strSql.Append("type,billnumber,OrderTabday,OrderTabmoney,receipt,money,Beizhu,BY1,BY2,BY3,BY4,BY5,BY6,BY7)");
strSql.Append(" values (");
strSql.Append("@type,@billnumber,@OrderTabday,@OrderTabmoney,@receipt,@money,@Beizhu,@BY1,@BY2,@BY3,@BY4,@BY5,@BY6,@BY7)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@type", SqlDbType.Int, 4),
new SqlParameter("@billnumber", SqlDbType.VarChar, 400),
new SqlParameter("@OrderTabday", SqlDbType.DateTime),
new SqlParameter("@OrderTabmoney", SqlDbType.Decimal, 9),
new SqlParameter("@receipt", SqlDbType.DateTime),
new SqlParameter("@money", SqlDbType.Decimal, 9),
new SqlParameter("@Beizhu", SqlDbType.VarChar, 4000),
new SqlParameter("@BY1", SqlDbType.Decimal, 9),
new SqlParameter("@BY2", SqlDbType.Decimal, 9),
new SqlParameter("@BY3", SqlDbType.Decimal, 9),
new SqlParameter("@BY4", SqlDbType.VarChar, 4000),
new SqlParameter("@BY5", SqlDbType.VarChar, 4000),
new SqlParameter("@BY6", SqlDbType.VarChar, 4000),
new SqlParameter("@BY7", SqlDbType.VarChar, 4000)
};
parameters[0].Value = model.type;
parameters[1].Value = model.billnumber;
parameters[2].Value = model.OrderTabday;
parameters[3].Value = model.OrderTabmoney;
parameters[4].Value = model.receipt;
parameters[5].Value = model.money;
parameters[6].Value = model.Beizhu;
parameters[7].Value = model.BY1;
parameters[8].Value = model.BY2;
parameters[9].Value = model.BY3;
parameters[10].Value = model.BY4;
parameters[11].Value = model.BY5;
parameters[12].Value = model.BY6;
parameters[13].Value = model.BY7;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
private void ShowInfo(int id)
{
Maticsoft.BLL.Currentaccount bll = new Maticsoft.BLL.Currentaccount();
Maticsoft.Model.Currentaccount model = bll.GetModel(id);
this.lblid.Text = model.id.ToString();
this.txttype.Text = model.type.ToString();
this.txtMemberID.Text = model.MemberID.ToString();
this.txtOrderTabday.Text = model.OrderTabday.ToString();
this.txtOrderTabmoney.Text = model.OrderTabmoney.ToString();
this.txtreceipt.Text = model.receipt.ToString();
this.txtmoney.Text = model.money.ToString();
this.txtBeizhu.Text = model.Beizhu;
this.txtBY1.Text = model.BY1.ToString();
this.txtBY2.Text = model.BY2.ToString();
this.txtBY3.Text = model.BY3.ToString();
this.txtBY4.Text = model.BY4;
this.txtBY5.Text = model.BY5;
this.txtBY6.Text = model.BY6;
this.txtBY7.Text = model.BY7;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.Currentaccount GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,type,billnumber,OrderTabday,OrderTabmoney,receipt,money,Beizhu,BY1,BY2,BY3,BY4,BY5,BY6,BY7 from Currentaccount ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Maticsoft.Model.Currentaccount model = new Maticsoft.Model.Currentaccount();
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 (!PageValidate.IsNumber(txttype.Text))
{
strErr += "type格式错误！\\n";
}
if (!PageValidate.IsNumber(txtMemberID.Text))
{
strErr += "MemberID格式错误！\\n";
}
if (!PageValidate.IsDateTime(txtOrderTabday.Text))
{
strErr += "OrderTabday格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtOrderTabmoney.Text))
{
strErr += "OrderTabmoney格式错误！\\n";
}
if (!PageValidate.IsDateTime(txtreceipt.Text))
{
strErr += "receipt格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtmoney.Text))
{
strErr += "money格式错误！\\n";
}
if (this.txtBeizhu.Text.Trim().Length == 0)
{
strErr += "Beizhu不能为空！\\n";
}
if (!PageValidate.IsDecimal(txtBY1.Text))
{
strErr += "BY1格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtBY2.Text))
{
strErr += "BY2格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtBY3.Text))
{
strErr += "BY3格式错误！\\n";
}
if (this.txtBY4.Text.Trim().Length == 0)
{
strErr += "BY4不能为空！\\n";
}
if (this.txtBY5.Text.Trim().Length == 0)
{
strErr += "BY5不能为空！\\n";
}
if (this.txtBY6.Text.Trim().Length == 0)
{
strErr += "BY6不能为空！\\n";
}
if (this.txtBY7.Text.Trim().Length == 0)
{
strErr += "BY7不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
int id = int.Parse(this.lblid.Text);
int type = int.Parse(this.txttype.Text);
int MemberID = int.Parse(this.txtMemberID.Text);
DateTime OrderTabday = DateTime.Parse(this.txtOrderTabday.Text);
decimal OrderTabmoney = decimal.Parse(this.txtOrderTabmoney.Text);
DateTime receipt = DateTime.Parse(this.txtreceipt.Text);
decimal money = decimal.Parse(this.txtmoney.Text);
string Beizhu = this.txtBeizhu.Text;
decimal BY1 = decimal.Parse(this.txtBY1.Text);
decimal BY2 = decimal.Parse(this.txtBY2.Text);
decimal BY3 = decimal.Parse(this.txtBY3.Text);
string BY4 = this.txtBY4.Text;
string BY5 = this.txtBY5.Text;
string BY6 = this.txtBY6.Text;
string BY7 = this.txtBY7.Text;
Maticsoft.Model.Currentaccount model = new Maticsoft.Model.Currentaccount();
model.id = id;
model.type = type;
model.MemberID = MemberID;
model.OrderTabday = OrderTabday;
model.OrderTabmoney = OrderTabmoney;
model.receipt = receipt;
model.money = money;
model.Beizhu = Beizhu;
model.BY1 = BY1;
model.BY2 = BY2;
model.BY3 = BY3;
model.BY4 = BY4;
model.BY5 = BY5;
model.BY6 = BY6;
model.BY7 = BY7;
Maticsoft.BLL.Currentaccount bll = new Maticsoft.BLL.Currentaccount();
bll.Update(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "list.aspx");
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.Currentaccount DataRowToModel(DataRow row)
{
Maticsoft.Model.Currentaccount model = new Maticsoft.Model.Currentaccount();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["type"] != null && row["type"].ToString() != "")
{
model.type = int.Parse(row["type"].ToString());
}
if (row["billnumber"] != null)
{
model.billnumber = row["billnumber"].ToString();
}
if (row["OrderTabday"] != null && row["OrderTabday"].ToString() != "")
{
model.OrderTabday = DateTime.Parse(row["OrderTabday"].ToString());
}
if (row["OrderTabmoney"] != null && row["OrderTabmoney"].ToString() != "")
{
model.OrderTabmoney = decimal.Parse(row["OrderTabmoney"].ToString());
}
if (row["receipt"] != null && row["receipt"].ToString() != "")
{
model.receipt = DateTime.Parse(row["receipt"].ToString());
}
if (row["money"] != null && row["money"].ToString() != "")
{
model.money = decimal.Parse(row["money"].ToString());
}
if (row["Beizhu"] != null)
{
model.Beizhu = row["Beizhu"].ToString();
}
if (row["BY1"] != null && row["BY1"].ToString() != "")
{
model.BY1 = decimal.Parse(row["BY1"].ToString());
}
if (row["BY2"] != null && row["BY2"].ToString() != "")
{
model.BY2 = decimal.Parse(row["BY2"].ToString());
}
if (row["BY3"] != null && row["BY3"].ToString() != "")
{
model.BY3 = decimal.Parse(row["BY3"].ToString());
}
if (row["BY4"] != null)
{
model.BY4 = row["BY4"].ToString();
}
if (row["BY5"] != null)
{
model.BY5 = row["BY5"].ToString();
}
if (row["BY6"] != null)
{
model.BY6 = row["BY6"].ToString();
}
if (row["BY7"] != null)
{
model.BY7 = row["BY7"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.Currentaccount model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Currentaccount set ");
strSql.Append("type=@type,");
strSql.Append("billnumber=@billnumber,");
strSql.Append("OrderTabday=@OrderTabday,");
strSql.Append("OrderTabmoney=@OrderTabmoney,");
strSql.Append("receipt=@receipt,");
strSql.Append("money=@money,");
strSql.Append("Beizhu=@Beizhu,");
strSql.Append("BY1=@BY1,");
strSql.Append("BY2=@BY2,");
strSql.Append("BY3=@BY3,");
strSql.Append("BY4=@BY4,");
strSql.Append("BY5=@BY5,");
strSql.Append("BY6=@BY6,");
strSql.Append("BY7=@BY7");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@type", SqlDbType.Int, 4),
new SqlParameter("@billnumber", SqlDbType.VarChar, 400),
new SqlParameter("@OrderTabday", SqlDbType.DateTime),
new SqlParameter("@OrderTabmoney", SqlDbType.Decimal, 9),
new SqlParameter("@receipt", SqlDbType.DateTime),
new SqlParameter("@money", SqlDbType.Decimal, 9),
new SqlParameter("@Beizhu", SqlDbType.VarChar, 4000),
new SqlParameter("@BY1", SqlDbType.Decimal, 9),
new SqlParameter("@BY2", SqlDbType.Decimal, 9),
new SqlParameter("@BY3", SqlDbType.Decimal, 9),
new SqlParameter("@BY4", SqlDbType.VarChar, 4000),
new SqlParameter("@BY5", SqlDbType.VarChar, 4000),
new SqlParameter("@BY6", SqlDbType.VarChar, 4000),
new SqlParameter("@BY7", SqlDbType.VarChar, 4000),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.type;
parameters[1].Value = model.billnumber;
parameters[2].Value = model.OrderTabday;
parameters[3].Value = model.OrderTabmoney;
parameters[4].Value = model.receipt;
parameters[5].Value = model.money;
parameters[6].Value = model.Beizhu;
parameters[7].Value = model.BY1;
parameters[8].Value = model.BY2;
parameters[9].Value = model.BY3;
parameters[10].Value = model.BY4;
parameters[11].Value = model.BY5;
parameters[12].Value = model.BY6;
parameters[13].Value = model.BY7;
parameters[14].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
