//修改
public ActionResult UpdateUserType(int UserTypeID, string UserType, string Describe, Array XinZengshuzu, Array ShanChushuzu)
{
try
{
//声明字符串获取新增数组
string x = ((string[])XinZengshuzu)[0];
string[] intx = x.Split(',');
//声明字符串获取删除数组
string s = ((string[])ShanChushuzu)[0];
string[] ints = s.Split(',');
//声明权限表
B_Jurisdictio modelsJurisdiction = new B_Jurisdictio();
for (int i = 0; i < intx.Length; i++)
{
if (intx[i] != "")
{
modelsJurisdiction.UserTypeID = UserTypeID;
modelsJurisdiction.ModularDetailID = Convert.ToInt32(intx[i]);
myDYXTEntities.B_Jurisdictio.Add(modelsJurisdiction);
myDYXTEntities.SaveChanges();
}
}
for (int i = 0; i < ints.Length; i++)
{
if (ints[i] != "")
{
Delete(UserTypeID, Convert.ToInt32(ints[i]));
}
}
var db = (from tb in myDYXTEntities.S_UserTypeTable
where tb.UserTypeID == UserTypeID
select new
{
tb.ToVoidNo,
tb.FoundTime,
}).ToList();
S_UserTypeTable modelUserType = new S_UserTypeTable();
modelUserType.UserTypeID = UserTypeID;
modelUserType.UserTypeName = UserType.Trim();
modelUserType.Describe = Describe.Trim();
modelUserType.FoundTime = db[0].FoundTime;
modelUserType.ToVoidNo = db[0].ToVoidNo;
myDYXTEntities.Entry(modelUserType).State = EntityState.Modified;
myDYXTEntities.SaveChanges();
return(Json("success", JsonRequestBehavior.AllowGet));
}
catch
{
return(Json("failed", JsonRequestBehavior.AllowGet));
}
}
//新增
public ActionResult InsertUserType(string Name, string Describe, Array MoKuaiMingXiiiD)
{
try
{
//声明字符串接收模块明细信息数组的信息
string z = ((string[])MoKuaiMingXiiiD)[0];
//声明字符串数组接收模块明细信息数据
string[] ints = z.Split(',');
//实例化用户类型表 新增数据
S_UserTypeTable modelsUserType = new S_UserTypeTable();
modelsUserType.UserTypeName = Name.Trim();
modelsUserType.Describe = Describe.Trim();
modelsUserType.FoundTime = DateTime.Now.ToString();
modelsUserType.ToVoidNo = false;
//modelsUserType.typeClass = Session["UserTypeClass"].ToString().Trim();
myDYXTEntities.S_UserTypeTable.Add(modelsUserType);
myDYXTEntities.SaveChanges();
//获取新增的用户类型ID
var XinZengID = modelsUserType.UserTypeID;
//实例化权限表
B_Jurisdictio modelsJurisdiction = new B_Jurisdictio();
for (int d = 0; d < ints.Length; d++)
{
modelsJurisdiction.ModularDetailID = Convert.ToInt32(ints[d]);
modelsJurisdiction.UserTypeID = XinZengID;
myDYXTEntities.B_Jurisdictio.Add(modelsJurisdiction);
myDYXTEntities.SaveChanges();
}
return(Json("success", JsonRequestBehavior.AllowGet));
}
catch
{
return(Json("failed", JsonRequestBehavior.AllowGet));
}
}
//修改启用和作废的状态
public ActionResult ZuoFeiFou(int UserTypeID, bool DuanDuan)//DuanDuan记录操作按钮：true启用,false作废
{
string strMsg = "failed";
try
{
if (DuanDuan == false)
{
////作废
//判断用户角色明细信息是否存在：true用户角色明细信息为空，
if (ExistUserType(UserTypeID) == true)
{
//根据主键ID查询用户类型信息
var listdd = (from db in myDYXTEntities.S_UserTypeTable
where db.UserTypeID == UserTypeID
select new
{
db.UserTypeName, //用户类型
db.Describe,
db.FoundTime,
db.ToVoidNo
}).ToList();
//用户类型存在
if (listdd.Count > 0)
{
//修改用户类型
S_UserTypeTable modelUserType = new S_UserTypeTable();
modelUserType.UserTypeID = UserTypeID;
modelUserType.UserTypeName = listdd[0].UserTypeName;
modelUserType.Describe = listdd[0].Describe.Trim();
modelUserType.FoundTime = listdd[0].FoundTime;
modelUserType.ToVoidNo = DuanDuan;//作废否=false作废
myDYXTEntities.Entry(modelUserType).State = EntityState.Modified;
myDYXTEntities.SaveChanges();
strMsg = "success";
}
else
{
strMsg = "failed";
}
}
else
{
//提示用户该类型已存在
strMsg = "exist";
}
}
else
{ ////启用
//用户类型不存在
var listdd = (from db in myDYXTEntities.S_UserTypeTable
where db.UserTypeID == UserTypeID
select new
{
db.UserTypeName,
db.Describe,
db.FoundTime,
db.ToVoidNo
}).ToList();
if (listdd.Count > 0)
{
S_UserTypeTable modelUserType = new S_UserTypeTable();
modelUserType.UserTypeID = UserTypeID;
modelUserType.UserTypeName = listdd[0].UserTypeName;
modelUserType.Describe = listdd[0].Describe.Trim();
modelUserType.FoundTime = listdd[0].FoundTime;
modelUserType.ToVoidNo = DuanDuan;//作废否=true作废
myDYXTEntities.Entry(modelUserType).State = EntityState.Modified;
myDYXTEntities.SaveChanges();
strMsg = "success";
}
else
{
strMsg = "failed";
}
}
}
catch
{
strMsg = "failed";
}
return(Json(strMsg, JsonRequestBehavior.AllowGet));
}
