public string Added(FormCollection form)
{
var stateInfo = GeneralHandler.StateSuccess;
if (AddedByCheck(form, out stateInfo))
{
DawnAuthExtentMDL dataInfo = new DawnAuthExtentMDL();
dataInfo.ExteTime = DateTime.Now;
dataInfo.ExteStatus = 1;
dataInfo.ExteCode = form["txtCode"].Trim();
dataInfo.ExteCodeName = form["txtCodeName"].Trim();
dataInfo.ExteMark = form["txtMark"].Trim();
dataInfo.ExteMarkName = form["txtMarkName"].Trim();
dataInfo.ExteMemo = form["txtMemo"].Trim();
bool added = DawnAuthExtentBLL.Exists(string.Format("exte_code='{0}' and exte_mark='{1}'", dataInfo.ExteCode, dataInfo.ExteMark));
if (added)
{
stateInfo = GeneralHandler.StateAdded;
}
else
{
DawnAuthExtentBLL.Insert(dataInfo);
}
}
return(stateInfo);
}
public string Synced(FormCollection form)
{
var stateInfo = GeneralHandler.StateSuccess;
if (GetSyncDataByCheck(form, out stateInfo))
{
string txtSetCode = form["txtSetCode"] as string;
string txtSetName = form["txtSetName"] as string;
int sltSyncItem = TypeHelper.TypeToInt32(form["sltSyncItem"], 2);
string txtFieldTable = form["txtFieldTable"] as string;
string txtFieldMark = form["txtFieldMark"] as string;
string txtFieldName = form["txtFieldName"] as string;
string txtFieldMemo = form["txtFieldMemo"] as string;
string txtFieldWhere = form["txtFieldWhere"] as string;
string txtConnSource = form["txtConnSource"] as string;
string txtConnData = form["txtConnData"] as string;
string txtConnUser = form["txtConnUser"] as string;
string txtConnPwd = form["txtConnPwd"] as string;
System.Data.DataTable dt = Session["ExtentSyncData"] as System.Data.DataTable;//直接获取会话数据
try
{
if (dt.Rows.Count > 0)
{
if (sltSyncItem == 2)
{
DawnAuthExtentBLL.DeleteWhere(string.Format("exte_status=2 and exte_code='{0}'", txtSetCode));
}
System.Text.StringBuilder sb = new System.Text.StringBuilder();
//DawnAuthExtentMDL dataInfo;
DawnAuthExtentMDL dataInfo = new DawnAuthExtentMDL();
foreach (System.Data.DataRow dr in dt.Rows)
{
//dataInfo = new DawnAuthExtentMDL();
dataInfo.ExteTime = DateTime.Now;
dataInfo.ExteStatus = 2;
dataInfo.ExteCode = txtSetCode;
dataInfo.ExteCodeName = txtSetName;
dataInfo.ExteMark = dr[txtFieldMark].ToString();
dataInfo.ExteMarkName = dr[txtFieldName].ToString();
dataInfo.ExteMemo = txtFieldMemo == "null" ? "无" : dr[txtFieldMemo].ToString();
DawnAuthExtentBLL.Insert(dataInfo);
}
dataInfo = null;
}
else
{
stateInfo = "请先执行【获取数据】操作后，再执行【开始同步】操作。";
}
Session["ExtentSyncData"] = null;
}
catch (Exception ex)
{
Session["ExtentSyncData"] = null;
stateInfo = ex.Message;
GeneralHandler.InsertByError(ex);
}
}
return(stateInfo);
}
public string Delete(string id)
{
var stateInfo = GeneralHandler.StateSuccess;
if (!string.IsNullOrEmpty(id))
{
DawnAuthExtentBLL.Delete(int.Parse(id));
}
return(stateInfo);
}
/// <summary>
/// 管理员权限扩展
/// </summary>
/// <param name="id">管理员编号</param>
/// <param name="pager">页码</param>
/// <returns>执行结果</returns>
public ActionResult BindExtent(string id, string pager)
{
if (string.IsNullOrEmpty(id) || TypeHelper.TypeToInt32(id, -1) < 0)
{
return(RedirectToAction("List"));
}
ViewBag.UserId = id;
ViewBag.PageCurrent = pager;
return(View(DawnAuthExtentBLL.SelectByCodeList()));
}
/// <summary>
/// 权限扩展数据列表
/// </summary>
/// <param name="id">数据表单</param>
/// <returns>执行结果</returns>
public ActionResult Search(FormCollection form)
{
string strWhere = null;
var pgParam = "Nothing,Nothing";
//扩展编码
var txtCode = form["txtCode"] as string;
if (!string.IsNullOrEmpty(txtCode) && ValidHelper.EngIsEngAndNum(txtCode))
{
pgParam += string.Format(",txtCode,{0}", txtCode);
if (strWhere == null)
{
strWhere = string.Format("charindex('{0}',exte_code)>0", txtCode);
}
else
{
strWhere += string.Format(" and charindex('{0}',exte_code)>0", txtCode);
}
}
//扩展标识
var txtMark = form["txtMark"] as string;
if (!string.IsNullOrEmpty(txtMark) && ValidHelper.EngIsEngAndNum(txtMark))
{
pgParam += string.Format(",txtMark,{0}", txtMark);
if (strWhere == null)
{
strWhere = string.Format("charindex('{0}',exte_mark)>0", txtMark);
}
else
{
strWhere += string.Format(" and charindex('{0}',exte_mark)>0", txtMark);
}
}
var dataPager = new PagerHelperCHS();
dataPager.PageSize = GeneralHandler.PageSize;
if (form.Count > 1)
{
dataPager.PageCurrent = TypeHelper.TypeToInt32(form["pager"], 1);
}
else
{
dataPager.PageCurrent = TypeHelper.TypeToInt32(form["id"], 1);
}
int pageCount, recordCount;
var dataList = DawnAuthExtentBLL.SelectPSPisAllPurposeRowNumber(dataPager.PageSize, dataPager.PageCurrent, "exte_time desc,exte_code", strWhere, out pageCount, out recordCount);
dataPager.PageCount = pageCount;
dataPager.RecordCount = recordCount;
dataPager.PageRecordCount = dataList.Count;
ViewBag.Pager = dataPager;
ViewBag.PagerParam = pgParam;
return(View("List", dataList));
}
/// <summary>
/// 权限扩展数据列表
/// </summary>
/// <param name="id">页码</param>
/// <returns>执行结果</returns>
public ActionResult List(string id)
{
var pager = new PagerHelperCHS();
pager.PageSize = GeneralHandler.PageSize;
pager.PageCurrent = TypeHelper.TypeToInt32(id, 1);
int pageCount, recordCount;
var dataList = DawnAuthExtentBLL.SelectPSPisAllPurposeRowNumber(pager.PageSize, pager.PageCurrent, null, out pageCount, out recordCount);
pager.PageCount = pageCount;
pager.RecordCount = recordCount;
pager.PageRecordCount = dataList.Count;
ViewBag.Pager = pager;
ViewBag.PagerParam = null;
return(View(dataList));
}
public string GetExtentMark(FormCollection form)
{
string exteCode = form["exteCode"] as string;
int userId = TypeHelper.TypeToInt32(form["userId"], 0);
if (string.IsNullOrEmpty(exteCode) || userId < 1)
{
return(GeneralHandler.FNoneInfo);
}
var dataList = DawnAuthExtentBLL.ISelect(string.Format("exte_code='{0}'", exteCode));
if (dataList == null || dataList.Count < 1)
{
return(GeneralHandler.FNoneInfo);
}
var mapExtent = UserHandler.GetUserExtent(userId, exteCode);
int indexVal = 0;
StringBuilder sb = new StringBuilder();
foreach (var item in dataList)
{
indexVal++;
sb.Append("<li class=\"field-item bi\">");
sb.AppendFormat("<label class=\"fixed240\">{0}</label>", item.ExteMarkName);
var findFun = string.Format(",{0},", item.ExteMark);
if (mapExtent != null && mapExtent.Contains(findFun))
{
sb.AppendFormat("<input class=\"switch-on\" type=\"button\" id=\"btn{0}\" onclick=\"dataUnSave({0},{1},'{2}','{3}');\" />", indexVal, userId, exteCode, item.ExteMark);
}
else
{
sb.AppendFormat("<input class=\"switch-off\" type=\"button\" id=\"btn{0}\" onclick=\"dataSave({0},{1},'{2}','{3}');\" />", indexVal, userId, exteCode, item.ExteMark);
}
sb.AppendFormat("<span class=\"margin-left-10\">{0}</span>", item.ExteMemo);
sb.Append("</li>");
}
return(sb.ToString());
}
/// <summary>
/// 获得权限扩展编码数据列表
/// </summary>
/// <returns>数据集合</returns>
public static IList <SelectListItem> GetSelectList()
{
var list = new List <SelectListItem>()
{
new SelectListItem()
{
Value = "-1",
Text = "--请选择--"
}
};
var dataList = DawnAuthExtentBLL.SelectByCodeList();
if (dataList.Rows.Count > 0)
{
foreach (DataRow dr in dataList.Rows)
{
SelectListItem sli = new SelectListItem();
sli.Text = dr["exte_code_name"].ToString();
sli.Value = dr["exte_code"].ToString();
list.Add(sli);
}
}
return(list);
}
