public static int Insert(RoleEntity roleEntity) { if (roleEntity.RoleDBEntity.Count == 0) { return 0; } //if (roleEntity.LogMessages == null) //{ // return 0; //} if (CheckInsert(roleEntity) > 0) { return 2; } RoleDBEntity dbParm = (roleEntity.RoleDBEntity.Count > 0) ? roleEntity.RoleDBEntity[0] : new RoleDBEntity(); DataCommand cmd = DataCommandManager.GetDataCommand("InsertRole"); cmd.SetParameterValue("@Role_Name", dbParm.RoleName); cmd.SetParameterValue("@Create_Time", dbParm.CreateTime); cmd.SetParameterValue("@Update_Time", dbParm.UpdateTime); cmd.SetParameterValue("@Role_Creator", dbParm.RoleCreator); cmd.SetParameterValue("@IS_AD", dbParm.IsAD); int intCount = cmd.ExecuteNonQuery(); return intCount; }
public static int CheckUpdate(RoleEntity roleEntity) { RoleDBEntity dbParm = (roleEntity.RoleDBEntity.Count > 0) ? roleEntity.RoleDBEntity[0] : new RoleDBEntity(); DataCommand cmd = DataCommandManager.GetDataCommand("SelectRoleNameByNotEqualID");//判断新改的这个角色名称是否已经存在。 cmd.SetParameterValue("@Role_Name", dbParm.RoleName); cmd.SetParameterValue("@IS_AD", dbParm.IsAD); cmd.SetParameterValue("@Role_ID", dbParm.RoleID); System.Data.DataSet dsResult = cmd.ExecuteDataSet(); if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0) { return 1; } return 0; }
public static int Delete(RoleEntity roleEntity) { try { RoleDBEntity dbParm = (roleEntity.RoleDBEntity.Count > 0) ? roleEntity.RoleDBEntity[0] : new RoleDBEntity(); DataCommand cmd = DataCommandManager.GetDataCommand("DeleteRoleByID");//根据RoleID进行删除 cmd.SetParameterValue("@Role_ID", dbParm.RoleID); int intCount = cmd.ExecuteNonQuery(); return intCount; } catch { return 0; } }
public static int CheckInsert(RoleEntity roleEntity) { RoleDBEntity dbParm = (roleEntity.RoleDBEntity.Count > 0) ? roleEntity.RoleDBEntity[0] : new RoleDBEntity(); DataCommand cmd = DataCommandManager.GetDataCommand("SelectByRoleName"); cmd.SetParameterValue("@Role_Name", dbParm.RoleName); cmd.SetParameterValue("@IS_AD", dbParm.IsAD); System.Data.DataSet dsResult = cmd.ExecuteDataSet(); if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0) { return 1; } return 0; }
//修改 public static int Update(RoleEntity roleEntity) { //roleEntity.LogMessages.MsgType = MessageType.INFO; //roleEntity.LogMessages.Content = _nameSpaceClass + "Update"; //LoggerHelper.LogWriter(roleEntity.LogMessages); try { return RoleDA.Update(roleEntity); //RegChannelDA.Insert(regChannelEntity); } catch (Exception ex) { //roleEntity.LogMessages.MsgType = MessageType.ERROR; //roleEntity.LogMessages.Content = _nameSpaceClass + "Update Error: " + ex.Message; throw ex; } }