/// <summary>
/// 更新一筆客戶資料
/// </summary>
/// <param name="model">客戶類別</param>
/// <returns></returns>
public bool UpdateCustomer(RedGlovePermission.Model.Customers model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update COPMA set ");
strSql.Append("MA002=@CustomerAbbrev,");
strSql.Append("MA027=@Address,");
strSql.Append("MODIFIER=@Modifier,");
strSql.Append("MODI_DATE=@Modi_Date");
strSql.Append(" where MA001=@CustomerID ");
SqlParameter[] parameters = {
new SqlParameter("@CustomerID", SqlDbType.Char,10),
new SqlParameter("@CustomerAbbrev", SqlDbType.Char,10),
new SqlParameter("@Address", SqlDbType.Char,72),
new SqlParameter("@Modifier", SqlDbType.Char,10),
new SqlParameter("@Modi_Date", SqlDbType.Char,8)};
parameters[0].Value = model.CustomerID;
parameters[1].Value = model.CustomerAbbrev;
parameters[2].Value = model.Address;
parameters[3].Value = model.Modifier;
parameters[4].Value = model.Modi_Date;
if (SqlServerHelper.ExecuteSql(strSql.ToString(), parameters) >= 1)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一个权限
/// </summary>
/// <param name="model">权限实体类</param>
/// <returns></returns>
public bool CreateAuthority(RedGlovePermission.Model.RGP_AuthorityDir model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into RGP_AuthorityDir(");
strSql.Append("AuthorityName,AuthorityTag,AuthorityDescription,AuthorityOrder)");
strSql.Append(" values (");
strSql.Append("?AuthorityName,?AuthorityTag,?AuthorityDescription,?AuthorityOrder)");
MySqlParameter[] parameters = {
new MySqlParameter("?AuthorityName", MySqlDbType.VarChar,30),
new MySqlParameter("?AuthorityTag", MySqlDbType.VarChar,50),
new MySqlParameter("?AuthorityDescription", MySqlDbType.VarChar,50),
new MySqlParameter("?AuthorityOrder", MySqlDbType.Int32,11)};
parameters[0].Value = model.AuthorityName;
parameters[1].Value = model.AuthorityTag;
parameters[2].Value = model.AuthorityDescription;
parameters[3].Value = model.AuthorityOrder;
if (RedGlovePermission.DBUtility.MySqlHelper.ExecuteSql(strSql.ToString(), parameters) >= 1)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一個代碼資料
/// </summary>
/// <param name="model">代碼類別</param>
/// <returns></returns>
public bool UpdateCode(RedGlovePermission.Model.Basic_System model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Basic_System set ");
strSql.Append("Items=@Items,");
strSql.Append("MODIFIER=@Modifier,");
strSql.Append("MODI_DATE=@Modi_Date");
strSql.Append(" where Code=@Code ");
SqlParameter[] parameters = {
new SqlParameter("@Code", SqlDbType.Char,10),
new SqlParameter("@Items", SqlDbType.Char,200),
new SqlParameter("@Modifier", SqlDbType.Char,10),
new SqlParameter("@Modi_Date", SqlDbType.Char,8)};
parameters[0].Value = model.Code;
parameters[1].Value = model.Items;
parameters[2].Value = model.Modifier;
parameters[3].Value = model.Modi_Date;
if (SqlServerHelper.ExecuteSql(strSql.ToString(), parameters) >= 1)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一個客戶
/// </summary>
/// <param name="model">客戶類別</param>
/// <returns></returns>
public bool CreateCustomer(RedGlovePermission.Model.Customers model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into COPMA(");
strSql.Append("MA001,MA002,MA027,CREATOR,CREATE_DATE)");
strSql.Append(" values (");
strSql.Append("@CustomerID,@CustomerAbbrev,@Address,@Creator,@Create_Date)");
SqlParameter[] parameters = {
new SqlParameter("@CustomerID", SqlDbType.Char,10),
new SqlParameter("@CustomerAbbrev", SqlDbType.Char,10),
new SqlParameter("@Address", SqlDbType.Char,72),
new SqlParameter("@Creator", SqlDbType.Char,10),
new SqlParameter("@Create_Date", SqlDbType.Char,8)};
parameters[0].Value = model.CustomerID;
parameters[1].Value = model.CustomerAbbrev;
parameters[2].Value = model.Address;
parameters[3].Value = model.Creator;
parameters[4].Value = model.Create_Date;
if (SqlServerHelper.ExecuteSql(strSql.ToString(), parameters) >= 1)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一個代碼
/// </summary>
/// <param name="model">代碼類別</param>
/// <returns></returns>
public bool CreateCode(RedGlovePermission.Model.Basic_System model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Basic_System(");
strSql.Append("Code,Items,CREATOR,CREATE_DATE)");
strSql.Append(" values (");
strSql.Append("@Code,@Items,@Creator,@Create_Date)");
SqlParameter[] parameters = {
new SqlParameter("@Code", SqlDbType.Char,10),
new SqlParameter("@Items", SqlDbType.Char,200),
new SqlParameter("@Creator", SqlDbType.Char,10),
new SqlParameter("@Create_Date", SqlDbType.Char,8)};
parameters[0].Value = model.Code;
parameters[1].Value = model.Items;
parameters[2].Value = model.Creator;
parameters[3].Value = model.Create_Date;
if (SqlServerHelper.ExecuteSql(strSql.ToString(), parameters) >= 1)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一個案件資料
/// </summary>
/// <param name="model">案件類別</param>
/// <returns></returns>
public bool UpdateCase(RedGlovePermission.Model.Basic_Case model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Basic_Case set ");
strSql.Append("CaseDescription=@CaseDescription,");
strSql.Append("Department=@Department,");
strSql.Append("MA001=@MA001,");
strSql.Append("MODIFIER=@Modifier,");
strSql.Append("MODI_DATE=@Modi_Date");
strSql.Append(" where CaseNo=@CaseNo ");
SqlParameter[] parameters = {
new SqlParameter("@CaseNo", SqlDbType.Char,20),
new SqlParameter("@CaseDescription", SqlDbType.Char,50),
new SqlParameter("@Department", SqlDbType.Char,20),
new SqlParameter("@MA001", SqlDbType.Char,10),
new SqlParameter("@Modifier", SqlDbType.Char,10),
new SqlParameter("@Modi_Date", SqlDbType.Char,8)};
parameters[0].Value = model.CaseNo;
parameters[1].Value = model.CaseDescription;
parameters[2].Value = model.Department;
parameters[3].Value = model.MA001;
parameters[4].Value = model.Modifier;
parameters[5].Value = model.Modi_Date;
if (SqlServerHelper.ExecuteSql(strSql.ToString(), parameters) >= 1)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一個案件
/// </summary>
/// <param name="model">案件類別</param>
/// <returns></returns>
public bool CreateCase(RedGlovePermission.Model.Basic_Case model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Basic_Case(");
strSql.Append("CaseNo,CaseDescription,Department,MA001,CREATOR,CREATE_DATE)");
strSql.Append(" values (");
strSql.Append("@CaseNo,@CaseDescription,@Department,@MA001,@Creator,@Create_Date)");
SqlParameter[] parameters = {
new SqlParameter("@CaseNo", SqlDbType.Char,20),
new SqlParameter("@CaseDescription", SqlDbType.Char,50),
new SqlParameter("@Department", SqlDbType.Char,20),
new SqlParameter("@MA001", SqlDbType.Char,10),
new SqlParameter("@Creator", SqlDbType.Char,10),
new SqlParameter("@Create_Date", SqlDbType.Char,8)};
parameters[0].Value = model.CaseNo;
parameters[1].Value = model.CaseDescription;
parameters[2].Value = model.Department;
parameters[3].Value = model.MA001;
parameters[4].Value = model.Creator;
parameters[5].Value = model.Create_Date;
if (SqlServerHelper.ExecuteSql(strSql.ToString(), parameters) >= 1)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一个模块分类
/// </summary>
/// <param name="model">模块分类实体类</param>
/// <returns></returns>
public int CreateModuleType(RedGlovePermission.Model.RGP_ModuleType model)
{
int ret = 0;
if (!ModuleTypeExists(model.ModuleTypeName))
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into RGP_ModuleType(");
strSql.Append("ModuleTypeName,ModuleTypeOrder,ModuleTypeDescription)");
strSql.Append(" values (");
strSql.Append("?ModuleTypeName,?ModuleTypeOrder,?ModuleTypeDescription)");
MySqlParameter[] parameters = {
new MySqlParameter("?ModuleTypeName", MySqlDbType.VarChar,30),
new MySqlParameter("?ModuleTypeOrder", MySqlDbType.Int32,11),
new MySqlParameter("?ModuleTypeDescription", MySqlDbType.VarChar,50)};
parameters[0].Value = model.ModuleTypeName;
parameters[1].Value = model.ModuleTypeOrder;
parameters[2].Value = model.ModuleTypeDescription;
if (RedGlovePermission.DBUtility.MySqlHelper.ExecuteSql(strSql.ToString(), parameters) >= 1)
{
ret = 1;
}
}
else
{
ret = 2;
}
return ret;
}
/// <summary>
/// 更新指定的权限
/// </summary>
/// <param name="model">权限实体类</param>
/// <returns></returns>
public bool UpdateAuthority(RedGlovePermission.Model.RGP_AuthorityDir model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update RGP_AuthorityDir set ");
strSql.Append("AuthorityName=?AuthorityName,");
strSql.Append("AuthorityTag=?AuthorityTag,");
strSql.Append("AuthorityDescription=?AuthorityDescription,");
strSql.Append("AuthorityOrder=?AuthorityOrder");
strSql.Append(" where AuthorityID=?AuthorityID ");
MySqlParameter[] parameters = {
new MySqlParameter("?AuthorityID", MySqlDbType.Int32,11),
new MySqlParameter("?AuthorityName", MySqlDbType.VarChar,30),
new MySqlParameter("?AuthorityTag", MySqlDbType.VarChar,50),
new MySqlParameter("?AuthorityDescription", MySqlDbType.VarChar,50),
new MySqlParameter("?AuthorityOrder", MySqlDbType.Int32,11)};
parameters[0].Value = model.AuthorityID;
parameters[1].Value = model.AuthorityName;
parameters[2].Value = model.AuthorityTag;
parameters[3].Value = model.AuthorityDescription;
parameters[4].Value = model.AuthorityOrder;
if (RedGlovePermission.DBUtility.MySqlHelper.ExecuteSql(strSql.ToString(), parameters) >= 1)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model">模块分类实体类</param>
/// <returns></returns>
public bool UpdateModuleType(RedGlovePermission.Model.RGP_ModuleType model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update RGP_ModuleType set ");
strSql.Append("ModuleTypeName=?ModuleTypeName,");
strSql.Append("ModuleTypeOrder=?ModuleTypeOrder,");
strSql.Append("ModuleTypeDescription=?ModuleTypeDescription");
strSql.Append(" where ModuleTypeID=?ModuleTypeID");
MySqlParameter[] parameters = {
new MySqlParameter("?ModuleTypeID", MySqlDbType.Int32,11),
new MySqlParameter("?ModuleTypeName", MySqlDbType.VarChar,30),
new MySqlParameter("?ModuleTypeOrder", MySqlDbType.Int32,11),
new MySqlParameter("?ModuleTypeDescription", MySqlDbType.VarChar,50)};
parameters[0].Value = model.ModuleTypeID;
parameters[1].Value = model.ModuleTypeName;
parameters[2].Value = model.ModuleTypeOrder;
parameters[3].Value = model.ModuleTypeDescription;
if (RedGlovePermission.DBUtility.MySqlHelper.ExecuteSql(strSql.ToString(), parameters) >= 1)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新角色
/// </summary>
/// <param name="model">角色实体类</param>
/// <returns></returns>
public bool UpdateRole(RedGlovePermission.Model.RGP_Roles model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update RGP_Roles set ");
strSql.Append("RoleGroupID=@RoleGroupID,");
strSql.Append("RoleName=@RoleName,");
strSql.Append("RoleDescription=@RoleDescription");
strSql.Append(" where RoleID=@RoleID ");
SqlParameter[] parameters = {
new SqlParameter("@RoleID", SqlDbType.Int,4),
new SqlParameter("@RoleGroupID", SqlDbType.Int,4),
new SqlParameter("@RoleName", SqlDbType.NVarChar,30),
new SqlParameter("@RoleDescription", SqlDbType.NVarChar,50)};
parameters[0].Value = model.RoleID;
parameters[1].Value = model.RoleGroupID;
parameters[2].Value = model.RoleName;
parameters[3].Value = model.RoleDescription;
if (SqlServerHelper.ExecuteSql(strSql.ToString(), parameters) >= 1)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一家公司
/// </summary>
/// <param name="model">公司類別</param>
/// <returns></returns>
public bool CreateCompany(RedGlovePermission.Model.Basic_Companies model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Basic_Company(");
strSql.Append("Company,Track,Description,CREATOR,CREATE_DATE)");
strSql.Append(" values (");
strSql.Append("@Company,@Track,@Description,@Creator,@Create_Date)");
SqlParameter[] parameters = {
new SqlParameter("@Company", SqlDbType.Char,10),
new SqlParameter("@Track", SqlDbType.Char,2),
new SqlParameter("@Description", SqlDbType.Char,10),
new SqlParameter("@Creator", SqlDbType.Char,10),
new SqlParameter("@Create_Date", SqlDbType.Char,8)};
parameters[0].Value = model.Company;
parameters[1].Value = model.Track;
parameters[2].Value = model.Description;
parameters[3].Value = model.Creator;
parameters[4].Value = model.Create_Date;
if (SqlServerHelper.ExecuteSql(strSql.ToString(), parameters) >= 1)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一家公司資料
/// </summary>
/// <param name="model">公司類別</param>
/// <returns></returns>
public bool UpdateCompany(RedGlovePermission.Model.Basic_Companies model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Basic_Company set ");
strSql.Append("Track=@Track,");
strSql.Append("Description=@Description,");
strSql.Append("MODIFIER=@Modifier,");
strSql.Append("MODI_DATE=@Modi_Date");
strSql.Append(" where Company=@Company ");
SqlParameter[] parameters = {
new SqlParameter("@Company", SqlDbType.Char,10),
new SqlParameter("@Track", SqlDbType.Char,2),
new SqlParameter("@Description", SqlDbType.Char,10),
new SqlParameter("@Modifier", SqlDbType.Char,10),
new SqlParameter("@Modi_Date", SqlDbType.Char,8)};
parameters[0].Value = model.Company;
parameters[1].Value = model.Track;
parameters[2].Value = model.Description;
parameters[3].Value = model.Modifier;
parameters[4].Value = model.Modi_Date;
if (SqlServerHelper.ExecuteSql(strSql.ToString(), parameters) >= 1)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加角色
/// </summary>
/// <param name="model">角色实体类</param>
/// <returns></returns>
public int CreateRole(RedGlovePermission.Model.RGP_Roles model)
{
int ret = 0;
if (!RoleExists(model.RoleName, model.RoleGroupID))
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into RGP_Roles(");
strSql.Append("RoleGroupID,RoleName,RoleDescription)");
strSql.Append(" values (");
strSql.Append("@RoleGroupID,@RoleName,@RoleDescription)");
SqlParameter[] parameters = {
new SqlParameter("@RoleGroupID", SqlDbType.Int,4),
new SqlParameter("@RoleName", SqlDbType.NVarChar,30),
new SqlParameter("@RoleDescription", SqlDbType.NVarChar,50)};
parameters[0].Value = model.RoleGroupID;
parameters[1].Value = model.RoleName;
parameters[2].Value = model.RoleDescription;
if (SqlServerHelper.ExecuteSql(strSql.ToString(), parameters) >= 1)
{
ret = 1;
}
}
else
{
ret = 2;
}
return ret;
}
/// <summary>
/// 更新一個用戶
/// </summary>
/// <param name="model">用戶類別</param>
/// <returns></returns>
public bool UpdateUser(RedGlovePermission.Model.Users model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update RGP_Groups set ");
strSql.Append("Password=?Password,");
strSql.Append("RoleID=?RoleID,");
strSql.Append("UserGroup=?UserGroup");
strSql.Append("Status=?Status");
strSql.Append(" where UserID=?UserID ");
MySqlParameter[] parameters = {
new MySqlParameter("?UserID", MySqlDbType.Int32,11),
new MySqlParameter("?Password", MySqlDbType.VarChar,128),
new MySqlParameter("?RoleID", MySqlDbType.Int32,11),
new MySqlParameter("?UserGroup", MySqlDbType.Int32,11),
new MySqlParameter("?Status", MySqlDbType.Int32,11)};
parameters[0].Value = model.UserID;
parameters[1].Value = model.Password;
parameters[2].Value = model.RoleID;
parameters[3].Value = model.UserGroup;
parameters[4].Value = model.Status;
if (RedGlovePermission.DBUtility.MySqlHelper.ExecuteSql(strSql.ToString(), parameters) >= 1)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一筆產品資料
/// </summary>
/// <param name="model">產品類別</param>
/// <returns></returns>
public bool UpdateProduct(RedGlovePermission.Model.Products model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update INVMB set ");
strSql.Append("MB002=@ProductName,");
strSql.Append("MB003=@ProductSpec,");
strSql.Append("MB004=@StorageUnit,");
strSql.Append("MODIFIER=@Modifier,");
strSql.Append("MODI_DATE=@Modi_Date");
strSql.Append(" where MB001=@ProductID ");
SqlParameter[] parameters = {
new SqlParameter("@ProductID", SqlDbType.Char,20),
new SqlParameter("@ProductName", SqlDbType.Char,30),
new SqlParameter("@ProductSpec", SqlDbType.Char,30),
new SqlParameter("@StorageUnit", SqlDbType.Char,4),
new SqlParameter("@Modifier", SqlDbType.Char,10),
new SqlParameter("@Modi_Date", SqlDbType.Char,8)};
parameters[0].Value = model.ProductID;
parameters[1].Value = model.ProductName;
parameters[2].Value = model.ProductSpec;
parameters[3].Value = model.StorageUnit;
parameters[4].Value = model.Modifier;
parameters[5].Value = model.Modi_Date;
if (SqlServerHelper.ExecuteSql(strSql.ToString(), parameters) >= 1)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一個產品
/// </summary>
/// <param name="model">產品類別</param>
/// <returns></returns>
public bool CreateProduct(RedGlovePermission.Model.Products model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into INVMB(");
strSql.Append("MB001,MB002,MB003,MB004,CREATOR,CREATE_DATE)");
strSql.Append(" values (");
strSql.Append("@ProductID,@ProductName,@ProductSpec,@StorageUnit,@Creator,@Create_Date)");
SqlParameter[] parameters = {
new SqlParameter("@ProductID", SqlDbType.Char,20),
new SqlParameter("@ProductName", SqlDbType.Char,30),
new SqlParameter("@ProductSpec", SqlDbType.Char,30),
new SqlParameter("@StorageUnit", SqlDbType.Char,4),
new SqlParameter("@Creator", SqlDbType.Char,10),
new SqlParameter("@Create_Date", SqlDbType.Char,8)};
parameters[0].Value = model.ProductID;
parameters[1].Value = model.ProductName;
parameters[2].Value = model.ProductSpec;
parameters[3].Value = model.StorageUnit;
parameters[4].Value = model.Creator;
parameters[5].Value = model.Create_Date;
if (SqlServerHelper.ExecuteSql(strSql.ToString(), parameters) >= 1)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 创建一个新用户
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int CreateUser(RedGlovePermission.Model.Users model)
{
int ret = 0;
if (!UserExists(model.UserName))
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Users(");
strSql.Append("UserName,Password,Question,Answer,RoleID,UserGroup,CreateTime,IsLimit)");
strSql.Append(" values (");
strSql.Append("?UserName,?Password,?Question,?Answer,?RoleID,?UserGroup,?CreateTime,?IsLimit)");
strSql.Append(";select LAST_INSERT_ID()");
MySqlParameter[] parameters = {
new MySqlParameter("?UserName", MySqlDbType.VarChar,128),
new MySqlParameter("?Password", MySqlDbType.VarChar,128),
new MySqlParameter("?Question", MySqlDbType.VarChar,100),
new MySqlParameter("?Answer", MySqlDbType.VarChar,100),
new MySqlParameter("?RoleID", MySqlDbType.Int32,11),
new MySqlParameter("?UserGroup", MySqlDbType.Int32,11),
new MySqlParameter("?CreateTime", MySqlDbType.DateTime),
new MySqlParameter("?IsLimit", MySqlDbType.Bit,1)};
parameters[0].Value = model.UserName;
parameters[1].Value = model.Password;
parameters[2].Value = model.Question;
parameters[3].Value = model.Answer;
parameters[4].Value = model.RoleID;
parameters[5].Value = model.UserGroup;
parameters[6].Value = DateTime.Now;
parameters[7].Value = model.IsLimit;
object obj = RedGlovePermission.DBUtility.MySqlHelper.GetSingle(strSql.ToString(), parameters);
if (obj != null)
{
ret = 1;
}
}
else
{
ret = 2;
}
return ret;
}
/// <summary>
/// 创建一个新用户
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int CreateUser(RedGlovePermission.Model.Users model)
{
int ret = 0;
if (!UserExists(model.UserName))
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Users(");
strSql.Append("UserName,Password,Question,Answer,RoleID,UserGroup,CreateTime,IsLimit)");
strSql.Append(" values (");
strSql.Append("@UserName,@Password,@Question,@Answer,@RoleID,@UserGroup,@CreateTime,@IsLimit)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@UserName", SqlDbType.NVarChar,128),
new SqlParameter("@Password", SqlDbType.NVarChar,128),
new SqlParameter("@Question", SqlDbType.NVarChar,100),
new SqlParameter("@Answer", SqlDbType.NVarChar,100),
new SqlParameter("@RoleID", SqlDbType.Int,4),
new SqlParameter("@UserGroup", SqlDbType.Int,4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@IsLimit", SqlDbType.Bit,1)};
parameters[0].Value = model.UserName;
parameters[1].Value = model.Password;
parameters[2].Value = model.Question;
parameters[3].Value = model.Answer;
parameters[4].Value = model.RoleID;
parameters[5].Value = model.UserGroup;
parameters[6].Value = DateTime.Now;
parameters[7].Value = model.IsLimit;
object obj = SqlServerHelper.GetSingle(strSql.ToString(), parameters);
if (obj != null)
{
ret = 1;
}
}
else
{
ret = 2;
}
return ret;
}
/// <summary>
/// 增加一个分组
/// </summary>
/// <param name="model">分组实体类</param>
/// <returns></returns>
public bool CreateGroup(RedGlovePermission.Model.RGP_Groups model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into RGP_Groups(");
strSql.Append("GroupName,GroupOrder,GroupDescription)");
strSql.Append(" values (");
strSql.Append("@GroupName,@GroupOrder,@GroupDescription)");
SqlParameter[] parameters = {
new SqlParameter("@GroupName", SqlDbType.NVarChar,30),
new SqlParameter("@GroupOrder", SqlDbType.Int,4),
new SqlParameter("@GroupDescription", SqlDbType.NVarChar,50)};
parameters[0].Value = model.GroupName;
parameters[1].Value = model.GroupOrder;
parameters[2].Value = model.GroupDescription;
if (SqlServerHelper.ExecuteSql(strSql.ToString(), parameters) >= 1)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新指定的权限
/// </summary>
/// <param name="model">权限实体类</param>
/// <returns></returns>
public bool UpdateAuthority(RedGlovePermission.Model.RGP_AuthorityDir model)
{
return dal.UpdateAuthority(model);
}
/// <summary>
/// 增加一个模块
/// </summary>
/// <param name="model">模块实体类</param>
/// <returns></returns>
public int CreateModule(RedGlovePermission.Model.RGP_Modules model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into RGP_Modules(");
strSql.Append("ModuleTypeID,ModuleName,ModuleTag,ModuleURL,ModuleDisabled,ModuleOrder,ModuleDescription,IsMenu)");
strSql.Append(" values (");
strSql.Append("@ModuleTypeID,@ModuleName,@ModuleTag,@ModuleURL,@ModuleDisabled,@ModuleOrder,@ModuleDescription,@IsMenu)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@ModuleTypeID", SqlDbType.Int,4),
new SqlParameter("@ModuleName", SqlDbType.NVarChar,30),
new SqlParameter("@ModuleTag", SqlDbType.NVarChar,50),
new SqlParameter("@ModuleURL", SqlDbType.NVarChar,500),
new SqlParameter("@ModuleDisabled", SqlDbType.Bit,1),
new SqlParameter("@ModuleOrder", SqlDbType.Int,4),
new SqlParameter("@ModuleDescription", SqlDbType.NVarChar,50),
new SqlParameter("@IsMenu", SqlDbType.Bit,1)};
parameters[0].Value = model.ModuleTypeID;
parameters[1].Value = model.ModuleName;
parameters[2].Value = model.ModuleTag;
parameters[3].Value = model.ModuleURL;
parameters[4].Value = model.ModuleDisabled;
parameters[5].Value = model.ModuleOrder;
parameters[6].Value = model.ModuleDescription;
parameters[7].Value = model.IsMenu;
object obj = SqlServerHelper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 更新一個代碼
/// </summary>
/// <param name="model">代碼類別</param>
/// <returns></returns>
public bool UpdateCode(RedGlovePermission.Model.Basic_System model)
{
return dal.UpdateCode(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model">模块实体类</param>
/// <returns></returns>
public int UpdateModule(RedGlovePermission.Model.RGP_Modules model)
{
int ret = 0;
if (!UpdateExists(model.ModuleID, model.ModuleTag))
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update RGP_Modules set ");
strSql.Append("ModuleTypeID=?ModuleTypeID,");
strSql.Append("ModuleName=?ModuleName,");
strSql.Append("ModuleTag=?ModuleTag,");
strSql.Append("ModuleURL=?ModuleURL,");
strSql.Append("ModuleDisabled=?ModuleDisabled,");
strSql.Append("ModuleOrder=?ModuleOrder,");
strSql.Append("ModuleDescription=?ModuleDescription");
strSql.Append(" where ModuleID=?ModuleID ");
MySqlParameter[] parameters = {
new MySqlParameter("?ModuleID", MySqlDbType.Int32,11),
new MySqlParameter("?ModuleTypeID", MySqlDbType.Int32,11),
new MySqlParameter("?ModuleName", MySqlDbType.VarChar,30),
new MySqlParameter("?ModuleTag", MySqlDbType.VarChar,50),
new MySqlParameter("?ModuleURL", MySqlDbType.VarChar,500),
new MySqlParameter("?ModuleDisabled", MySqlDbType.Bit,1),
new MySqlParameter("?ModuleOrder", MySqlDbType.Int32,11),
new MySqlParameter("?ModuleDescription", MySqlDbType.VarChar,50)};
parameters[0].Value = model.ModuleID;
parameters[1].Value = model.ModuleTypeID;
parameters[2].Value = model.ModuleName;
parameters[3].Value = model.ModuleTag;
parameters[4].Value = model.ModuleURL;
parameters[5].Value = model.ModuleDisabled;
parameters[6].Value = model.ModuleOrder;
parameters[7].Value = model.ModuleDescription;
if (RedGlovePermission.DBUtility.MySqlHelper.ExecuteSql(strSql.ToString(), parameters) >= 1)
{
ret = 1;
}
}
else
{
ret = 2;
}
return ret;
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model">分组实体类</param>
/// <returns></returns>
public bool UpdateGroup(RedGlovePermission.Model.RGP_Groups model)
{
return dal.UpdateGroup(model);
}
/// <summary>
/// 增加一个模块
/// </summary>
/// <param name="model">模块实体类</param>
/// <returns></returns>
public int CreateModule(RedGlovePermission.Model.RGP_Modules model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into RGP_Modules(");
strSql.Append("ModuleTypeID,ModuleName,ModuleTag,ModuleURL,ModuleDisabled,ModuleOrder,ModuleDescription,IsMenu)");
strSql.Append(" values (");
strSql.Append("?ModuleTypeID,?ModuleName,?ModuleTag,?ModuleURL,?ModuleDisabled,?ModuleOrder,?ModuleDescription,?IsMenu)");
strSql.Append(";select LAST_INSERT_ID()");
MySqlParameter[] parameters = {
new MySqlParameter("?ModuleTypeID", MySqlDbType.Int32,11),
new MySqlParameter("?ModuleName", MySqlDbType.VarChar,30),
new MySqlParameter("?ModuleTag", MySqlDbType.VarChar,50),
new MySqlParameter("?ModuleURL", MySqlDbType.VarChar,500),
new MySqlParameter("?ModuleDisabled", MySqlDbType.Bit,1),
new MySqlParameter("?ModuleOrder", MySqlDbType.Int32,11),
new MySqlParameter("?ModuleDescription", MySqlDbType.VarChar,50),
new MySqlParameter("?IsMenu", MySqlDbType.Bit,1)};
parameters[0].Value = model.ModuleTypeID;
parameters[1].Value = model.ModuleName;
parameters[2].Value = model.ModuleTag;
parameters[3].Value = model.ModuleURL;
parameters[4].Value = model.ModuleDisabled;
parameters[5].Value = model.ModuleOrder;
parameters[6].Value = model.ModuleDescription;
parameters[7].Value = model.IsMenu;
object obj = RedGlovePermission.DBUtility.MySqlHelper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model">模块分类实体类</param>
/// <returns></returns>
public bool UpdateModuleType(RedGlovePermission.Model.RGP_ModuleType model)
{
return dal.UpdateModuleType(model);
}
/// <summary>
/// 增加一个模块分类
/// </summary>
/// <param name="model">模块分类实体类</param>
/// <returns></returns>
public int CreateModuleType(RedGlovePermission.Model.RGP_ModuleType model)
{
return dal.CreateModuleType(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model">模块实体类</param>
/// <returns></returns>
public int UpdateModule(RedGlovePermission.Model.RGP_Modules model)
{
return dal.UpdateModule(model);
}
/// <summary>
/// 更新一個客戶
/// </summary>
/// <param name="model">客戶類別</param>
/// <returns></returns>
public bool UpdateCustomer(RedGlovePermission.Model.Customers model)
{
return dal.UpdateCustomer(model);
}