/// <summary> /// 得到一个对象实体 /// </summary> public Demo.SQLServerModelQuery.Model.SysUserModel GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * "); strSql.Append(" from SysUser "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; Demo.SQLServerModelQuery.Model.SysUserModel model = new Demo.SQLServerModelQuery.Model.SysUserModel(); DataSet ds = SQLServerHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataTableToList(ds.Tables[0])[0]); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Demo.SQLServerModelQuery.Model.SysUserModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update SysUser set "); strSql.Append(" [dr] = @dr , "); strSql.Append(" [ts] = @ts , "); strSql.Append(" [UserName] = @UserName , "); strSql.Append(" [Password] = @Password , "); strSql.Append(" [RealName] = @RealName , "); strSql.Append(" [Phone] = @Phone , "); strSql.Append(" [Mobile] = @Mobile , "); strSql.Append(" [Email] = @Email , "); strSql.Append(" [Status] = @Status , "); strSql.Append(" [Description] = @Description "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@dr", SqlDbType.Bit, 1), new SqlParameter("@ts", SqlDbType.DateTime), new SqlParameter("@UserName", SqlDbType.NVarChar, 20), new SqlParameter("@Password", SqlDbType.VarChar, 100), new SqlParameter("@RealName", SqlDbType.NVarChar, 50), new SqlParameter("@Phone", SqlDbType.VarChar, 20), new SqlParameter("@Mobile", SqlDbType.VarChar, 20), new SqlParameter("@Email", SqlDbType.VarChar, 80), new SqlParameter("@Status", SqlDbType.Int, 4), new SqlParameter("@Description", SqlDbType.NVarChar, 200) }; parameters[0].Value = model.ID; parameters[1].Value = model.dr; parameters[2].Value = model.ts; parameters[3].Value = model.UserName; parameters[4].Value = model.Password; parameters[5].Value = model.RealName; parameters[6].Value = model.Phone; parameters[7].Value = model.Mobile; parameters[8].Value = model.Email; parameters[9].Value = model.Status; parameters[10].Value = model.Description; int rows = SQLServerHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 获得数据列表 /// </summary> private List <Demo.SQLServerModelQuery.Model.SysUserModel> DataTableToList(DataTable dt) { List <Demo.SQLServerModelQuery.Model.SysUserModel> modelList = new List <Demo.SQLServerModelQuery.Model.SysUserModel>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Demo.SQLServerModelQuery.Model.SysUserModel model; for (int n = 0; n < rowsCount; n++) { model = new Demo.SQLServerModelQuery.Model.SysUserModel(); if (dt.Rows[n]["ID"].ToString() != "") { model.ID = int.Parse(dt.Rows[n]["ID"].ToString()); } if (dt.Rows[n]["dr"].ToString() != "") { if ((dt.Rows[n]["dr"].ToString() == "1") || (dt.Rows[n]["dr"].ToString().ToLower() == "true")) { model.dr = true; } else { model.dr = false; } } if (dt.Rows[n]["ts"].ToString() != "") { model.ts = DateTime.Parse(dt.Rows[n]["ts"].ToString()); } model.UserName = dt.Rows[n]["UserName"].ToString(); model.Password = dt.Rows[n]["Password"].ToString(); model.RealName = dt.Rows[n]["RealName"].ToString(); model.Phone = dt.Rows[n]["Phone"].ToString(); model.Mobile = dt.Rows[n]["Mobile"].ToString(); model.Email = dt.Rows[n]["Email"].ToString(); if (dt.Rows[n]["Status"].ToString() != "") { model.Status = int.Parse(dt.Rows[n]["Status"].ToString()); } model.Description = dt.Rows[n]["Description"].ToString(); modelList.Add(model); } } return(modelList); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Demo.SQLServerModelQuery.Model.SysUserModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into SysUser("); strSql.Append("[dr],[ts],[UserName],[Password],[RealName],[Phone],[Mobile],[Email],[Status],[Description]"); strSql.Append(") values ("); strSql.Append("@dr,@ts,@UserName,@Password,@RealName,@Phone,@Mobile,@Email,@Status,@Description"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@dr", SqlDbType.Bit, 1), new SqlParameter("@ts", SqlDbType.DateTime), new SqlParameter("@UserName", SqlDbType.NVarChar, 20), new SqlParameter("@Password", SqlDbType.VarChar, 100), new SqlParameter("@RealName", SqlDbType.NVarChar, 50), new SqlParameter("@Phone", SqlDbType.VarChar, 20), new SqlParameter("@Mobile", SqlDbType.VarChar, 20), new SqlParameter("@Email", SqlDbType.VarChar, 80), new SqlParameter("@Status", SqlDbType.Int, 4), new SqlParameter("@Description", SqlDbType.NVarChar, 200) }; parameters[0].Value = model.dr; parameters[1].Value = model.ts; parameters[2].Value = model.UserName; parameters[3].Value = model.Password; parameters[4].Value = model.RealName; parameters[5].Value = model.Phone; parameters[6].Value = model.Mobile; parameters[7].Value = model.Email; parameters[8].Value = model.Status; parameters[9].Value = model.Description; object obj = SQLServerHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }