/// <summary> /// 得到一个对象实体 /// </summary> public Sys.Model.Account GetModel(int UserID) { SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.Int, 4) }; parameters[0].Value = UserID; Sys.Model.Account model = new Sys.Model.Account(); DataSet ds = DbHelperSQL.RunProcedure("Account_GetModel", parameters, "ds"); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["UserID"].ToString() != "") { model.UserID = int.Parse(ds.Tables[0].Rows[0]["UserID"].ToString()); } model.Username = ds.Tables[0].Rows[0]["Username"].ToString(); model.Password = ds.Tables[0].Rows[0]["Password"].ToString(); if (ds.Tables[0].Rows[0]["CreateTime"].ToString() != "") { model.CreateTime = DateTime.Parse(ds.Tables[0].Rows[0]["CreateTime"].ToString()); } model.CreateIP = ds.Tables[0].Rows[0]["CreateIP"].ToString(); model.Guid = ds.Tables[0].Rows[0]["Guid"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public int Update(Sys.Model.Account model, string oldPwd) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.Int, 4), new SqlParameter("@Password", SqlDbType.VarChar, 50), new SqlParameter("@OldPassword", SqlDbType.VarChar, 50) }; parameters[0].Value = model.UserID; parameters[1].Value = model.Password; parameters[2].Value = oldPwd; return(DbHelperSQL.RunProcedure("Account_Update", parameters, out rowsAffected)); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Sys.Model.Account model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.Int, 4), new SqlParameter("@Username", SqlDbType.NVarChar, 20), new SqlParameter("@Password", SqlDbType.VarChar, 200), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateIP", SqlDbType.VarChar, 15), new SqlParameter("@Guid", SqlDbType.VarChar, 36) }; parameters[0].Value = model.UserID; parameters[1].Value = model.Username; parameters[2].Value = model.Password; parameters[3].Value = model.CreateTime; parameters[4].Value = model.CreateIP; parameters[5].Value = model.Guid; DbHelperSQL.RunProcedure("Account_Update", parameters, out rowsAffected); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Sys.Model.Account model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.Int, 4), new SqlParameter("@Username", SqlDbType.NVarChar, 20), new SqlParameter("@Password", SqlDbType.VarChar, 200), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateIP", SqlDbType.VarChar, 15), new SqlParameter("@Guid", SqlDbType.VarChar, 36) }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.Username; parameters[2].Value = model.Password; parameters[3].Value = model.CreateTime; parameters[4].Value = model.CreateIP; parameters[5].Value = model.Guid; DbHelperSQL.RunProcedure("Account_ADD", parameters, out rowsAffected); return((int)parameters[0].Value); }