/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WebDemo.Model.WebDemo.UserRegist model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into UserRegist(");
strSql.Append("RegistPhone,PassWord,IdentityCard,Flag,RegistName,HeadImgPath,UpdateTime,SecurityId,SecurityAnswer,RandomStr,AppType,PayIntegration,TotalMoney)");
strSql.Append(" values (");
strSql.Append("@RegistPhone,@PassWord,@IdentityCard,@Flag,@RegistName,@HeadImgPath,@UpdateTime,@SecurityId,@SecurityAnswer,@RandomStr,@AppType,@PayIntegration,@TotalMoney)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@RegistPhone", SqlDbType.VarChar, 50),
new SqlParameter("@PassWord", SqlDbType.VarChar, 100),
new SqlParameter("@IdentityCard", SqlDbType.VarChar, 50),
new SqlParameter("@Flag", SqlDbType.Int, 4),
new SqlParameter("@RegistName", SqlDbType.VarChar, 50),
new SqlParameter("@HeadImgPath", SqlDbType.VarChar, 500),
new SqlParameter("@UpdateTime", SqlDbType.DateTime),
new SqlParameter("@SecurityId", SqlDbType.Int, 4),
new SqlParameter("@SecurityAnswer", SqlDbType.VarChar, 50),
new SqlParameter("@RandomStr", SqlDbType.VarChar, 6),
new SqlParameter("@AppType", SqlDbType.Int, 4),
new SqlParameter("@PayIntegration", SqlDbType.Int, 4),
new SqlParameter("@TotalMoney", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.RegistPhone;
parameters[1].Value = model.PassWord;
parameters[2].Value = model.IdentityCard;
parameters[3].Value = model.Flag;
parameters[4].Value = model.RegistName;
parameters[5].Value = model.HeadImgPath;
parameters[6].Value = model.UpdateTime;
parameters[7].Value = model.SecurityId;
parameters[8].Value = model.SecurityAnswer;
parameters[9].Value = model.RandomStr;
parameters[10].Value = model.AppType;
parameters[11].Value = model.PayIntegration;
parameters[12].Value = model.TotalMoney;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
private void ShowInfo(int ID)
{
WebDemo.BLL.WebDemo.UserRegist bll = new WebDemo.BLL.WebDemo.UserRegist();
WebDemo.Model.WebDemo.UserRegist model = bll.GetModel(ID);
this.lblID.Text = model.ID.ToString();
this.lblRegistPhone.Text = model.RegistPhone;
this.lblPassWord.Text = model.PassWord;
this.lblIdentityCard.Text = model.IdentityCard;
this.lblFlag.Text = model.Flag.ToString();
this.lblRegistName.Text = model.RegistName;
this.lblHeadImgPath.Text = model.HeadImgPath;
this.lblUpdateTime.Text = model.UpdateTime.ToString();
this.lblSecurityId.Text = model.SecurityId.ToString();
this.lblSecurityAnswer.Text = model.SecurityAnswer;
this.lblRandomStr.Text = model.RandomStr;
this.lblAppType.Text = model.AppType.ToString();
this.lblPayIntegration.Text = model.PayIntegration.ToString();
this.lblTotalMoney.Text = model.TotalMoney.ToString();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.UserRegist GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,RegistPhone,PassWord,IdentityCard,Flag,RegistName,HeadImgPath,UpdateTime,SecurityId,SecurityAnswer,RandomStr,AppType,PayIntegration,TotalMoney from UserRegist ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
WebDemo.Model.WebDemo.UserRegist model = new WebDemo.Model.WebDemo.UserRegist();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.UserRegist DataRowToModel(DataRow row)
{
WebDemo.Model.WebDemo.UserRegist model = new WebDemo.Model.WebDemo.UserRegist();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["RegistPhone"] != null)
{
model.RegistPhone = row["RegistPhone"].ToString();
}
if (row["PassWord"] != null)
{
model.PassWord = row["PassWord"].ToString();
}
if (row["IdentityCard"] != null)
{
model.IdentityCard = row["IdentityCard"].ToString();
}
if (row["Flag"] != null && row["Flag"].ToString() != "")
{
model.Flag = int.Parse(row["Flag"].ToString());
}
if (row["RegistName"] != null)
{
model.RegistName = row["RegistName"].ToString();
}
if (row["HeadImgPath"] != null)
{
model.HeadImgPath = row["HeadImgPath"].ToString();
}
if (row["UpdateTime"] != null && row["UpdateTime"].ToString() != "")
{
model.UpdateTime = DateTime.Parse(row["UpdateTime"].ToString());
}
if (row["SecurityId"] != null && row["SecurityId"].ToString() != "")
{
model.SecurityId = int.Parse(row["SecurityId"].ToString());
}
if (row["SecurityAnswer"] != null)
{
model.SecurityAnswer = row["SecurityAnswer"].ToString();
}
if (row["RandomStr"] != null)
{
model.RandomStr = row["RandomStr"].ToString();
}
if (row["AppType"] != null && row["AppType"].ToString() != "")
{
model.AppType = int.Parse(row["AppType"].ToString());
}
if (row["PayIntegration"] != null && row["PayIntegration"].ToString() != "")
{
model.PayIntegration = int.Parse(row["PayIntegration"].ToString());
}
if (row["TotalMoney"] != null && row["TotalMoney"].ToString() != "")
{
model.TotalMoney = decimal.Parse(row["TotalMoney"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WebDemo.Model.WebDemo.UserRegist model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update UserRegist set ");
strSql.Append("RegistPhone=@RegistPhone,");
strSql.Append("PassWord=@PassWord,");
strSql.Append("IdentityCard=@IdentityCard,");
strSql.Append("Flag=@Flag,");
strSql.Append("RegistName=@RegistName,");
strSql.Append("HeadImgPath=@HeadImgPath,");
strSql.Append("UpdateTime=@UpdateTime,");
strSql.Append("SecurityId=@SecurityId,");
strSql.Append("SecurityAnswer=@SecurityAnswer,");
strSql.Append("RandomStr=@RandomStr,");
strSql.Append("AppType=@AppType,");
strSql.Append("PayIntegration=@PayIntegration,");
strSql.Append("TotalMoney=@TotalMoney");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@RegistPhone", SqlDbType.VarChar, 50),
new SqlParameter("@PassWord", SqlDbType.VarChar, 100),
new SqlParameter("@IdentityCard", SqlDbType.VarChar, 50),
new SqlParameter("@Flag", SqlDbType.Int, 4),
new SqlParameter("@RegistName", SqlDbType.VarChar, 50),
new SqlParameter("@HeadImgPath", SqlDbType.VarChar, 500),
new SqlParameter("@UpdateTime", SqlDbType.DateTime),
new SqlParameter("@SecurityId", SqlDbType.Int, 4),
new SqlParameter("@SecurityAnswer", SqlDbType.VarChar, 50),
new SqlParameter("@RandomStr", SqlDbType.VarChar, 6),
new SqlParameter("@AppType", SqlDbType.Int, 4),
new SqlParameter("@PayIntegration", SqlDbType.Int, 4),
new SqlParameter("@TotalMoney", SqlDbType.Decimal, 9),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.RegistPhone;
parameters[1].Value = model.PassWord;
parameters[2].Value = model.IdentityCard;
parameters[3].Value = model.Flag;
parameters[4].Value = model.RegistName;
parameters[5].Value = model.HeadImgPath;
parameters[6].Value = model.UpdateTime;
parameters[7].Value = model.SecurityId;
parameters[8].Value = model.SecurityAnswer;
parameters[9].Value = model.RandomStr;
parameters[10].Value = model.AppType;
parameters[11].Value = model.PayIntegration;
parameters[12].Value = model.TotalMoney;
parameters[13].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtRegistPhone.Text.Trim().Length == 0)
{
strErr += "RegistPhone不能为空！\\n";
}
if (this.txtPassWord.Text.Trim().Length == 0)
{
strErr += "PassWord不能为空！\\n";
}
if (this.txtIdentityCard.Text.Trim().Length == 0)
{
strErr += "IdentityCard不能为空！\\n";
}
if (!PageValidate.IsNumber(txtFlag.Text))
{
strErr += "Flag格式错误！\\n";
}
if (this.txtRegistName.Text.Trim().Length == 0)
{
strErr += "RegistName不能为空！\\n";
}
if (this.txtHeadImgPath.Text.Trim().Length == 0)
{
strErr += "HeadImgPath不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtUpdateTime.Text))
{
strErr += "UpdateTime格式错误！\\n";
}
if (!PageValidate.IsNumber(txtSecurityId.Text))
{
strErr += "SecurityId格式错误！\\n";
}
if (this.txtSecurityAnswer.Text.Trim().Length == 0)
{
strErr += "SecurityAnswer不能为空！\\n";
}
if (this.txtRandomStr.Text.Trim().Length == 0)
{
strErr += "RandomStr不能为空！\\n";
}
if (!PageValidate.IsNumber(txtAppType.Text))
{
strErr += "AppType格式错误！\\n";
}
if (!PageValidate.IsNumber(txtPayIntegration.Text))
{
strErr += "PayIntegration格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtTotalMoney.Text))
{
strErr += "TotalMoney格式错误！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string RegistPhone = this.txtRegistPhone.Text;
string PassWord = this.txtPassWord.Text;
string IdentityCard = this.txtIdentityCard.Text;
int Flag = int.Parse(this.txtFlag.Text);
string RegistName = this.txtRegistName.Text;
string HeadImgPath = this.txtHeadImgPath.Text;
DateTime UpdateTime = DateTime.Parse(this.txtUpdateTime.Text);
int SecurityId = int.Parse(this.txtSecurityId.Text);
string SecurityAnswer = this.txtSecurityAnswer.Text;
string RandomStr = this.txtRandomStr.Text;
int AppType = int.Parse(this.txtAppType.Text);
int PayIntegration = int.Parse(this.txtPayIntegration.Text);
decimal TotalMoney = decimal.Parse(this.txtTotalMoney.Text);
WebDemo.Model.WebDemo.UserRegist model = new WebDemo.Model.WebDemo.UserRegist();
model.RegistPhone = RegistPhone;
model.PassWord = PassWord;
model.IdentityCard = IdentityCard;
model.Flag = Flag;
model.RegistName = RegistName;
model.HeadImgPath = HeadImgPath;
model.UpdateTime = UpdateTime;
model.SecurityId = SecurityId;
model.SecurityAnswer = SecurityAnswer;
model.RandomStr = RandomStr;
model.AppType = AppType;
model.PayIntegration = PayIntegration;
model.TotalMoney = TotalMoney;
WebDemo.BLL.WebDemo.UserRegist bll = new WebDemo.BLL.WebDemo.UserRegist();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
}
