/// <summary>计算记录数 /// /// </summary> /// <param name="p"></param> /// <returns></returns> public int CalcCount(string cond) { IMsSqlDataAccessService h = ServiceHelper.GetMsSqlDataAccessService(); string sql = "select count(1) from Bse_Role_Menu"; if (!string.IsNullOrEmpty(cond)) { sql += " where " + cond; } h.CreateCommand(sql); return(int.Parse(h.ExecuteScalar())); }
/// <summary>增加一条数据 /// /// </summary> public int Add(Nikita.Permission.Model.Bse_Role_Menu model) { IMsSqlDataAccessService h = ServiceHelper.GetMsSqlDataAccessService(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Bse_Role_Menu("); strSql.Append("Module_Id, Role_Id, Allowed_Operator, Dept_Id, DeptName, Company_Id, CompanyName, Bloc_Id, BlocName, CreateUserId, CreateName, CreateDate, EditUserId, EditUserName, EditDate, State, SystemId )"); strSql.Append(" values ("); strSql.Append("@Module_Id, @Role_Id, @Allowed_Operator, @Dept_Id, @DeptName, @Company_Id, @CompanyName, @Bloc_Id, @BlocName, @CreateUserId, @CreateName, @CreateDate, @EditUserId, @EditUserName, @EditDate, @State, @SystemId )"); strSql.Append(";select @@IDENTITY"); h.CreateCommand(strSql.ToString()); if (model.Module_Id == null) { h.AddParameter("@Module_Id", DBNull.Value); } else { h.AddParameter("@Module_Id", model.Module_Id); } if (model.Role_Id == null) { h.AddParameter("@Role_Id", DBNull.Value); } else { h.AddParameter("@Role_Id", model.Role_Id); } if (model.Allowed_Operator == null) { h.AddParameter("@Allowed_Operator", DBNull.Value); } else { h.AddParameter("@Allowed_Operator", model.Allowed_Operator); } if (model.Dept_Id == null) { h.AddParameter("@Dept_Id", DBNull.Value); } else { h.AddParameter("@Dept_Id", model.Dept_Id); } if (model.DeptName == null) { h.AddParameter("@DeptName", DBNull.Value); } else { h.AddParameter("@DeptName", model.DeptName); } if (model.Company_Id == null) { h.AddParameter("@Company_Id", DBNull.Value); } else { h.AddParameter("@Company_Id", model.Company_Id); } if (model.CompanyName == null) { h.AddParameter("@CompanyName", DBNull.Value); } else { h.AddParameter("@CompanyName", model.CompanyName); } if (model.Bloc_Id == null) { h.AddParameter("@Bloc_Id", DBNull.Value); } else { h.AddParameter("@Bloc_Id", model.Bloc_Id); } if (model.BlocName == null) { h.AddParameter("@BlocName", DBNull.Value); } else { h.AddParameter("@BlocName", model.BlocName); } if (model.CreateUserId == null) { h.AddParameter("@CreateUserId", DBNull.Value); } else { h.AddParameter("@CreateUserId", model.CreateUserId); } if (model.CreateName == null) { h.AddParameter("@CreateName", DBNull.Value); } else { h.AddParameter("@CreateName", model.CreateName); } if (model.CreateDate == null) { h.AddParameter("@CreateDate", DBNull.Value); } else { h.AddParameter("@CreateDate", model.CreateDate); } if (model.EditUserId == null) { h.AddParameter("@EditUserId", DBNull.Value); } else { h.AddParameter("@EditUserId", model.EditUserId); } if (model.EditUserName == null) { h.AddParameter("@EditUserName", DBNull.Value); } else { h.AddParameter("@EditUserName", model.EditUserName); } if (model.EditDate == null) { h.AddParameter("@EditDate", DBNull.Value); } else { h.AddParameter("@EditDate", model.EditDate); } if (model.State == null) { h.AddParameter("@State", DBNull.Value); } else { h.AddParameter("@State", model.State); } if (model.SystemId == null) { h.AddParameter("@SystemId", DBNull.Value); } else { h.AddParameter("@SystemId", model.SystemId); } int result; string obj = h.ExecuteScalar(); if (!int.TryParse(obj, out result)) { return(0); } return(result); }
/// <summary>增加一条数据 /// /// </summary> public int Add(Nikita.Permission.Model.Bse_User model) { IMsSqlDataAccessService h = ServiceHelper.GetMsSqlDataAccessService(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Bse_User("); strSql.Append("Number, UserName, Realname, NiName, UserFrom, Password, ChangePasswordDate, Duty, Title, Email, Lang, Sex, Birthday, Mobile, Telephone, QQ, SFZNumber, HomeAddress, HomeTel, WorkAddress, WorkTel, Theme, AllowStartTime, AllowEndTime, LockStartDate, LockEndDate, FirstVisit, PreviousVisit, LastVisit, LogOnCount, IsStaff, IsVisible, IPAddress, MACAddress, Question, AnswerQuestion, UserAddressId, AuditStatus, PY, Sort, Dept_Id, DeptName, Company_Id, CompanyName, Bloc_Id, BlocName, CreateUserId, CreateName, CreateDate, EditUserId, EditUserName, EditDate, Remark, State, SystemId )"); strSql.Append(" values ("); strSql.Append("@Number, @UserName, @Realname, @NiName, @UserFrom, @Password, @ChangePasswordDate, @Duty, @Title, @Email, @Lang, @Sex, @Birthday, @Mobile, @Telephone, @QQ, @SFZNumber, @HomeAddress, @HomeTel, @WorkAddress, @WorkTel, @Theme, @AllowStartTime, @AllowEndTime, @LockStartDate, @LockEndDate, @FirstVisit, @PreviousVisit, @LastVisit, @LogOnCount, @IsStaff, @IsVisible, @IPAddress, @MACAddress, @Question, @AnswerQuestion, @UserAddressId, @AuditStatus, @PY, @Sort, @Dept_Id, @DeptName, @Company_Id, @CompanyName, @Bloc_Id, @BlocName, @CreateUserId, @CreateName, @CreateDate, @EditUserId, @EditUserName, @EditDate, @Remark, @State, @SystemId )"); strSql.Append(";select @@IDENTITY"); h.CreateCommand(strSql.ToString()); if (model.Number == null) { h.AddParameter("@Number", DBNull.Value); } else { h.AddParameter("@Number", model.Number); } if (model.UserName == null) { h.AddParameter("@UserName", DBNull.Value); } else { h.AddParameter("@UserName", model.UserName); } if (model.Realname == null) { h.AddParameter("@Realname", DBNull.Value); } else { h.AddParameter("@Realname", model.Realname); } if (model.NiName == null) { h.AddParameter("@NiName", DBNull.Value); } else { h.AddParameter("@NiName", model.NiName); } if (model.UserFrom == null) { h.AddParameter("@UserFrom", DBNull.Value); } else { h.AddParameter("@UserFrom", model.UserFrom); } if (model.Password == null) { h.AddParameter("@Password", DBNull.Value); } else { h.AddParameter("@Password", model.Password); } if (model.ChangePasswordDate == null) { h.AddParameter("@ChangePasswordDate", DBNull.Value); } else { h.AddParameter("@ChangePasswordDate", model.ChangePasswordDate); } if (model.Duty == null) { h.AddParameter("@Duty", DBNull.Value); } else { h.AddParameter("@Duty", model.Duty); } if (model.Title == null) { h.AddParameter("@Title", DBNull.Value); } else { h.AddParameter("@Title", model.Title); } if (model.Email == null) { h.AddParameter("@Email", DBNull.Value); } else { h.AddParameter("@Email", model.Email); } if (model.Lang == null) { h.AddParameter("@Lang", DBNull.Value); } else { h.AddParameter("@Lang", model.Lang); } if (model.Sex == null) { h.AddParameter("@Sex", DBNull.Value); } else { h.AddParameter("@Sex", model.Sex); } if (model.Birthday == null) { h.AddParameter("@Birthday", DBNull.Value); } else { h.AddParameter("@Birthday", model.Birthday); } if (model.Mobile == null) { h.AddParameter("@Mobile", DBNull.Value); } else { h.AddParameter("@Mobile", model.Mobile); } if (model.Telephone == null) { h.AddParameter("@Telephone", DBNull.Value); } else { h.AddParameter("@Telephone", model.Telephone); } if (model.QQ == null) { h.AddParameter("@QQ", DBNull.Value); } else { h.AddParameter("@QQ", model.QQ); } if (model.SFZNumber == null) { h.AddParameter("@SFZNumber", DBNull.Value); } else { h.AddParameter("@SFZNumber", model.SFZNumber); } if (model.HomeAddress == null) { h.AddParameter("@HomeAddress", DBNull.Value); } else { h.AddParameter("@HomeAddress", model.HomeAddress); } if (model.HomeTel == null) { h.AddParameter("@HomeTel", DBNull.Value); } else { h.AddParameter("@HomeTel", model.HomeTel); } if (model.WorkAddress == null) { h.AddParameter("@WorkAddress", DBNull.Value); } else { h.AddParameter("@WorkAddress", model.WorkAddress); } if (model.WorkTel == null) { h.AddParameter("@WorkTel", DBNull.Value); } else { h.AddParameter("@WorkTel", model.WorkTel); } if (model.Theme == null) { h.AddParameter("@Theme", DBNull.Value); } else { h.AddParameter("@Theme", model.Theme); } if (model.AllowStartTime == null) { h.AddParameter("@AllowStartTime", DBNull.Value); } else { h.AddParameter("@AllowStartTime", model.AllowStartTime); } if (model.AllowEndTime == null) { h.AddParameter("@AllowEndTime", DBNull.Value); } else { h.AddParameter("@AllowEndTime", model.AllowEndTime); } if (model.LockStartDate == null) { h.AddParameter("@LockStartDate", DBNull.Value); } else { h.AddParameter("@LockStartDate", model.LockStartDate); } if (model.LockEndDate == null) { h.AddParameter("@LockEndDate", DBNull.Value); } else { h.AddParameter("@LockEndDate", model.LockEndDate); } if (model.FirstVisit == null) { h.AddParameter("@FirstVisit", DBNull.Value); } else { h.AddParameter("@FirstVisit", model.FirstVisit); } if (model.PreviousVisit == null) { h.AddParameter("@PreviousVisit", DBNull.Value); } else { h.AddParameter("@PreviousVisit", model.PreviousVisit); } if (model.LastVisit == null) { h.AddParameter("@LastVisit", DBNull.Value); } else { h.AddParameter("@LastVisit", model.LastVisit); } if (model.LogOnCount == null) { h.AddParameter("@LogOnCount", DBNull.Value); } else { h.AddParameter("@LogOnCount", model.LogOnCount); } if (model.IsStaff == null) { h.AddParameter("@IsStaff", DBNull.Value); } else { h.AddParameter("@IsStaff", model.IsStaff); } if (model.IsVisible == null) { h.AddParameter("@IsVisible", DBNull.Value); } else { h.AddParameter("@IsVisible", model.IsVisible); } if (model.IPAddress == null) { h.AddParameter("@IPAddress", DBNull.Value); } else { h.AddParameter("@IPAddress", model.IPAddress); } if (model.MACAddress == null) { h.AddParameter("@MACAddress", DBNull.Value); } else { h.AddParameter("@MACAddress", model.MACAddress); } if (model.Question == null) { h.AddParameter("@Question", DBNull.Value); } else { h.AddParameter("@Question", model.Question); } if (model.AnswerQuestion == null) { h.AddParameter("@AnswerQuestion", DBNull.Value); } else { h.AddParameter("@AnswerQuestion", model.AnswerQuestion); } if (model.UserAddressId == null) { h.AddParameter("@UserAddressId", DBNull.Value); } else { h.AddParameter("@UserAddressId", model.UserAddressId); } if (model.AuditStatus == null) { h.AddParameter("@AuditStatus", DBNull.Value); } else { h.AddParameter("@AuditStatus", model.AuditStatus); } if (model.PY == null) { h.AddParameter("@PY", DBNull.Value); } else { h.AddParameter("@PY", model.PY); } if (model.Sort == null) { h.AddParameter("@Sort", DBNull.Value); } else { h.AddParameter("@Sort", model.Sort); } if (model.Dept_Id == null) { h.AddParameter("@Dept_Id", DBNull.Value); } else { h.AddParameter("@Dept_Id", model.Dept_Id); } if (model.DeptName == null) { h.AddParameter("@DeptName", DBNull.Value); } else { h.AddParameter("@DeptName", model.DeptName); } if (model.Company_Id == null) { h.AddParameter("@Company_Id", DBNull.Value); } else { h.AddParameter("@Company_Id", model.Company_Id); } if (model.CompanyName == null) { h.AddParameter("@CompanyName", DBNull.Value); } else { h.AddParameter("@CompanyName", model.CompanyName); } if (model.Bloc_Id == null) { h.AddParameter("@Bloc_Id", DBNull.Value); } else { h.AddParameter("@Bloc_Id", model.Bloc_Id); } if (model.BlocName == null) { h.AddParameter("@BlocName", DBNull.Value); } else { h.AddParameter("@BlocName", model.BlocName); } if (model.CreateUserId == null) { h.AddParameter("@CreateUserId", DBNull.Value); } else { h.AddParameter("@CreateUserId", model.CreateUserId); } if (model.CreateName == null) { h.AddParameter("@CreateName", DBNull.Value); } else { h.AddParameter("@CreateName", model.CreateName); } if (model.CreateDate == null) { h.AddParameter("@CreateDate", DBNull.Value); } else { h.AddParameter("@CreateDate", model.CreateDate); } if (model.EditUserId == null) { h.AddParameter("@EditUserId", DBNull.Value); } else { h.AddParameter("@EditUserId", model.EditUserId); } if (model.EditUserName == null) { h.AddParameter("@EditUserName", DBNull.Value); } else { h.AddParameter("@EditUserName", model.EditUserName); } if (model.EditDate == null) { h.AddParameter("@EditDate", DBNull.Value); } else { h.AddParameter("@EditDate", model.EditDate); } if (model.Remark == null) { h.AddParameter("@Remark", DBNull.Value); } else { h.AddParameter("@Remark", model.Remark); } if (model.State == null) { h.AddParameter("@State", DBNull.Value); } else { h.AddParameter("@State", model.State); } if (model.SystemId == null) { h.AddParameter("@SystemId", DBNull.Value); } else { h.AddParameter("@SystemId", model.SystemId); } int result; string obj = h.ExecuteScalar(); if (!int.TryParse(obj, out result)) { return(0); } return(result); }
/// <summary>增加一条数据 /// /// </summary> public int Add(Nikita.Permission.Model.Bse_Role model) { IMsSqlDataAccessService h = ServiceHelper.GetMsSqlDataAccessService(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Bse_Role("); strSql.Append("SystemId, RoleNumber, Name, Type, AllowEdit, AllowDelete, IsVisible, OwnerCompany, PY, Sort, Dept_Id, DeptName, Company_Id, CompanyName, Bloc_Id, BlocName, CreateUserId, CreateName, CreateDate, EditUserId, EditUserName, EditDate, Remark, State )"); strSql.Append(" values ("); strSql.Append("@SystemId, @RoleNumber, @Name, @Type, @AllowEdit, @AllowDelete, @IsVisible, @OwnerCompany, @PY, @Sort, @Dept_Id, @DeptName, @Company_Id, @CompanyName, @Bloc_Id, @BlocName, @CreateUserId, @CreateName, @CreateDate, @EditUserId, @EditUserName, @EditDate, @Remark, @State )"); strSql.Append(";select @@IDENTITY"); h.CreateCommand(strSql.ToString()); if (model.SystemId == null) { h.AddParameter("@SystemId", DBNull.Value); } else { h.AddParameter("@SystemId", model.SystemId); } if (model.RoleNumber == null) { h.AddParameter("@RoleNumber", DBNull.Value); } else { h.AddParameter("@RoleNumber", model.RoleNumber); } if (model.Name == null) { h.AddParameter("@Name", DBNull.Value); } else { h.AddParameter("@Name", model.Name); } if (model.Type == null) { h.AddParameter("@Type", DBNull.Value); } else { h.AddParameter("@Type", model.Type); } if (model.AllowEdit == null) { h.AddParameter("@AllowEdit", DBNull.Value); } else { h.AddParameter("@AllowEdit", model.AllowEdit); } if (model.AllowDelete == null) { h.AddParameter("@AllowDelete", DBNull.Value); } else { h.AddParameter("@AllowDelete", model.AllowDelete); } if (model.IsVisible == null) { h.AddParameter("@IsVisible", DBNull.Value); } else { h.AddParameter("@IsVisible", model.IsVisible); } if (model.OwnerCompany == null) { h.AddParameter("@OwnerCompany", DBNull.Value); } else { h.AddParameter("@OwnerCompany", model.OwnerCompany); } if (model.PY == null) { h.AddParameter("@PY", DBNull.Value); } else { h.AddParameter("@PY", model.PY); } if (model.Sort == null) { h.AddParameter("@Sort", DBNull.Value); } else { h.AddParameter("@Sort", model.Sort); } if (model.Dept_Id == null) { h.AddParameter("@Dept_Id", DBNull.Value); } else { h.AddParameter("@Dept_Id", model.Dept_Id); } if (model.DeptName == null) { h.AddParameter("@DeptName", DBNull.Value); } else { h.AddParameter("@DeptName", model.DeptName); } if (model.Company_Id == null) { h.AddParameter("@Company_Id", DBNull.Value); } else { h.AddParameter("@Company_Id", model.Company_Id); } if (model.CompanyName == null) { h.AddParameter("@CompanyName", DBNull.Value); } else { h.AddParameter("@CompanyName", model.CompanyName); } if (model.Bloc_Id == null) { h.AddParameter("@Bloc_Id", DBNull.Value); } else { h.AddParameter("@Bloc_Id", model.Bloc_Id); } if (model.BlocName == null) { h.AddParameter("@BlocName", DBNull.Value); } else { h.AddParameter("@BlocName", model.BlocName); } if (model.CreateUserId == null) { h.AddParameter("@CreateUserId", DBNull.Value); } else { h.AddParameter("@CreateUserId", model.CreateUserId); } if (model.CreateName == null) { h.AddParameter("@CreateName", DBNull.Value); } else { h.AddParameter("@CreateName", model.CreateName); } if (model.CreateDate == null) { h.AddParameter("@CreateDate", DBNull.Value); } else { h.AddParameter("@CreateDate", model.CreateDate); } if (model.EditUserId == null) { h.AddParameter("@EditUserId", DBNull.Value); } else { h.AddParameter("@EditUserId", model.EditUserId); } if (model.EditUserName == null) { h.AddParameter("@EditUserName", DBNull.Value); } else { h.AddParameter("@EditUserName", model.EditUserName); } if (model.EditDate == null) { h.AddParameter("@EditDate", DBNull.Value); } else { h.AddParameter("@EditDate", model.EditDate); } if (model.Remark == null) { h.AddParameter("@Remark", DBNull.Value); } else { h.AddParameter("@Remark", model.Remark); } if (model.State == null) { h.AddParameter("@State", DBNull.Value); } else { h.AddParameter("@State", model.State); } int result; string obj = h.ExecuteScalar(); if (!int.TryParse(obj, out result)) { return(0); } return(result); }
/// <summary>增加一条数据 /// /// </summary> public int Add(Nikita.Permission.Model.Bse_Menu model) { IMsSqlDataAccessService h = ServiceHelper.GetMsSqlDataAccessService(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Bse_Menu("); strSql.Append("ParentId, Number, Name, Category, GroupTxt, ImagUrl, ImageIndex, SelectedImageIndex, NavigateUrl, Target, FormName, DeletionStateCode, IsPublic, Expand, AllowEdit, AllowDelete, PY, Sort, Dept_Id, DeptName, Company_Id, CompanyName, Bloc_Id, BlocName, CreateUserId, CreateName, CreateDate, EditUserId, EditUserName, EditDate, Remark, State, TileItemSize, SystemId,ControlPower )"); strSql.Append(" values ("); strSql.Append("@ParentId, @Number, @Name, @Category, @GroupTxt, @ImagUrl, @ImageIndex, @SelectedImageIndex, @NavigateUrl, @Target, @FormName, @DeletionStateCode, @IsPublic, @Expand, @AllowEdit, @AllowDelete, @PY, @Sort, @Dept_Id, @DeptName, @Company_Id, @CompanyName, @Bloc_Id, @BlocName, @CreateUserId, @CreateName, @CreateDate, @EditUserId, @EditUserName, @EditDate, @Remark, @State, @TileItemSize, @SystemId , @ControlPower)"); strSql.Append(";select @@IDENTITY"); h.CreateCommand(strSql.ToString()); if (model.ParentId == null) { h.AddParameter("@ParentId", DBNull.Value); } else { h.AddParameter("@ParentId", model.ParentId); } if (model.Number == null) { h.AddParameter("@Number", DBNull.Value); } else { h.AddParameter("@Number", model.Number); } if (model.Name == null) { h.AddParameter("@Name", DBNull.Value); } else { h.AddParameter("@Name", model.Name); } if (model.Category == null) { h.AddParameter("@Category", DBNull.Value); } else { h.AddParameter("@Category", model.Category); } if (model.GroupTxt == null) { h.AddParameter("@GroupTxt", DBNull.Value); } else { h.AddParameter("@GroupTxt", model.GroupTxt); } if (model.ImagUrl == null) { h.AddParameter("@ImagUrl", DBNull.Value); } else { h.AddParameter("@ImagUrl", model.ImagUrl); } if (model.ImageIndex == null) { h.AddParameter("@ImageIndex", DBNull.Value); } else { h.AddParameter("@ImageIndex", model.ImageIndex); } if (model.SelectedImageIndex == null) { h.AddParameter("@SelectedImageIndex", DBNull.Value); } else { h.AddParameter("@SelectedImageIndex", model.SelectedImageIndex); } if (model.NavigateUrl == null) { h.AddParameter("@NavigateUrl", DBNull.Value); } else { h.AddParameter("@NavigateUrl", model.NavigateUrl); } if (model.Target == null) { h.AddParameter("@Target", DBNull.Value); } else { h.AddParameter("@Target", model.Target); } if (model.FormName == null) { h.AddParameter("@FormName", DBNull.Value); } else { h.AddParameter("@FormName", model.FormName); } if (model.DeletionStateCode == null) { h.AddParameter("@DeletionStateCode", DBNull.Value); } else { h.AddParameter("@DeletionStateCode", model.DeletionStateCode); } if (model.IsPublic == null) { h.AddParameter("@IsPublic", DBNull.Value); } else { h.AddParameter("@IsPublic", model.IsPublic); } if (model.Expand == null) { h.AddParameter("@Expand", DBNull.Value); } else { h.AddParameter("@Expand", model.Expand); } if (model.AllowEdit == null) { h.AddParameter("@AllowEdit", DBNull.Value); } else { h.AddParameter("@AllowEdit", model.AllowEdit); } if (model.AllowDelete == null) { h.AddParameter("@AllowDelete", DBNull.Value); } else { h.AddParameter("@AllowDelete", model.AllowDelete); } if (model.PY == null) { h.AddParameter("@PY", DBNull.Value); } else { h.AddParameter("@PY", model.PY); } if (model.Sort == null) { h.AddParameter("@Sort", DBNull.Value); } else { h.AddParameter("@Sort", model.Sort); } if (model.Dept_Id == null) { h.AddParameter("@Dept_Id", DBNull.Value); } else { h.AddParameter("@Dept_Id", model.Dept_Id); } if (model.DeptName == null) { h.AddParameter("@DeptName", DBNull.Value); } else { h.AddParameter("@DeptName", model.DeptName); } if (model.Company_Id == null) { h.AddParameter("@Company_Id", DBNull.Value); } else { h.AddParameter("@Company_Id", model.Company_Id); } if (model.CompanyName == null) { h.AddParameter("@CompanyName", DBNull.Value); } else { h.AddParameter("@CompanyName", model.CompanyName); } if (model.Bloc_Id == null) { h.AddParameter("@Bloc_Id", DBNull.Value); } else { h.AddParameter("@Bloc_Id", model.Bloc_Id); } if (model.BlocName == null) { h.AddParameter("@BlocName", DBNull.Value); } else { h.AddParameter("@BlocName", model.BlocName); } if (model.CreateUserId == null) { h.AddParameter("@CreateUserId", DBNull.Value); } else { h.AddParameter("@CreateUserId", model.CreateUserId); } if (model.CreateName == null) { h.AddParameter("@CreateName", DBNull.Value); } else { h.AddParameter("@CreateName", model.CreateName); } if (model.CreateDate == null) { h.AddParameter("@CreateDate", DBNull.Value); } else { h.AddParameter("@CreateDate", model.CreateDate); } if (model.EditUserId == null) { h.AddParameter("@EditUserId", DBNull.Value); } else { h.AddParameter("@EditUserId", model.EditUserId); } if (model.EditUserName == null) { h.AddParameter("@EditUserName", DBNull.Value); } else { h.AddParameter("@EditUserName", model.EditUserName); } if (model.EditDate == null) { h.AddParameter("@EditDate", DBNull.Value); } else { h.AddParameter("@EditDate", model.EditDate); } if (model.Remark == null) { h.AddParameter("@Remark", DBNull.Value); } else { h.AddParameter("@Remark", model.Remark); } if (model.State == null) { h.AddParameter("@State", DBNull.Value); } else { h.AddParameter("@State", model.State); } if (model.TileItemSize == null) { h.AddParameter("@TileItemSize", DBNull.Value); } else { h.AddParameter("@TileItemSize", model.TileItemSize); } if (model.SystemId == null) { h.AddParameter("@SystemId", DBNull.Value); } else { h.AddParameter("@SystemId", model.SystemId); } if (model.ControlPower == null) { h.AddParameter("@ControlPower", DBNull.Value); } else { h.AddParameter("@ControlPower", model.ControlPower); } int result; string obj = h.ExecuteScalar(); if (!int.TryParse(obj, out result)) { return(0); } return(result); }
/// <summary>增加一条数据 /// /// </summary> public int Add(Nikita.Permission.Model.Bse_SetOrd model) { IMsSqlDataAccessService h = ServiceHelper.GetMsSqlDataAccessService(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Bse_SetOrd("); strSql.Append("SetOrd_Key, Name, PY, Sort, Dept_Id, Company_Id, Bloc_Id, CreateName, CreateUserId, CreateDate, Remark, State, SystemId )"); strSql.Append(" values ("); strSql.Append("@SetOrd_Key, @Name, @PY, @Sort, @Dept_Id, @Company_Id, @Bloc_Id, @CreateName, @CreateUserId, @CreateDate, @Remark, @State, @SystemId )"); strSql.Append(";select @@IDENTITY"); h.CreateCommand(strSql.ToString()); if (model.SetOrd_Key == null) { h.AddParameter("@SetOrd_Key", DBNull.Value); } else { h.AddParameter("@SetOrd_Key", model.SetOrd_Key); } if (model.Name == null) { h.AddParameter("@Name", DBNull.Value); } else { h.AddParameter("@Name", model.Name); } if (model.PY == null) { h.AddParameter("@PY", DBNull.Value); } else { h.AddParameter("@PY", model.PY); } if (model.Sort == null) { h.AddParameter("@Sort", DBNull.Value); } else { h.AddParameter("@Sort", model.Sort); } if (model.Dept_Id == null) { h.AddParameter("@Dept_Id", DBNull.Value); } else { h.AddParameter("@Dept_Id", model.Dept_Id); } if (model.Company_Id == null) { h.AddParameter("@Company_Id", DBNull.Value); } else { h.AddParameter("@Company_Id", model.Company_Id); } if (model.Bloc_Id == null) { h.AddParameter("@Bloc_Id", DBNull.Value); } else { h.AddParameter("@Bloc_Id", model.Bloc_Id); } if (model.CreateName == null) { h.AddParameter("@CreateName", DBNull.Value); } else { h.AddParameter("@CreateName", model.CreateName); } if (model.CreateUserId == null) { h.AddParameter("@CreateUserId", DBNull.Value); } else { h.AddParameter("@CreateUserId", model.CreateUserId); } if (model.CreateDate == null) { h.AddParameter("@CreateDate", DBNull.Value); } else { h.AddParameter("@CreateDate", model.CreateDate); } if (model.Remark == null) { h.AddParameter("@Remark", DBNull.Value); } else { h.AddParameter("@Remark", model.Remark); } if (model.State == null) { h.AddParameter("@State", DBNull.Value); } else { h.AddParameter("@State", model.State); } if (model.SystemId == null) { h.AddParameter("@SystemId", DBNull.Value); } else { h.AddParameter("@SystemId", model.SystemId); } int result; string obj = h.ExecuteScalar(); if (!int.TryParse(obj, out result)) { return(0); } return(result); }
/// <summary>增加一条数据 /// /// </summary> public int Add(Nikita.Permission.Model.Bse_User_Organize model) { IMsSqlDataAccessService h = ServiceHelper.GetMsSqlDataAccessService(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Bse_User_Organize("); strSql.Append("User_Id, Organize_Id, DeletionStateCode, Sort, Dept_Id, DeptName, Company_Id, CompanyName, Bloc_Id, BlocName, CreateUserId, CreateName, CreateDate, EditUserId, EditUserName, EditDate, Remark, State, SystemId )"); strSql.Append(" values ("); strSql.Append("@User_Id, @Organize_Id, @DeletionStateCode, @Sort, @Dept_Id, @DeptName, @Company_Id, @CompanyName, @Bloc_Id, @BlocName, @CreateUserId, @CreateName, @CreateDate, @EditUserId, @EditUserName, @EditDate, @Remark, @State, @SystemId )"); strSql.Append(";select @@IDENTITY"); h.CreateCommand(strSql.ToString()); if (model.User_Id == null) { h.AddParameter("@User_Id", DBNull.Value); } else { h.AddParameter("@User_Id", model.User_Id); } if (model.Organize_Id == null) { h.AddParameter("@Organize_Id", DBNull.Value); } else { h.AddParameter("@Organize_Id", model.Organize_Id); } if (model.DeletionStateCode == null) { h.AddParameter("@DeletionStateCode", DBNull.Value); } else { h.AddParameter("@DeletionStateCode", model.DeletionStateCode); } if (model.Sort == null) { h.AddParameter("@Sort", DBNull.Value); } else { h.AddParameter("@Sort", model.Sort); } if (model.Dept_Id == null) { h.AddParameter("@Dept_Id", DBNull.Value); } else { h.AddParameter("@Dept_Id", model.Dept_Id); } if (model.DeptName == null) { h.AddParameter("@DeptName", DBNull.Value); } else { h.AddParameter("@DeptName", model.DeptName); } if (model.Company_Id == null) { h.AddParameter("@Company_Id", DBNull.Value); } else { h.AddParameter("@Company_Id", model.Company_Id); } if (model.CompanyName == null) { h.AddParameter("@CompanyName", DBNull.Value); } else { h.AddParameter("@CompanyName", model.CompanyName); } if (model.Bloc_Id == null) { h.AddParameter("@Bloc_Id", DBNull.Value); } else { h.AddParameter("@Bloc_Id", model.Bloc_Id); } if (model.BlocName == null) { h.AddParameter("@BlocName", DBNull.Value); } else { h.AddParameter("@BlocName", model.BlocName); } if (model.CreateUserId == null) { h.AddParameter("@CreateUserId", DBNull.Value); } else { h.AddParameter("@CreateUserId", model.CreateUserId); } if (model.CreateName == null) { h.AddParameter("@CreateName", DBNull.Value); } else { h.AddParameter("@CreateName", model.CreateName); } if (model.CreateDate == null) { h.AddParameter("@CreateDate", DBNull.Value); } else { h.AddParameter("@CreateDate", model.CreateDate); } if (model.EditUserId == null) { h.AddParameter("@EditUserId", DBNull.Value); } else { h.AddParameter("@EditUserId", model.EditUserId); } if (model.EditUserName == null) { h.AddParameter("@EditUserName", DBNull.Value); } else { h.AddParameter("@EditUserName", model.EditUserName); } if (model.EditDate == null) { h.AddParameter("@EditDate", DBNull.Value); } else { h.AddParameter("@EditDate", model.EditDate); } if (model.Remark == null) { h.AddParameter("@Remark", DBNull.Value); } else { h.AddParameter("@Remark", model.Remark); } if (model.State == null) { h.AddParameter("@State", DBNull.Value); } else { h.AddParameter("@State", model.State); } if (model.SystemId == null) { h.AddParameter("@SystemId", DBNull.Value); } else { h.AddParameter("@SystemId", model.SystemId); } int result; string obj = h.ExecuteScalar(); if (!int.TryParse(obj, out result)) { return(0); } return(result); }
/// <summary>增加一条数据 /// /// </summary> public int Add(Nikita.Permission.Model.Bse_System model) { IMsSqlDataAccessService h = ServiceHelper.GetMsSqlDataAccessService(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Bse_System("); strSql.Append("System_Name, System_Type, System_Version, System_Language, CustNumber, LimitNumber, PY, Sort, Dept_Id, DeptName, Company_Id, CompanyName, Bloc_Id, BlocName, CreateUserId, CreateName, CreateDate, EditUserId, EditUserName, EditDate, Remark, State )"); strSql.Append(" values ("); strSql.Append("@System_Name, @System_Type, @System_Version, @System_Language, @CustNumber, @LimitNumber, @PY, @Sort, @Dept_Id, @DeptName, @Company_Id, @CompanyName, @Bloc_Id, @BlocName, @CreateUserId, @CreateName, @CreateDate, @EditUserId, @EditUserName, @EditDate, @Remark, @State )"); strSql.Append(";select @@IDENTITY"); h.CreateCommand(strSql.ToString()); if (model.System_Name == null) { h.AddParameter("@System_Name", DBNull.Value); } else { h.AddParameter("@System_Name", model.System_Name); } if (model.System_Type == null) { h.AddParameter("@System_Type", DBNull.Value); } else { h.AddParameter("@System_Type", model.System_Type); } if (model.System_Version == null) { h.AddParameter("@System_Version", DBNull.Value); } else { h.AddParameter("@System_Version", model.System_Version); } if (model.System_Language == null) { h.AddParameter("@System_Language", DBNull.Value); } else { h.AddParameter("@System_Language", model.System_Language); } if (model.CustNumber == null) { h.AddParameter("@CustNumber", DBNull.Value); } else { h.AddParameter("@CustNumber", model.CustNumber); } if (model.LimitNumber == null) { h.AddParameter("@LimitNumber", DBNull.Value); } else { h.AddParameter("@LimitNumber", model.LimitNumber); } if (model.PY == null) { h.AddParameter("@PY", DBNull.Value); } else { h.AddParameter("@PY", model.PY); } if (model.Sort == null) { h.AddParameter("@Sort", DBNull.Value); } else { h.AddParameter("@Sort", model.Sort); } if (model.Dept_Id == null) { h.AddParameter("@Dept_Id", DBNull.Value); } else { h.AddParameter("@Dept_Id", model.Dept_Id); } if (model.DeptName == null) { h.AddParameter("@DeptName", DBNull.Value); } else { h.AddParameter("@DeptName", model.DeptName); } if (model.Company_Id == null) { h.AddParameter("@Company_Id", DBNull.Value); } else { h.AddParameter("@Company_Id", model.Company_Id); } if (model.CompanyName == null) { h.AddParameter("@CompanyName", DBNull.Value); } else { h.AddParameter("@CompanyName", model.CompanyName); } if (model.Bloc_Id == null) { h.AddParameter("@Bloc_Id", DBNull.Value); } else { h.AddParameter("@Bloc_Id", model.Bloc_Id); } if (model.BlocName == null) { h.AddParameter("@BlocName", DBNull.Value); } else { h.AddParameter("@BlocName", model.BlocName); } if (model.CreateUserId == null) { h.AddParameter("@CreateUserId", DBNull.Value); } else { h.AddParameter("@CreateUserId", model.CreateUserId); } if (model.CreateName == null) { h.AddParameter("@CreateName", DBNull.Value); } else { h.AddParameter("@CreateName", model.CreateName); } if (model.CreateDate == null) { h.AddParameter("@CreateDate", DBNull.Value); } else { h.AddParameter("@CreateDate", model.CreateDate); } if (model.EditUserId == null) { h.AddParameter("@EditUserId", DBNull.Value); } else { h.AddParameter("@EditUserId", model.EditUserId); } if (model.EditUserName == null) { h.AddParameter("@EditUserName", DBNull.Value); } else { h.AddParameter("@EditUserName", model.EditUserName); } if (model.EditDate == null) { h.AddParameter("@EditDate", DBNull.Value); } else { h.AddParameter("@EditDate", model.EditDate); } if (model.Remark == null) { h.AddParameter("@Remark", DBNull.Value); } else { h.AddParameter("@Remark", model.Remark); } if (model.State == null) { h.AddParameter("@State", DBNull.Value); } else { h.AddParameter("@State", model.State); } int result; string obj = h.ExecuteScalar(); if (!int.TryParse(obj, out result)) { return(0); } return(result); }
/// <summary>增加一条数据 /// /// </summary> public int Add(Nikita.Permission.Model.Bse_Organize model) { IMsSqlDataAccessService h = ServiceHelper.GetMsSqlDataAccessService(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Bse_Organize("); strSql.Append("ParentId, Number, Name, ShortName, Category, OuterPhone, InnerPhone, Fax, Postalcode, Address, Web, Bank, BankAccount, Layer, IsInnerOrganize, DeletionStateCode, PY, Sort, Dept_Id, DeptName, Company_Id, CompanyName, Bloc_Id, BlocName, CreateUserId, CreateName, CreateDate, EditUserId, EditUserName, EditDate, Remark, State, SystemId )"); strSql.Append(" values ("); strSql.Append("@ParentId, @Number, @Name, @ShortName, @Category, @OuterPhone, @InnerPhone, @Fax, @Postalcode, @Address, @Web, @Bank, @BankAccount, @Layer, @IsInnerOrganize, @DeletionStateCode, @PY, @Sort, @Dept_Id, @DeptName, @Company_Id, @CompanyName, @Bloc_Id, @BlocName, @CreateUserId, @CreateName, @CreateDate, @EditUserId, @EditUserName, @EditDate, @Remark, @State, @SystemId )"); strSql.Append(";select @@IDENTITY"); h.CreateCommand(strSql.ToString()); if (model.ParentId == null) { h.AddParameter("@ParentId", DBNull.Value); } else { h.AddParameter("@ParentId", model.ParentId); } if (model.Number == null) { h.AddParameter("@Number", DBNull.Value); } else { h.AddParameter("@Number", model.Number); } if (model.Name == null) { h.AddParameter("@Name", DBNull.Value); } else { h.AddParameter("@Name", model.Name); } if (model.ShortName == null) { h.AddParameter("@ShortName", DBNull.Value); } else { h.AddParameter("@ShortName", model.ShortName); } if (model.Category == null) { h.AddParameter("@Category", DBNull.Value); } else { h.AddParameter("@Category", model.Category); } if (model.OuterPhone == null) { h.AddParameter("@OuterPhone", DBNull.Value); } else { h.AddParameter("@OuterPhone", model.OuterPhone); } if (model.InnerPhone == null) { h.AddParameter("@InnerPhone", DBNull.Value); } else { h.AddParameter("@InnerPhone", model.InnerPhone); } if (model.Fax == null) { h.AddParameter("@Fax", DBNull.Value); } else { h.AddParameter("@Fax", model.Fax); } if (model.Postalcode == null) { h.AddParameter("@Postalcode", DBNull.Value); } else { h.AddParameter("@Postalcode", model.Postalcode); } if (model.Address == null) { h.AddParameter("@Address", DBNull.Value); } else { h.AddParameter("@Address", model.Address); } if (model.Web == null) { h.AddParameter("@Web", DBNull.Value); } else { h.AddParameter("@Web", model.Web); } if (model.Bank == null) { h.AddParameter("@Bank", DBNull.Value); } else { h.AddParameter("@Bank", model.Bank); } if (model.BankAccount == null) { h.AddParameter("@BankAccount", DBNull.Value); } else { h.AddParameter("@BankAccount", model.BankAccount); } if (model.Layer == null) { h.AddParameter("@Layer", DBNull.Value); } else { h.AddParameter("@Layer", model.Layer); } if (model.IsInnerOrganize == null) { h.AddParameter("@IsInnerOrganize", DBNull.Value); } else { h.AddParameter("@IsInnerOrganize", model.IsInnerOrganize); } if (model.DeletionStateCode == null) { h.AddParameter("@DeletionStateCode", DBNull.Value); } else { h.AddParameter("@DeletionStateCode", model.DeletionStateCode); } if (model.PY == null) { h.AddParameter("@PY", DBNull.Value); } else { h.AddParameter("@PY", model.PY); } if (model.Sort == null) { h.AddParameter("@Sort", DBNull.Value); } else { h.AddParameter("@Sort", model.Sort); } if (model.Dept_Id == null) { h.AddParameter("@Dept_Id", DBNull.Value); } else { h.AddParameter("@Dept_Id", model.Dept_Id); } if (model.DeptName == null) { h.AddParameter("@DeptName", DBNull.Value); } else { h.AddParameter("@DeptName", model.DeptName); } if (model.Company_Id == null) { h.AddParameter("@Company_Id", DBNull.Value); } else { h.AddParameter("@Company_Id", model.Company_Id); } if (model.CompanyName == null) { h.AddParameter("@CompanyName", DBNull.Value); } else { h.AddParameter("@CompanyName", model.CompanyName); } if (model.Bloc_Id == null) { h.AddParameter("@Bloc_Id", DBNull.Value); } else { h.AddParameter("@Bloc_Id", model.Bloc_Id); } if (model.BlocName == null) { h.AddParameter("@BlocName", DBNull.Value); } else { h.AddParameter("@BlocName", model.BlocName); } if (model.CreateUserId == null) { h.AddParameter("@CreateUserId", DBNull.Value); } else { h.AddParameter("@CreateUserId", model.CreateUserId); } if (model.CreateName == null) { h.AddParameter("@CreateName", DBNull.Value); } else { h.AddParameter("@CreateName", model.CreateName); } if (model.CreateDate == null) { h.AddParameter("@CreateDate", DBNull.Value); } else { h.AddParameter("@CreateDate", model.CreateDate); } if (model.EditUserId == null) { h.AddParameter("@EditUserId", DBNull.Value); } else { h.AddParameter("@EditUserId", model.EditUserId); } if (model.EditUserName == null) { h.AddParameter("@EditUserName", DBNull.Value); } else { h.AddParameter("@EditUserName", model.EditUserName); } if (model.EditDate == null) { h.AddParameter("@EditDate", DBNull.Value); } else { h.AddParameter("@EditDate", model.EditDate); } if (model.Remark == null) { h.AddParameter("@Remark", DBNull.Value); } else { h.AddParameter("@Remark", model.Remark); } if (model.State == null) { h.AddParameter("@State", DBNull.Value); } else { h.AddParameter("@State", model.State); } if (model.SystemId == null) { h.AddParameter("@SystemId", DBNull.Value); } else { h.AddParameter("@SystemId", model.SystemId); } int result; string obj = h.ExecuteScalar(); if (!int.TryParse(obj, out result)) { return(0); } return(result); }