/// <summary>
/// 得到一个对象实体
/// </summary>
public BBS.Model.BBSUsers DataRowToModel(DataRow row)
{
BBS.Model.BBSUsers model = new BBS.Model.BBSUsers();
if (row != null)
{
if (row["Uid"] != null && row["Uid"].ToString() != "")
{
model.Uid = int.Parse(row["Uid"].ToString());
}
if (row["Uname"] != null)
{
model.Uname = row["Uname"].ToString();
}
if (row["UPassword"] != null)
{
model.UPassword = row["UPassword"].ToString();
}
if (row["UEmail"] != null)
{
model.UEmail = row["UEmail"].ToString();
}
if (row["UBirthday"] != null && row["UBirthday"].ToString() != "")
{
model.UBirthday = DateTime.Parse(row["UBirthday"].ToString());
}
if (row["Usex"] != null && row["Usex"].ToString() != "")
{
if ((row["Usex"].ToString() == "1") || (row["Usex"].ToString().ToLower() == "true"))
{
model.Usex = true;
}
else
{
model.Usex = false;
}
}
if (row["UClass"] != null && row["UClass"].ToString() != "")
{
model.UClass = int.Parse(row["UClass"].ToString());
}
if (row["UStatement"] != null)
{
model.UStatement = row["UStatement"].ToString();
}
if (row["URegDate"] != null && row["URegDate"].ToString() != "")
{
model.URegDate = DateTime.Parse(row["URegDate"].ToString());
}
if (row["UState"] != null && row["UState"].ToString() != "")
{
model.UState = int.Parse(row["UState"].ToString());
}
if (row["UPoint"] != null && row["UPoint"].ToString() != "")
{
model.UPoint = int.Parse(row["UPoint"].ToString());
}
}
return(model);
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string json = "{'info':'增加数据失败'}";
//获取动作的类型
string action = context.Request.Form["Action"];
if (action == "add")
{
//获取GET方法传递参数：Request.QueryString["参数名称"];
//获取POST方法传递参数：Request.Form["参数名称"];
string txtuname = context.Request.Form["uname"]; //保存文本框对象，提高效率
string txtupassword = context.Request.Form["upassword"];
string txtuemail = context.Request.Form["uemail"];
string adminSex = context.Request.Form["usex"];
string txtubirthday = context.Request.Form["ubirthday"];
string txtustatement = context.Request.Form["ustatement"];
BBS.Model.BBSUsers model = new BBS.Model.BBSUsers();
model.Uname = txtuname; //用户姓名
model.UPassword = txtupassword; //用户密码
model.UEmail = txtuemail; //用户邮箱
//用户生日
string y = txtubirthday.Substring(0, 4);
string m = txtubirthday.Substring(4, 2);
string d = txtubirthday.Substring(6, 2);
txtubirthday = y + "-" + m + "-" + d;
model.UBirthday = DateTime.Parse(txtubirthday); //用户生日
model.UStatement = txtustatement; //签名档
model.Usex = false;//用户性别
if (adminSex == "true")
{
model.Usex = true;
}
BBS.BLL.BBSUsers bll = new BBS.BLL.BBSUsers();
int n = bll.Add(model);
//返回单个文字信息
if (n > 0)
{
json = "{'info':'增加数据成功,编号是：" + n + "'}";
}
}
else if (action == "Load")
{
if (context.Session["uid"] == null)
{
json = "{'info':'no'}";
}
}
context.Response.Write(json);
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string json = "{'info':'增加数据失败'}";
//获取GET方法传递参数：Request.QueryString["参数名称"];
//获取POST方法传递参数：Request.Form["参数名称"];
string action = context.Request.Form["Action"];
if (action == "Add")
{
string uname = context.Request.Form["uname"]; //保存文本框对象，提高效率
string upassword = context.Request.Form["upassword"];
string uemail = context.Request.Form["uemail"];
string ubirthday = context.Request.Form["ubirthday"];
string ustatement = context.Request.Form["ustatement"];
string usex = context.Request.Form["usex"];
BBS.Model.BBSUsers model = new BBS.Model.BBSUsers();
model.Uname = uname;
model.UPassword = upassword;
model.UEmail = uemail;
model.UBirthday = DateTime.Parse(ubirthday);
model.UStatement = ustatement;
model.Usex = false;
if (usex == "true")
{
model.Usex = true;
}
BBS.BLL.BBSUsers bll = new BBS.BLL.BBSUsers();
int n = bll.Add(model);
//返回单个文字信息
if (n > 0)
{
json = "{'info':'增加数据成功,编号是：" + n + "'}";
context.Session["ID"] = n;
context.Session["Name"] = uname;
}
}
context.Response.Write(json);
}
private void ShowInfo(int Uid)
{
BBS.BLL.BBSUsers bll = new BBS.BLL.BBSUsers();
BBS.Model.BBSUsers model = bll.GetModel(Uid);
this.lblUid.Text = model.Uid.ToString();
this.lblUname.Text = model.Uname;
this.lblUPassword.Text = model.UPassword;
this.lblUEmail.Text = model.UEmail;
this.lblUBirthday.Text = model.UBirthday.ToString();
this.lblUsex.Text = model.Usex?"是":"否";
this.lblUClass.Text = model.UClass.ToString();
this.lblUStatement.Text = model.UStatement;
this.lblURegDate.Text = model.URegDate.ToString();
this.lblUState.Text = model.UState.ToString();
this.lblUPoint.Text = model.UPoint.ToString();
}
private void ShowInfo(int Uid)
{
BBS.BLL.BBSUsers bll = new BBS.BLL.BBSUsers();
BBS.Model.BBSUsers model = bll.GetModel(Uid);
this.lblUid.Text = model.Uid.ToString();
this.txtUname.Text = model.Uname;
this.txtUPassword.Text = model.UPassword;
this.txtUEmail.Text = model.UEmail;
this.txtUBirthday.Text = model.UBirthday.ToString();
this.chkUsex.Checked = model.Usex;
this.txtUClass.Text = model.UClass.ToString();
this.txtUStatement.Text = model.UStatement;
this.txtURegDate.Text = model.URegDate.ToString();
this.txtUState.Text = model.UState.ToString();
this.txtUPoint.Text = model.UPoint.ToString();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public BBS.Model.BBSUsers GetModel(int Uid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ");
strSql.Append(" Uid,Uname,UPassword,UEmail,UBirthday,Usex,UClass,UStatement,URegDate,UState,UPoint ");
strSql.Append(" from BBSUsers ");
strSql.Append(" where Uid=" + Uid + "");
BBS.Model.BBSUsers model = new BBS.Model.BBSUsers();
DataSet ds = DbHelperSQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BBS.Model.BBSUsers model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.Uname != null)
{
strSql1.Append("Uname,");
strSql2.Append("'" + model.Uname + "',");
}
if (model.UPassword != null)
{
strSql1.Append("UPassword,");
strSql2.Append("'" + model.UPassword + "',");
}
if (model.UEmail != null)
{
strSql1.Append("UEmail,");
strSql2.Append("'" + model.UEmail + "',");
}
if (model.UBirthday != null)
{
strSql1.Append("UBirthday,");
strSql2.Append("'" + model.UBirthday + "',");
}
if (model.Usex != null)
{
strSql1.Append("Usex,");
strSql2.Append("" + (model.Usex? 1 : 0) + ",");
}
if (model.UClass != null)
{
strSql1.Append("UClass,");
strSql2.Append("" + model.UClass + ",");
}
if (model.UStatement != null)
{
strSql1.Append("UStatement,");
strSql2.Append("'" + model.UStatement + "',");
}
if (model.URegDate != null)
{
strSql1.Append("URegDate,");
strSql2.Append("'" + model.URegDate + "',");
}
if (model.UState != null)
{
strSql1.Append("UState,");
strSql2.Append("" + model.UState + ",");
}
if (model.UPoint != null)
{
strSql1.Append("UPoint,");
strSql2.Append("" + model.UPoint + ",");
}
strSql.Append("insert into BBSUsers(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
strSql.Append(";select @@IDENTITY");
object obj = DbHelperSQL.GetSingle(strSql.ToString());
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(BBS.Model.BBSUsers model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update BBSUsers set ");
if (model.Uname != null)
{
strSql.Append("Uname='" + model.Uname + "',");
}
if (model.UPassword != null)
{
strSql.Append("UPassword='******',");
}
else
{
strSql.Append("UPassword= null ,");
}
if (model.UEmail != null)
{
strSql.Append("UEmail='" + model.UEmail + "',");
}
if (model.UBirthday != null)
{
strSql.Append("UBirthday='" + model.UBirthday + "',");
}
if (model.Usex != null)
{
strSql.Append("Usex=" + (model.Usex? 1 : 0) + ",");
}
else
{
strSql.Append("Usex= null ,");
}
if (model.UClass != null)
{
strSql.Append("UClass=" + model.UClass + ",");
}
else
{
strSql.Append("UClass= null ,");
}
if (model.UStatement != null)
{
strSql.Append("UStatement='" + model.UStatement + "',");
}
if (model.URegDate != null)
{
strSql.Append("URegDate='" + model.URegDate + "',");
}
if (model.UState != null)
{
strSql.Append("UState=" + model.UState + ",");
}
else
{
strSql.Append("UState= null ,");
}
if (model.UPoint != null)
{
strSql.Append("UPoint=" + model.UPoint + ",");
}
else
{
strSql.Append("UPoint= null ,");
}
int n = strSql.ToString().LastIndexOf(",");
strSql.Remove(n, 1);
strSql.Append(" where Uid=" + model.Uid + "");
int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString());
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtUname.Text.Trim().Length == 0)
{
strErr += "Uname不能为空！\\n";
}
if (this.txtUPassword.Text.Trim().Length == 0)
{
strErr += "UPassword不能为空！\\n";
}
if (this.txtUEmail.Text.Trim().Length == 0)
{
strErr += "UEmail不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtUBirthday.Text))
{
strErr += "UBirthday格式错误！\\n";
}
if (!PageValidate.IsNumber(txtUClass.Text))
{
strErr += "UClass格式错误！\\n";
}
if (this.txtUStatement.Text.Trim().Length == 0)
{
strErr += "UStatement不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtURegDate.Text))
{
strErr += "URegDate格式错误！\\n";
}
if (!PageValidate.IsNumber(txtUState.Text))
{
strErr += "UState格式错误！\\n";
}
if (!PageValidate.IsNumber(txtUPoint.Text))
{
strErr += "UPoint格式错误！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string Uname = this.txtUname.Text;
string UPassword = this.txtUPassword.Text;
string UEmail = this.txtUEmail.Text;
DateTime UBirthday = DateTime.Parse(this.txtUBirthday.Text);
bool Usex = this.chkUsex.Checked;
int UClass = int.Parse(this.txtUClass.Text);
string UStatement = this.txtUStatement.Text;
DateTime URegDate = DateTime.Parse(this.txtURegDate.Text);
int UState = int.Parse(this.txtUState.Text);
int UPoint = int.Parse(this.txtUPoint.Text);
BBS.Model.BBSUsers model = new BBS.Model.BBSUsers();
model.Uname = Uname;
model.UPassword = UPassword;
model.UEmail = UEmail;
model.UBirthday = UBirthday;
model.Usex = Usex;
model.UClass = UClass;
model.UStatement = UStatement;
model.URegDate = URegDate;
model.UState = UState;
model.UPoint = UPoint;
BBS.BLL.BBSUsers bll = new BBS.BLL.BBSUsers();
bll.Add(model);
Common.MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
}
