/// <summary> /// 增加一条数据 /// </summary> public int Add(Shop.Model.User model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into t_user("); strSql.Append("uname,upwd,unickname,usex,headphoto,urealname,udentity,uquestion1,uanswer1,uquestion2,uanswer2,uphone,uaddress,uemail,uregistertime)"); strSql.Append(" values ("); strSql.Append("@uname,@upwd,@unickname,@usex,@headphoto,@urealname,@udentity,@uquestion1,@uanswer1,@uquestion2,@uanswer2,@uphone,@uaddress,@uemail,@uregistertime)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@uname", SqlDbType.VarChar, 30), new SqlParameter("@upwd", SqlDbType.VarChar, 20), new SqlParameter("@unickname", SqlDbType.VarChar, 20), new SqlParameter("@usex", SqlDbType.VarChar, 2), new SqlParameter("@headphoto", SqlDbType.VarChar, 50), new SqlParameter("@urealname", SqlDbType.VarChar, 30), new SqlParameter("@udentity", SqlDbType.VarChar, 18), new SqlParameter("@uquestion1", SqlDbType.VarChar, 50), new SqlParameter("@uanswer1", SqlDbType.VarChar, 30), new SqlParameter("@uquestion2", SqlDbType.VarChar, 50), new SqlParameter("@uanswer2", SqlDbType.VarChar, 30), new SqlParameter("@uphone", SqlDbType.VarChar, 11), new SqlParameter("@uaddress", SqlDbType.VarChar, 200), new SqlParameter("@uemail", SqlDbType.VarChar, 50), new SqlParameter("@uregistertime", SqlDbType.DateTime) }; parameters[0].Value = model.uname; parameters[1].Value = model.upwd; parameters[2].Value = model.unickname; parameters[3].Value = model.usex; parameters[4].Value = model.headphoto; parameters[5].Value = model.urealname; parameters[6].Value = model.udentity; parameters[7].Value = model.uquestion1; parameters[8].Value = model.uanswer1; parameters[9].Value = model.uquestion2; parameters[10].Value = model.uanswer2; parameters[11].Value = model.uphone; parameters[12].Value = model.uaddress; parameters[13].Value = model.uemail; parameters[14].Value = model.uregistertime; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Shop.Model.User GetModel(int uid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 uid,uname,upwd,unickname,usex,headphoto,urealname,udentity,uquestion1,uanswer1,uquestion2,uanswer2,uphone,uaddress,uemail,uregistertime from t_user "); strSql.Append(" where uid=@uid"); SqlParameter[] parameters = { new SqlParameter("@uid", SqlDbType.Int, 4) }; parameters[0].Value = uid; Shop.Model.User model = new Shop.Model.User(); 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 Shop.Model.User DataRowToModel(DataRow row) { Shop.Model.User model = new Shop.Model.User(); 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["upwd"] != null) { model.upwd = row["upwd"].ToString(); } if (row["unickname"] != null) { model.unickname = row["unickname"].ToString(); } if (row["usex"] != null) { model.usex = row["usex"].ToString(); } if (row["headphoto"] != null) { model.headphoto = row["headphoto"].ToString(); } if (row["urealname"] != null) { model.urealname = row["urealname"].ToString(); } if (row["udentity"] != null) { model.udentity = row["udentity"].ToString(); } if (row["uquestion1"] != null) { model.uquestion1 = row["uquestion1"].ToString(); } if (row["uanswer1"] != null) { model.uanswer1 = row["uanswer1"].ToString(); } if (row["uquestion2"] != null) { model.uquestion2 = row["uquestion2"].ToString(); } if (row["uanswer2"] != null) { model.uanswer2 = row["uanswer2"].ToString(); } if (row["uphone"] != null) { model.uphone = row["uphone"].ToString(); } if (row["uaddress"] != null) { model.uaddress = row["uaddress"].ToString(); } if (row["uemail"] != null) { model.uemail = row["uemail"].ToString(); } if (row["uregistertime"] != null && row["uregistertime"].ToString() != "") { model.uregistertime = DateTime.Parse(row["uregistertime"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Shop.Model.User model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update t_user set "); strSql.Append("uname=@uname,"); strSql.Append("upwd=@upwd,"); strSql.Append("unickname=@unickname,"); strSql.Append("usex=@usex,"); strSql.Append("headphoto=@headphoto,"); strSql.Append("urealname=@urealname,"); strSql.Append("udentity=@udentity,"); strSql.Append("uquestion1=@uquestion1,"); strSql.Append("uanswer1=@uanswer1,"); strSql.Append("uquestion2=@uquestion2,"); strSql.Append("uanswer2=@uanswer2,"); strSql.Append("uphone=@uphone,"); strSql.Append("uaddress=@uaddress,"); strSql.Append("uemail=@uemail,"); strSql.Append("uregistertime=@uregistertime"); strSql.Append(" where uid=@uid"); SqlParameter[] parameters = { new SqlParameter("@uname", SqlDbType.VarChar, 30), new SqlParameter("@upwd", SqlDbType.VarChar, 20), new SqlParameter("@unickname", SqlDbType.VarChar, 20), new SqlParameter("@usex", SqlDbType.VarChar, 2), new SqlParameter("@headphoto", SqlDbType.VarChar, 50), new SqlParameter("@urealname", SqlDbType.VarChar, 30), new SqlParameter("@udentity", SqlDbType.VarChar, 18), new SqlParameter("@uquestion1", SqlDbType.VarChar, 50), new SqlParameter("@uanswer1", SqlDbType.VarChar, 30), new SqlParameter("@uquestion2", SqlDbType.VarChar, 50), new SqlParameter("@uanswer2", SqlDbType.VarChar, 30), new SqlParameter("@uphone", SqlDbType.VarChar, 11), new SqlParameter("@uaddress", SqlDbType.VarChar, 200), new SqlParameter("@uemail", SqlDbType.VarChar, 50), new SqlParameter("@uregistertime", SqlDbType.DateTime), new SqlParameter("@uid", SqlDbType.Int, 4) }; parameters[0].Value = model.uname; parameters[1].Value = model.upwd; parameters[2].Value = model.unickname; parameters[3].Value = model.usex; parameters[4].Value = model.headphoto; parameters[5].Value = model.urealname; parameters[6].Value = model.udentity; parameters[7].Value = model.uquestion1; parameters[8].Value = model.uanswer1; parameters[9].Value = model.uquestion2; parameters[10].Value = model.uanswer2; parameters[11].Value = model.uphone; parameters[12].Value = model.uaddress; parameters[13].Value = model.uemail; parameters[14].Value = model.uregistertime; parameters[15].Value = model.uid; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }