/// <summary> /// 由一行数据得到一个实体 /// </summary> private Hi.Model.SYS_CompUser GetModel(DataRow r) { Hi.Model.SYS_CompUser model = new Hi.Model.SYS_CompUser(); model.ID = SqlHelper.GetInt(r["ID"]); model.UserID = SqlHelper.GetInt(r["UserID"]); model.CompID = SqlHelper.GetInt(r["CompID"]); model.DisID = SqlHelper.GetInt(r["DisID"]); model.CType = SqlHelper.GetInt(r["CType"]); model.UType = SqlHelper.GetInt(r["UType"]); model.RoleID = SqlHelper.GetInt(r["RoleID"]); model.IsAudit = SqlHelper.GetInt(r["IsAudit"]); model.IsEnabled = SqlHelper.GetInt(r["IsEnabled"]); model.CreateUserID = SqlHelper.GetInt(r["CreateUserID"]); model.CreateDate = SqlHelper.GetDateTime(r["CreateDate"]); model.ts = SqlHelper.GetDateTime(r["ts"]); model.dr = SqlHelper.GetInt(r["dr"]); model.modifyuser = SqlHelper.GetInt(r["modifyuser"]); model.DisSalesManID = SqlHelper.GetInt(r["DisSalesManID"]); model.DisTypeID = SqlHelper.GetInt(r["DisTypeID"]); model.AreaID = SqlHelper.GetInt(r["AreaID"]); model.IsCheck = SqlHelper.GetInt(r["IsCheck"]); model.CreditType = SqlHelper.GetInt(r["CreditType"]); model.CreditAmount = SqlHelper.GetDecimal(r["CreditAmount"]); model.AuditUser = SqlHelper.GetString(r["AuditUser"]); model.AuditDate = SqlHelper.GetDateTime(r["AuditDate"]); return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Hi.Model.SYS_CompUser model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [SYS_CompUser]("); strSql.Append("[UserID],[CompID],[DisID],[CType],[UType],[RoleID],[IsAudit],[IsEnabled],[CreateUserID],[CreateDate],[ts],[modifyuser],[DisSalesManID],[DisTypeID],[AreaID],[IsCheck],[CreditType],[CreditAmount],[AuditUser],[AuditDate])"); strSql.Append(" values ("); strSql.Append("@UserID,@CompID,@DisID,@CType,@UType,@RoleID,@IsAudit,@IsEnabled,@CreateUserID,@CreateDate,@ts,@modifyuser,@DisSalesManID,@DisTypeID,@AreaID,@IsCheck,@CreditType,@CreditAmount,@AuditUser,@AuditDate)"); strSql.Append(";select @@Identity"); SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.Int), new SqlParameter("@CompID", SqlDbType.Int), new SqlParameter("@DisID", SqlDbType.Int), new SqlParameter("@CType", SqlDbType.Int), new SqlParameter("@UType", SqlDbType.Int), new SqlParameter("@RoleID", SqlDbType.Int), new SqlParameter("@IsAudit", SqlDbType.Int), new SqlParameter("@IsEnabled", SqlDbType.Int), new SqlParameter("@CreateUserID", SqlDbType.Int), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@ts", SqlDbType.DateTime), new SqlParameter("@modifyuser", SqlDbType.Int), new SqlParameter("@DisSalesManID", SqlDbType.Int), new SqlParameter("@DisTypeID", SqlDbType.Int), new SqlParameter("@AreaID", SqlDbType.Int), new SqlParameter("@IsCheck", SqlDbType.Int), new SqlParameter("@CreditType", SqlDbType.Int), new SqlParameter("@CreditAmount", SqlDbType.Decimal), new SqlParameter("@AuditUser", SqlDbType.Int), new SqlParameter("@AuditDate", SqlDbType.DateTime) }; parameters[0].Value = model.UserID; parameters[1].Value = model.CompID; parameters[2].Value = model.DisID; parameters[3].Value = model.CType; parameters[4].Value = model.UType; parameters[5].Value = model.RoleID; parameters[6].Value = model.IsAudit; parameters[7].Value = model.IsEnabled; parameters[8].Value = model.CreateUserID; parameters[9].Value = model.CreateDate; parameters[10].Value = model.ts; parameters[11].Value = model.modifyuser; parameters[12].Value = model.DisSalesManID; parameters[13].Value = model.DisTypeID; parameters[14].Value = model.AreaID; parameters[15].Value = model.IsCheck; parameters[16].Value = model.CreditType; parameters[17].Value = model.CreditAmount; if (model.AuditUser != null) { parameters[18].Value = model.AuditUser; } else { parameters[18].Value = DBNull.Value; } if (model.AuditDate != DateTime.MinValue) { parameters[19].Value = model.AuditDate; } else { parameters[19].Value = DBNull.Value; } return(SqlHelper.GetInt(SqlHelper.GetSingle(SqlHelper.LocalSqlServer, strSql.ToString(), parameters))); }
public bool Update(Hi.Model.SYS_CompUser model, SqlTransaction Tran) { return(dal.Update(model, Tran)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Hi.Model.SYS_CompUser model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update [SYS_CompUser] set "); strSql.Append("[UserID]=@UserID,"); strSql.Append("[CompID]=@CompID,"); strSql.Append("[DisID]=@DisID,"); strSql.Append("[CType]=@CType,"); strSql.Append("[UType]=@UType,"); strSql.Append("[RoleID]=@RoleID,"); strSql.Append("[IsAudit]=@IsAudit,"); strSql.Append("[IsEnabled]=@IsEnabled,"); strSql.Append("[CreateUserID]=@CreateUserID,"); strSql.Append("[CreateDate]=@CreateDate,"); strSql.Append("[ts]=@ts,"); strSql.Append("[dr]=@dr,"); strSql.Append("[modifyuser]=@modifyuser,"); strSql.Append("[DisSalesManID]=@DisSalesManID,"); strSql.Append("[DisTypeID]=@DisTypeID,"); strSql.Append("[AreaID]=@AreaID,"); strSql.Append("[IsCheck]=@IsCheck,"); strSql.Append("[CreditType]=@CreditType,"); strSql.Append("[CreditAmount]=@CreditAmount,"); strSql.Append("[AuditUser]=@AuditUser,"); strSql.Append("[AuditDate]=@AuditDate"); strSql.Append(" where [ID]=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int), new SqlParameter("@UserID", SqlDbType.Int), new SqlParameter("@CompID", SqlDbType.Int), new SqlParameter("@DisID", SqlDbType.Int), new SqlParameter("@CType", SqlDbType.Int), new SqlParameter("@UType", SqlDbType.Int), new SqlParameter("@RoleID", SqlDbType.Int), new SqlParameter("@IsAudit", SqlDbType.Int), new SqlParameter("@IsEnabled", SqlDbType.Int), new SqlParameter("@CreateUserID", SqlDbType.Int), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@ts", SqlDbType.DateTime), new SqlParameter("@dr", SqlDbType.SmallInt), new SqlParameter("@modifyuser", SqlDbType.Int), new SqlParameter("@DisSalesManID", SqlDbType.Int), new SqlParameter("@DisTypeID", SqlDbType.Int), new SqlParameter("@AreaID", SqlDbType.Int), new SqlParameter("@IsCheck", SqlDbType.Int), new SqlParameter("@CreditType", SqlDbType.Int), new SqlParameter("@CreditAmount", SqlDbType.Decimal), new SqlParameter("@AuditUser", SqlDbType.Int), new SqlParameter("@AuditDate", SqlDbType.DateTime) }; parameters[0].Value = model.ID; parameters[1].Value = model.UserID; parameters[2].Value = model.CompID; parameters[3].Value = model.DisID; parameters[4].Value = model.CType; parameters[5].Value = model.UType; parameters[6].Value = model.RoleID; parameters[7].Value = model.IsAudit; parameters[8].Value = model.IsEnabled; parameters[9].Value = model.CreateUserID; parameters[10].Value = model.CreateDate; parameters[11].Value = model.ts; parameters[12].Value = model.dr; parameters[13].Value = model.modifyuser; parameters[14].Value = model.DisSalesManID; parameters[15].Value = model.DisTypeID; parameters[16].Value = model.AreaID; parameters[17].Value = model.IsCheck; parameters[18].Value = model.CreditType; parameters[19].Value = model.CreditAmount; if (model.AuditUser != null) { parameters[20].Value = model.AuditUser; } else { parameters[20].Value = DBNull.Value; } if (model.AuditDate != DateTime.MinValue) { parameters[21].Value = model.AuditDate; } else { parameters[21].Value = DBNull.Value; } return(SqlHelper.ExecuteSql(SqlHelper.LocalSqlServer, strSql.ToString(), parameters) > 0); }
public int Add(Hi.Model.SYS_CompUser model, SqlTransaction Tran) { return(dal.Add(model, Tran)); }