protected void btnSave_Click(object sender, EventArgs e)
{
string strErr="";
if(!PageValidate.IsNumber(txtaccount_id.Text))
{
strErr+="实际账户编码格式错误！\\n";
}
if(this.txtuser_telphone.Text.Trim().Length==0)
{
strErr+="用户Phone不能为空！\\n";
}
if(!PageValidate.IsDecimal(txtaccount_balance.Text))
{
strErr+="账户余额格式错误！\\n";
}
if(!PageValidate.IsDecimal(txtaccount_change.Text))
{
strErr+="账户变更数量格式错误！\\n";
}
if(this.txtaccount_changetype.Text.Trim().Length==0)
{
strErr+="账户变更类型不能为空！\\n";
}
if(!PageValidate.IsDateTime(txtaccount_change_time.Text))
{
strErr+="账户变更时间格式错误！\\n";
}
if(this.txtaccount_change_comment.Text.Trim().Length==0)
{
strErr+="账户变更备注不能为空！\\n";
}
if(strErr!="")
{
MessageBox.Show(this,strErr);
return;
}
int account_id=int.Parse(this.txtaccount_id.Text);
string user_telphone=this.txtuser_telphone.Text;
decimal account_balance=decimal.Parse(this.txtaccount_balance.Text);
decimal account_change=decimal.Parse(this.txtaccount_change.Text);
string account_changetype=this.txtaccount_changetype.Text;
DateTime account_change_time=DateTime.Parse(this.txtaccount_change_time.Text);
string account_change_comment=this.txtaccount_change_comment.Text;
la.Model.account model=new la.Model.account();
model.account_id=account_id;
model.user_telphone=user_telphone;
model.account_balance=account_balance;
model.account_change=account_change;
model.account_changetype=account_changetype;
model.account_change_time=account_change_time;
model.account_change_comment=account_change_comment;
la.BLL.account bll=new la.BLL.account();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this,"保存成功！","add.aspx");
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public la.Model.account DataRowToModel(DataRow row)
{
la.Model.account model=new la.Model.account();
if (row != null)
{
if(row["account_id"]!=null && row["account_id"].ToString()!="")
{
model.account_id=int.Parse(row["account_id"].ToString());
}
if(row["user_telphone"]!=null)
{
model.user_telphone=row["user_telphone"].ToString();
}
if(row["account_balance"]!=null && row["account_balance"].ToString()!="")
{
model.account_balance=decimal.Parse(row["account_balance"].ToString());
}
if(row["account_change"]!=null && row["account_change"].ToString()!="")
{
model.account_change=decimal.Parse(row["account_change"].ToString());
}
if(row["account_changetype"]!=null)
{
model.account_changetype=row["account_changetype"].ToString();
}
if(row["account_change_time"]!=null && row["account_change_time"].ToString()!="")
{
model.account_change_time=DateTime.Parse(row["account_change_time"].ToString());
}
if(row["account_change_comment"]!=null)
{
model.account_change_comment=row["account_change_comment"].ToString();
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public la.Model.account GetModel(int account_id,string user_telphone)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 account_id,user_telphone,account_balance,account_change,account_changetype,account_change_time,account_change_comment from account ");
strSql.Append(" where account_id=@account_id and user_telphone=@user_telphone ");
SqlParameter[] parameters = {
new SqlParameter("@account_id", SqlDbType.Int,4),
new SqlParameter("@user_telphone", SqlDbType.VarChar,20) };
parameters[0].Value = account_id;
parameters[1].Value = user_telphone;
la.Model.account model=new la.Model.account();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
