/// <summary> ///添加表 /// </summary> /// <returns></returns> public string AddTabName(string tableName, int UserId) { model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext(); try { string check = @"select count(*) from syscolumns where id=object_id('" + tableName + "')"; if (DbHelperSQL.Query(check).Tables[0].Rows[0][0].ToString() == "0") { return("该表不存在!"); } else { var p = (from c in context.tableFiledPerssion where c.tableName == tableName select c.tableName).FirstOrDefault(); if (p == null) { model.tableFiledPerssion tt = new model.tableFiledPerssion() { tableName = tableName, tableLevel = 0, tableNameState = 1, tableFiledState = 1, }; context.tableFiledPerssion.InsertOnSubmit(tt); context.SubmitChanges(); string sql = @"insert into tableFiledPerssion(tableName,tableLevel) select name,(select id from tableFiledPerssion where tableName='" + tableName + "') from sys.syscolumns where id =object_id('" + tableName + "')"; DbHelperSQL.ExecuteSql(sql); errordal.InsertErrorlog(new model.errorlog() { errorSrc = "pbxdata.dal->tablefiledPerssiondal->AddTabName()", ErrorMsg = "添加", errorTime = DateTime.Now, operation = 2, errorMsgDetails = "添加表->" + tableName, UserId = UserId, }); } else { return("该表已存在!"); } return(""); } } catch (Exception ex) { errordal.InsertErrorlog(new model.errorlog() { errorSrc = "pbxdata.dal->tablefiledPerssiondal->AddTabName()", ErrorMsg = "添加", errorTime = DateTime.Now, operation = 1, errorMsgDetails = "添加表失败->" + tableName + "->" + ex.Message, UserId = UserId, }); return("添加失败!"); } }
public void getUserFiled(List <int> listMenuIdC, List <int> listFunId) { string s = string.Empty; foreach (int item in listMenuIdC) { s += item + ","; } s = s.Length > 0 ? s.Remove(s.Length - 1, 1) : s; string s1 = string.Empty; foreach (int item in listFunId) { s1 += item + ","; } s1 = s1.Length > 0 ? s1.Remove(s1.Length - 1, 1) : s1; IDataParameter[] iparaFiled = new IDataParameter[] { new SqlParameter("roleId", SqlDbType.Int, 4), new SqlParameter("menuId", SqlDbType.NVarChar, 5000), new SqlParameter("funId", SqlDbType.NVarChar, 5000), }; iparaFiled[0].Value = us.User.personaId; iparaFiled[1].Value = s; iparaFiled[2].Value = s1; List <int> listFiledId = new List <int>(); model.tableFiledPerssion filedMd = new model.tableFiledPerssion(); bll.tableFiledPerssionbll filedBll = new bll.tableFiledPerssionbll(); List <model.tableFiledPerssion> listFiled = filedBll.getTable(iparaFiled, "tableFiledSelect"); foreach (var item in listFiled) { listFiledId.Add(item.Id); } if (listFiled.Count == 0) { listFiledId.Add(9999); } us.FiledId = listFiledId; }
/// <summary> ///添加列 /// </summary> /// <returns></returns> public string AddFiledName(string tableName, string tableLevel, int UserId) { model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext(); try { int tableLevels = Convert.ToInt32(tableLevel); var p = (from c in context.tableFiledPerssion where c.tableName == tableName && c.tableLevel == tableLevels select c.tableName).FirstOrDefault(); if (p == null) { model.tableFiledPerssion tt = new model.tableFiledPerssion() { tableName = tableName, tableLevel = tableLevels, tableNameState = 1, tableFiledState = 1, }; context.tableFiledPerssion.InsertOnSubmit(tt); context.SubmitChanges(); errordal.InsertErrorlog(new model.errorlog() { errorSrc = "pbxdata.dal->tablefiledPerssiondal->AddFiledName()", ErrorMsg = "添加", errorTime = DateTime.Now, operation = 2, errorMsgDetails = "添加列->" + tableName, UserId = UserId, }); return(""); } else { return("该列已存在!"); } } catch (Exception ex) { return("添加失败!"); } }
/// <summary> /// 得到一个对象实体 /// </summary> public List <model.tableFiledPerssion> DataRowToModel(DataRowCollection rowCollection) { List <model.tableFiledPerssion> list = new List <model.tableFiledPerssion>(); foreach (DataRow row in rowCollection) { model.tableFiledPerssion modelMd = new model.tableFiledPerssion(); if (row != null) { if (row["Id"] != null && row["Id"].ToString() != "") { modelMd.Id = int.Parse(row["Id"].ToString()); } if (row["tableName"] != null) { modelMd.tableName = row["tableName"].ToString(); } if (row["tableFiled"] != null) { modelMd.tableFiled = row["tableFiled"].ToString(); } if (row["tableLevel"] != null && row["tableLevel"].ToString() != "") { modelMd.tableLevel = int.Parse(row["tableLevel"].ToString()); } if (row["tableNameState"] != null && row["tableNameState"].ToString() != "") { modelMd.tableNameState = int.Parse(row["tableNameState"].ToString()); } if (row["tableFiledState"] != null && row["tableFiledState"].ToString() != "") { modelMd.tableFiledState = int.Parse(row["tableFiledState"].ToString()); } if (row["tableIndex"] != null && row["tableIndex"].ToString() != "") { modelMd.tableIndex = int.Parse(row["tableIndex"].ToString()); } if (row["UserId"] != null && row["UserId"].ToString() != "") { modelMd.UserId = int.Parse(row["UserId"].ToString()); } if (row["Def1"] != null) { modelMd.Def1 = row["Def1"].ToString(); } if (row["Def2"] != null) { modelMd.Def2 = row["Def2"].ToString(); } if (row["Def3"] != null) { modelMd.Def3 = row["Def3"].ToString(); } if (row["Def4"] != null) { modelMd.Def4 = row["Def4"].ToString(); } if (row["Def5"] != null) { modelMd.Def5 = row["Def5"].ToString(); } } list.Add(modelMd); } return(list); }