/// <summary> /// 更新一条数据 /// </summary> public void Update(TFXK.Model.Customers model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_customers set "); strSql.Append("loginName=@loginName,"); strSql.Append("loginPass=@loginPass,"); strSql.Append("email=@email,"); strSql.Append("phone=@phone,"); strSql.Append("regDate=@regDate,"); strSql.Append("trueName=@trueName,"); strSql.Append("userSex=@userSex,"); strSql.Append("tel=@tel,"); strSql.Append("address=@address,"); strSql.Append("cardID=@cardID,"); strSql.Append("birsday=@birsday,"); strSql.Append("stateID=@stateID,"); strSql.Append("orderEmail=@orderEmail,"); strSql.Append("validateEmail=@validateEmail"); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@loginName", SqlDbType.VarChar, 50), new SqlParameter("@loginPass", SqlDbType.VarChar, 50), new SqlParameter("@email", SqlDbType.VarChar, 100), new SqlParameter("@phone", SqlDbType.VarChar, 100), new SqlParameter("@regDate", SqlDbType.DateTime), new SqlParameter("@trueName", SqlDbType.VarChar, 100), new SqlParameter("@userSex", SqlDbType.Int, 4), new SqlParameter("@tel", SqlDbType.VarChar, 100), new SqlParameter("@address", SqlDbType.VarChar, 500), new SqlParameter("@cardID", SqlDbType.VarChar, 50), new SqlParameter("@birsday", SqlDbType.VarChar, 50), new SqlParameter("@stateID", SqlDbType.Int, 4), new SqlParameter("@orderEmail", SqlDbType.Int, 4), new SqlParameter("@validateEmail", SqlDbType.VarChar, 50) }; parameters[0].Value = model.id; parameters[1].Value = model.loginName; parameters[2].Value = model.loginPass; parameters[3].Value = model.email; parameters[4].Value = model.phone; parameters[5].Value = model.regDate; parameters[6].Value = model.trueName; parameters[7].Value = model.userSex; parameters[8].Value = model.tel; parameters[9].Value = model.address; parameters[10].Value = model.cardID; parameters[11].Value = model.birsday; parameters[12].Value = model.stateID; parameters[13].Value = model.orderEmail; parameters[14].Value = model.validateEmail; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/* * /// <summary> * /// 分页获取数据列表 * /// </summary> * public DataSet GetList(int PageSize,int PageIndex,string strWhere) * { * SqlParameter[] parameters = { * new SqlParameter("@tblName", SqlDbType.VarChar, 255), * new SqlParameter("@fldName", SqlDbType.VarChar, 255), * new SqlParameter("@PageSize", SqlDbType.Int), * new SqlParameter("@PageIndex", SqlDbType.Int), * new SqlParameter("@IsReCount", SqlDbType.Bit), * new SqlParameter("@OrderType", SqlDbType.Bit), * new SqlParameter("@strWhere", SqlDbType.VarChar,1000), * }; * parameters[0].Value = "tb_customers"; * parameters[1].Value = "ID"; * parameters[2].Value = PageSize; * parameters[3].Value = PageIndex; * parameters[4].Value = 0; * parameters[5].Value = 0; * parameters[6].Value = strWhere; * return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds"); * }*/ #endregion 成员方法 /// <summary> /// 得到一个对象实体 /// </summary> public TFXK.Model.Customers GetModelByPhone(string phone) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,loginName,loginPass,email,phone,regDate,trueName,userSex,tel,address,cardID,birsday,stateID,orderEmail,validateEmail from tb_customers "); strSql.Append(" where phone=@phone "); SqlParameter[] parameters = { new SqlParameter("@phone", SqlDbType.VarChar, 50) }; parameters[0].Value = phone; TFXK.Model.Customers model = new TFXK.Model.Customers(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } model.loginName = ds.Tables[0].Rows[0]["loginName"].ToString(); model.loginPass = ds.Tables[0].Rows[0]["loginPass"].ToString(); model.email = ds.Tables[0].Rows[0]["email"].ToString(); model.phone = ds.Tables[0].Rows[0]["phone"].ToString(); if (ds.Tables[0].Rows[0]["regDate"].ToString() != "") { model.regDate = DateTime.Parse(ds.Tables[0].Rows[0]["regDate"].ToString()); } model.trueName = ds.Tables[0].Rows[0]["trueName"].ToString(); if (ds.Tables[0].Rows[0]["userSex"].ToString() != "") { model.userSex = int.Parse(ds.Tables[0].Rows[0]["userSex"].ToString()); } model.tel = ds.Tables[0].Rows[0]["tel"].ToString(); model.address = ds.Tables[0].Rows[0]["address"].ToString(); model.cardID = ds.Tables[0].Rows[0]["cardID"].ToString(); model.birsday = ds.Tables[0].Rows[0]["birsday"].ToString(); if (ds.Tables[0].Rows[0]["stateID"].ToString() != "") { model.stateID = int.Parse(ds.Tables[0].Rows[0]["stateID"].ToString()); } if (ds.Tables[0].Rows[0]["orderEmail"].ToString() != "") { model.orderEmail = int.Parse(ds.Tables[0].Rows[0]["orderEmail"].ToString()); } model.validateEmail = ds.Tables[0].Rows[0]["validateEmail"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TFXK.Model.Customers model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_customers("); strSql.Append("loginName,loginPass,email,phone,regDate,trueName,userSex,tel,address,cardID,birsday,stateID,orderEmail,validateEmail)"); strSql.Append(" values ("); strSql.Append("@loginName,@loginPass,@email,@phone,@regDate,@trueName,@userSex,@tel,@address,@cardID,@birsday,@stateID,@orderEmail,@validateEmail)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@loginName", SqlDbType.VarChar, 50), new SqlParameter("@loginPass", SqlDbType.VarChar, 50), new SqlParameter("@email", SqlDbType.VarChar, 100), new SqlParameter("@phone", SqlDbType.VarChar, 100), new SqlParameter("@regDate", SqlDbType.DateTime), new SqlParameter("@trueName", SqlDbType.VarChar, 100), new SqlParameter("@userSex", SqlDbType.Int, 4), new SqlParameter("@tel", SqlDbType.VarChar, 100), new SqlParameter("@address", SqlDbType.VarChar, 500), new SqlParameter("@cardID", SqlDbType.VarChar, 50), new SqlParameter("@birsday", SqlDbType.VarChar, 50), new SqlParameter("@stateID", SqlDbType.Int, 4), new SqlParameter("@orderEmail", SqlDbType.Int, 4), new SqlParameter("@validateEmail", SqlDbType.VarChar, 50) }; parameters[0].Value = model.loginName; parameters[1].Value = model.loginPass; parameters[2].Value = model.email; parameters[3].Value = model.phone; parameters[4].Value = model.regDate; parameters[5].Value = model.trueName; parameters[6].Value = model.userSex; parameters[7].Value = model.tel; parameters[8].Value = model.address; parameters[9].Value = model.cardID; parameters[10].Value = model.birsday; parameters[11].Value = model.stateID; parameters[12].Value = model.orderEmail; parameters[13].Value = model.validateEmail; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }