public JsonResult DelInform() { try { string delinformids = Request.Form["delinformids"].ToString(); if (delinformids.Contains("_")) { string[] aInformids = delinformids.Split('_'); foreach (var informid in aInformids) { int Informid = Convert.ToInt32(informid); Inform inform = new BaseDAL <Inform>().GetModel(u => u.InformId == Informid); new BaseDAL <Inform>().Del(inform); } } else { int Informid = Convert.ToInt32(delinformids); Inform inform = new BaseDAL <Inform>().GetModel(u => u.InformId == Informid); new BaseDAL <Inform>().Del(inform); } dictionary.Add("success", true); } catch { dictionary.Add("success", false); } return(Json(dictionary)); }
public string GetExcel() { string filename = ""; HSSFWorkbook workbook = new HSSFWorkbook(); //创建一个工作薄 ISheet sheet1 = workbook.CreateSheet(); //创建一个sheet页 IRow rowHeader = sheet1.CreateRow(0); //创建第一行 rowHeader.CreateCell(0, CellType.STRING).SetCellValue("通知信息"); //创建第一行第一列的单元格,设定里面的值为ID rowHeader.CreateCell(1, CellType.STRING).SetCellValue("是否显示"); rowHeader.CreateCell(2, CellType.STRING).SetCellValue("信息类型"); List <Inform> list = new BaseDAL <Inform>().GetListBy(u => u.InformId > 0); int i = 0; if (list.Count > 0) { foreach (var Inform in list) { IRow rowDate = sheet1.CreateRow(i + 1); rowDate.CreateCell(0, CellType.STRING).SetCellValue(Inform.InformText.ToString()); rowDate.CreateCell(1, CellType.STRING).SetCellValue(Inform.IsVisible.ToString()); rowDate.CreateCell(2, CellType.STRING).SetCellValue(Inform.InfoType.ToString()); i++; } filename = "/file/" + Guid.NewGuid().ToString() + ".xls"; using (Stream stream = System.IO.File.OpenWrite(Server.MapPath(filename))) { workbook.Write(stream); } } return(filename); }
public JsonResult UpdateOrder(int id) { string BookName = Request.Form["BookName"].ToString(); string UserName = Request.Form["UserName"].ToString(); int BookAmount = int.Parse(Request.Form["BookAmount"].ToString()); double BookPrice = double.Parse(Request.Form["BookPrice"].ToString()); string OrderNumber = Request.Form["OrderNumber"].ToString(); BookOrder bookOrder = new BaseDAL <BookOrder>().GetModel(u => u.BookOrderId == id); bookOrder.BookName = BookName; bookOrder.UserName = UserName; bookOrder.BookAmount = BookAmount; bookOrder.BookPrice = BookPrice; bookOrder.BookTotalPrice = BookAmount * BookPrice; bookOrder.OrderNumber = OrderNumber; if (new BaseDAL <BookOrder>().Modify(bookOrder) > 0) { dictionary.Add("success", true); } else { dictionary.Add("success", false); dictionary.Add("infor", "更新失败"); } return(Json(dictionary)); }
public JsonResult DelOrder() { try { string sBookOrderids = Request.Form["delbookorderids"].ToString(); if (sBookOrderids.Contains("_")) { string[] aBookOrderids = sBookOrderids.Split('_'); foreach (var BookOrderid in aBookOrderids) { int bookOrderid = Convert.ToInt32(BookOrderid); BookOrder bookOrder = new BaseDAL <BookOrder>().GetModel(u => u.BookOrderId == bookOrderid); new BaseDAL <BookOrder>().Del(bookOrder); } } else { int bookOrderid = Convert.ToInt32(sBookOrderids); BookOrder bookOrder = new BaseDAL <BookOrder>().GetModel(u => u.BookOrderId == bookOrderid); new BaseDAL <BookOrder>().Del(bookOrder); } dictionary.Add("success", true); } catch { dictionary.Add("success", false); } return(Json(dictionary)); }
static void Main(string[] args) { try { Console.WriteLine("欢迎来到.net高级班vip课程,今天的内容是特性和AOP"); People people = new People(); UserModel user = new UserModel(); user.Id = 1; string name = user.GetTableName <UserModel>(); string remark = UserState.Normal.GetRemark(); BaseDAL.Save <UserModel>(user); #region AOP show Console.WriteLine("***********************"); Decorator.Show(); Console.WriteLine("***********************"); Proxy.Show(); Console.WriteLine("***********************"); CastleProxy.Show(); Console.WriteLine("***********************"); UnityAOP.Show(); #endregion } catch (Exception ex) { Console.WriteLine(ex.Message); } Console.Read(); }
protected void BindingDropDownList() { BaseDAL <KHUVUC> abc = new BaseDAL <KHUVUC>(); var listMaKV = abc.GetAll().Select(c => c.MAKV).ToList(); cbbMAKV.DataSource = listMaKV; }
public JsonResult DelWebComment() { try { string sWebCommentids = Request.Form["delwebcommentids"].ToString(); if (sWebCommentids.Contains("_")) { string[] aWebCommentids = sWebCommentids.Split('_'); foreach (var WebCommenid in aWebCommentids) { int WebCommentid = Convert.ToInt32(WebCommenid); WebComment webComment = new BaseDAL <WebComment>().GetModel(u => u.WebCommentId == WebCommentid); new BaseDAL <WebComment>().Del(webComment); } } else { int WebCommentid = Convert.ToInt32(sWebCommentids); WebComment webComment = new BaseDAL <WebComment>().GetModel(u => u.WebCommentId == WebCommentid); new BaseDAL <WebComment>().Del(webComment); } dictionary.Add("success", true); } catch { dictionary.Add("success", false); } return(Json(dictionary)); }
static void Main(string[] args) { try { Console.WriteLine("这是第一个学习项目"); BaseDAL baseDAL = new BaseDAL(); Company company1 = baseDAL.Find <Company>(1); /// List<Company> list = baseDAL.FindAll<Company>(); User user = baseDAL.Find <User>(1); //List<User> list = baseDAL.FindAll<User>(); //company.Name = "腾讯课堂234564576754"; ////company.Validate(); //baseDAL.Update<Company>(company); // } catch (Exception ex)//UI层必须把异常catch住 { Console.WriteLine(ex.Message); } Console.Read(); }
static void Main(string[] args) { IBaseDAL basedal = new BaseDAL(); //查询一条 User user = basedal.Find <User>(1); //查询所有 List <User> listuser = basedal.FindAll <User>(); user.Name = "喻贞"; //更新一条数据 //bool update = basedal.update<User>(user); //插入一条数据 //bool insert = basedal.insert<User>(user); //删除一条数据 bool delete = basedal.delete <User>(2); //List<a> l= new List<a>(); //for (int i = 0; i < 10; i++) //{ // a a = new a() { id = i+1 }; // l.Add(a); //} //var result = l.Select(x => x.id < 3 ? 0 : x.id).Where(x=>x!=0); }
public string BuscarQuestoes(string idQuestao) { int idQuestaoInt = int.Parse(idQuestao); string resultado = BaseDAL.DataTable_JSON_JavaSerializer(BaseDAL.BuscarQuestoesDAL(idQuestaoInt)); return(resultado); }
//Get Graph Chart public JsonResult GetGraph() { DateTime startTime = Convert.ToDateTime(Request.Form["startTime"].ToString()); DateTime endTime = Convert.ToDateTime(Request.Form["endTime"].ToString()); List <User> list = new BaseDAL <User>().GetListBy(u => u.CreatedTime >= startTime && u.CreatedTime <= endTime && u.Type == 0); var listGraph = (from u in list group u by u.CreatedTime.Value.Year.ToString() + u.CreatedTime.Value.Month.ToString() into g orderby Convert.ToInt32(g.Key.Substring(0, 4)), Convert.ToInt32(g.Key.Substring(4, g.Key.Length - 4)) select new { key = g.Key, count = g.Count() }).ToList(); Dictionary <string, object> dt = new Dictionary <string, object>(); // JavaScriptSerializer jss = new JavaScriptSerializer(); List <string> aTime = new List <string>(); List <int> aCountGraph = new List <int>(); foreach (var a in listGraph) { aTime.Add(a.key); aCountGraph.Add(a.count); } dt.Add("a1", aTime); dt.Add("a2", aCountGraph); //return jss.Serialize(dt); return(Json(dt)); }
public static void refreshDatagrid(DataGridView dv) { dv.Rows.Clear(); //绑定数据 // this.dataGridView1.Rows.Clear(); IList <SendMessage> receiveList = BaseDAL.QueryForList <SendMessage>("QueryAllReceiceMsgList", LoginUser.ID); if (receiveList != null && receiveList.Count() > 0) { foreach (SendMessage msg in receiveList) { var msgStatus = string.Empty; if (msg.Status == 1) { msgStatus = "未读"; } else if (msg.Status == 2) { msgStatus = "已读"; } string[] rowItem = new string[] { msgStatus, msg.SenderName, msg.SendeUid, (msg.SentTime != null && msg.SentTime != DateTime.MinValue)?msg.SentTime.ToString("yyyy-MM-dd HH:mm:ss"):"", msg.ID.ToString() }; dv.Rows.Add(rowItem); } } }
public void consignBtn_Click(object sender, EventArgs e) { item.status = 100; item.completeDate = DateTime.Now; item.itemDetials = itemDetialsIn.InnerText; if (itemDal.Update(item) == 1) { if (item.money != 0 & item.money != null) { BaseDAL<OA_finance> financeDal = new BaseDAL<OA_finance>(); OA_finance finance = new OA_finance(); finance.money = item.money; finance.actionDate = DateTime.Now; finance.actionDetails = "委托方:" + item.client + ",项目负责人:" + item.leaderName; ; finance.actionName = item.itemName; financeDal.Add(finance); } moneyInput.Value = item.money.ToString(); yearIn.Value = item.completeDate.Year.ToString(); monthIn.Value = item.completeDate.Month.ToString(); dayIn.Value = item.completeDate.Day.ToString(); itemDetialsIn.Value = item.itemDetials; programProgress.InnerText = item.status + "%"; itemProgress.Style.Add("width", 5.36 * item.status + "px"); List<OA_item> itemList = itemDal.GetList(1, 2000); if (Header1.DataBind(itemList, user.realName, user.loginName) == 0) { user.status = 100; userDal.Update(user); } scripthelp.Alert("项目交付成功!", this.Page); } else scripthelp.Alert("项目交付失败!", Page); }
//Update User to DB public JsonResult UpdateUser(int id) { string UserName = Request.Form["UserName"].ToString(); string Pwd = Request.Form["Pwd"].ToString(); string Gender = Request.Form["Gender"].ToString(); string Email = Request.Form["Email"].ToString(); string Tel = Request.Form["Tel"].ToString(); string QQ = Request.Form["QQ"].ToString(); User user = new BaseDAL <User>().GetModel(u => u.UserId == id); user.UserName = UserName; user.Pwd = Pwd; user.Gender = Gender; user.Email = Email; user.Tel = Tel; user.QQ = QQ; if (new BaseDAL <User>().Modify(user) > 0) { dictionary.Add("success", true); } else { dictionary.Add("success", false); dictionary.Add("infor", "更新失败"); } return(Json(dictionary)); }
/// <summary> /// 重写获取分页数据方法 /// </summary> /// <param name="totalCount">总记录数</param> /// <param name="errorMsg">异常信息</param> /// <param name="permissionValidate">是否过滤权限</param> /// <param name="pageIndex">页号</param> /// <param name="pageSize">每页记录数</param> /// <param name="orderFields">排序字段</param> /// <param name="isDescs">是否降序</param> /// <param name="expression">条件表达式</param> /// <param name="whereSql">where语句</param> /// <param name="references">是否加载导航属性</param> /// <param name="connString">数据库连接字符串</param> /// <returns></returns> public override List <Sys_DbConfig> GetPageEntities(out long totalCount, out string errorMsg, bool permissionValidate = true, int pageIndex = 1, int pageSize = 10, List <string> orderFields = null, List <bool> isDescs = null, System.Linq.Expressions.Expression <Func <Sys_DbConfig, bool> > expression = null, string whereSql = null, List <string> fieldNames = null, bool references = false, string connString = null) { totalCount = 0; BaseDAL <Sys_Module> moduleDal = new BaseDAL <Sys_Module>(this.CurrUser); int dataSourceType = (int)ModuleDataSourceType.DbTable; List <Sys_Module> modules = expression == null?moduleDal.GetPageEntities(out totalCount, out errorMsg, false, pageIndex, pageSize, null, null, x => x.DataSourceType == dataSourceType) : moduleDal.GetEntities(out errorMsg, x => x.DataSourceType == dataSourceType, null, false); List <Sys_DbConfig> list = modules.Select(x => GetModuleCacheConfig(x.TableName, x.Name, x.Id)).ToList(); list = list.Where(x => x != null).ToList(); //将未添加到模块表中的模块也加进来 List <Type> modelTypes = GetAllModelTypes(); if (modelTypes == null || modelTypes.Count == 0) { return(new List <Sys_DbConfig>()); } List <string> tables = moduleDal.GetEntities(out errorMsg, x => x.TableName != null && x.TableName != string.Empty).Select(x => x.TableName).ToList(); list.AddRange(modelTypes.Where(x => !tables.Contains(x.Name)).Select(x => GetModuleCacheConfig(x.Name))); if (expression != null) { list = list.Where(expression.Compile()).ToList(); totalCount = list.Count; } //页序号 int index = pageIndex < 1 ? 0 : (pageIndex - 1); //每页记录数 int rows = pageSize < 1 ? 10 : (pageSize > 2000 ? 2000 : pageSize); list = list.Skip <Sys_DbConfig>(rows * index).Take <Sys_DbConfig>(rows).OrderByDescending(x => x.CurrPageDensity).ToList(); return(list); }
/// <summary> /// 获取实体集合重写 /// </summary> /// <param name="errorMsg"></param> /// <param name="expression"></param> /// <param name="whereSql"></param> /// <param name="permissionFilter"></param> /// <param name="orderFields"></param> /// <param name="isDescs"></param> /// <param name="top"></param> /// <param name="references"></param> /// <param name="connString"></param> /// <returns></returns> public override List <Sys_CacheConfig> GetEntities(out string errorMsg, System.Linq.Expressions.Expression <Func <Sys_CacheConfig, bool> > expression = null, string whereSql = null, bool permissionFilter = true, List <string> orderFields = null, List <bool> isDescs = null, int?top = null, List <string> fieldNames = null, bool references = false, string connString = null) { BaseDAL <Sys_Module> moduleDal = new BaseDAL <Sys_Module>(this.CurrUser); int dataSourceType = (int)ModuleDataSourceType.DbTable; List <Sys_Module> modules = moduleDal.GetEntities(out errorMsg, x => x.DataSourceType == dataSourceType, null, permissionFilter); List <Sys_CacheConfig> list = modules.Select(x => GetModuleCacheConfig(x.TableName, x.Name, x.Id)).ToList(); //将未添加到模块表中的模块也加进来 List <Type> modelTypes = GetAllModelTypes(); List <string> tables = moduleDal.GetEntities(out errorMsg, x => x.TableName != null && x.TableName != string.Empty).Select(x => x.TableName).ToList(); list.AddRange(modelTypes.Where(x => !tables.Contains(x.Name)).Select(x => GetModuleCacheConfig(x.Name))); if (expression != null) { list = list.Where(expression.Compile()).ToList(); if (orderFields != null && orderFields.Count > 0) { for (int i = 0; i < orderFields.Count; i++) { string orderField = string.IsNullOrEmpty(orderFields[i]) ? "Id" : orderFields[i]; bool isdesc = isDescs != null && orderFields.Count == isDescs.Count ? isDescs[i] : true; SortComparer <Sys_CacheConfig> reverser = new SortComparer <Sys_CacheConfig>(typeof(Sys_CacheConfig), orderField, isdesc ? ReverserInfo.Direction.DESC : ReverserInfo.Direction.ASC); list.Sort(reverser); } } } return(list); }
private MySqlDataReader CallEmpDetail_USP(string empDataJson, OperationType operationType) { MySqlDataReader dr = null; var errorOutput = ""; try { MySqlParameter empDetailParam = new MySqlParameter("@empData", empDataJson); empDetailParam.Direction = ParameterDirection.Input; MySqlParameter operationTypeParam = new MySqlParameter("@operationType", operationType); operationTypeParam.Direction = ParameterDirection.Input; MySqlParameter outputParam = new MySqlParameter("@_errorOutput", errorOutput); outputParam.Direction = ParameterDirection.Output; MySqlCommand cmd = BaseDAL.GetSqlCommandProcedure(Get_All_Emp_Data_USP); cmd.Parameters.Add(empDetailParam); cmd.Parameters.Add(operationTypeParam); cmd.Parameters.Add(outputParam); dr = cmd.ExecuteReader(); } catch (MySqlException execption) { throw new Exception("Internal Error occurred: " + execption.Message); } return(dr); }
public JsonResult UpdateWebComment(int id) { int UserId = Convert.ToInt32(Request.Form["UserId"].ToString()); string CommentTitle = Request.Form["CommentTitle"].ToString(); string CommentText = Server.HtmlEncode(Request.Form["CommentText"].ToString()); DateTime CreatedTime = DateTime.Parse(Request.Form["CreatedTime"].ToString()); string ClientIP = Request.Form["ClientIP"].ToString(); WebComment webComment = new BaseDAL <WebComment>().GetModel(u => u.WebCommentId == id); webComment.UserId = UserId; webComment.CommentTitle = CommentTitle; webComment.CommentText = Server.HtmlDecode(CommentText); webComment.CreatedTime = CreatedTime; webComment.ClientIP = ClientIP; if (new BaseDAL <WebComment>().Modify(webComment) > 0) { dictionary.Add("success", true); } else { dictionary.Add("success", false); dictionary.Add("infor", "更新失败"); } return(Json(dictionary)); }
public void Do() { NatServerCrowd natServerCrowd = new NatServerCrowd(); natServerCrowd.Start(); int count = natServerCrowd.GetCount(); var list = natServerCrowd.GetAddressList(); Console.WriteLine("NatServer IP列表:"); list.ForEach(item => { //存到数据库 NatProxyModel natProxyModel = new NatProxyModel { Type = (int)NatProxyTypeEnum.Nat, AddressInnerNet = item.Address, Port = item.Port, IsUsable = true, StartUpTime = DateTime.Now, AddressOuterNet = IPAddressUtils.GetOuterNatIP() }; var id = BaseDAL.Insert(natProxyModel); natServerCrowd.AddIdItem(id); Console.WriteLine("启动成功!PrimaryId:{0},AddressInnerNetAndPort:{1}:{2}", id, natProxyModel.AddressInnerNet, natProxyModel.Port); }); ConsoleCloseHandler.natServerCrowd = natServerCrowd; ConsoleCloseHandler.SetConsoleCtrlHandler(ConsoleCloseHandler.cancelHandler, true); }
/// <summary> /// 获取用户可(查看、编辑、删除)模块中哪些组织下的数据, /// 返回可(查看、编辑、删除)的组织Id集合 /// </summary> /// <param name="userId">用户Id</param> /// <param name="moduleId">模块Id</param> /// <param name="dataPermissionType">数据权限类型,0-查看,1-编辑,2-删除</param> /// <returns>返回组织Id集合字典</returns> public List <string> GetUserDataPermissions(Guid userId, Guid moduleId, int dataPermissionType) { List <string> orgIds = new List <string>(); //如果存在用户自定义权限则取自定义用户权限 string errMsg = string.Empty; BaseDAL <Sys_UserPermissionData> userPermissionDal = new BaseDAL <Sys_UserPermissionData>(this.CurrUser); Sys_UserPermissionData permissionData = userPermissionDal.GetEntity(out errMsg, x => x.Sys_UserId == userId && x.Sys_ModuleId == moduleId && !x.IsDeleted); string orgIdsStr = string.Empty; if (permissionData != null) { orgIdsStr = dataPermissionType == 0 ? permissionData.CanViewOrgIds : (dataPermissionType == 1 ? permissionData.CanEditOrgIds : permissionData.CanDelOrgIds); } if (!string.IsNullOrWhiteSpace(orgIdsStr)) { string[] token = orgIdsStr.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); if (token.Contains("-1")) { return new List <string>() { "-1" } } ; foreach (string orgId in token) { if (!orgIds.Contains(orgId)) { orgIds.Add(orgId); } } return(orgIds); } //取用户角色权限 List <Guid> roleIds = ObjectReferenceClass.GetUserRoleIds(userId); foreach (Guid roleId in roleIds) { Dictionary <string, bool> tempOrgIds = GetRoleDataPermissions(roleId, moduleId, dataPermissionType, true); if (tempOrgIds.ContainsKey("-1")) { return new List <string>() { "-1" } } ; foreach (string orgId in tempOrgIds.Keys) { if (!orgIds.Contains(orgId)) { orgIds.Add(orgId); } } } return(orgIds); } } }
public ActionResult EditPwPost(string oldPw, string newPw) { var adminUserDal = new BaseDAL <AdminUser>(); var user = adminUserDal.GetModel("Id=1"); if (user == null) { return(Json(new ReMsg() { Success = false, Info = "用户不存在" })); } if (user.Pw != oldPw) { return(Json(new ReMsg() { Success = false, Info = "密码不正确" })); } user.Pw = newPw; adminUserDal.Update(user); return(Json(true)); }
/// <summary> /// 检查邮箱准确性 /// </summary> /// <param name="inputEmailTxt"></param> /// <param name="tips"></param> /// <returns></returns> public bool checkEmail(string inputEmailText, out string tips) { inputEmailText = inputEmailText.Trim(); bool checkResult = false; Regex reg = new Regex(@"^[a-zA-Z0-9_-]+@[a-zA-Z0-9_-]+(\.[a-zA-Z0-9_-]+)+$"); if (reg.IsMatch(inputEmailText)) { if (BaseDAL.Get("GetEmailCount", inputEmailText) == 0) { checkResult = true; tips = String.Format($"\"{inputEmailText}\"可用。"); // XtraMessageBox.Show(String.Format($"\"{inputEmailText}\"可用。"), "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { tips = String.Format($"\"{inputEmailText}\"已存在。"); // XtraMessageBox.Show(String.Format($"\"{inputEmailText}\"已存在。"), "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { tips = String.Format($"请检查邮箱格式"); // XtraMessageBox.Show("请检查邮箱格式", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(checkResult); }
static void Main(string[] args) { B1DAL dal = new B1DAL(); b1 b = new b1(); b.b = 10; var m = dal.Add(b); var model = dal.GetModel("id", 1); List <Filter> fl = new List <Filter>(); fl.AddFilter("id", FilterOption.LessThan, 3); var list = dal.GetPageList(fl, 1, 15, "id"); BaseDAL <a1> dala = new BaseDAL <a1>(); dala.DbConnect = new DbEnum().GetDbConnectionName(dbE.T.testEntities); List <Filter> afl1 = new List <Filter>(); afl1.AddFilter("name", FilterOption.Contains, "3"); List <Filter> afl = new List <Filter>(); afl.AddFilter("name", FilterOption.Contains, "3"); afl.AddFilter("name", FilterOption.Contains, "9"); var alist1 = dala.GetPageList(afl, 1, 100, "a").PageObject as List <a1>; var alist2 = dala.GetPageList(afl1, 1, 100, "a").PageObject as List <a1>; }
/// <summary> /// 获取用户(查看、新增、编辑)字段权限 /// </summary> /// <param name="userId">用户Id</param> /// <param name="moduleId">模块Id</param> /// <param name="fieldPermissionType">字段权限类型,0-查看,1-新增,2-编辑</param> /// <returns>返回允许(查看、新增、编辑)的字段名集合</returns> public List <string> GetUserFieldsPermissions(Guid userId, Guid moduleId, int fieldPermissionType) { List <string> fieldNames = new List <string>(); //如果存在用户自定义权限则取自定义用户权限 string errMsg = string.Empty; BaseDAL <Sys_UserPermissionField> userPermissionDal = new BaseDAL <Sys_UserPermissionField>(); Sys_UserPermissionField permissionField = userPermissionDal.GetEntity(out errMsg, x => x.Sys_UserId == userId && x.Sys_ModuleId == moduleId && !x.IsDeleted); string fields = string.Empty; if (permissionField != null) { fields = fieldPermissionType == 0 ? permissionField.CanViewFields : (fieldPermissionType == 1 ? permissionField.CanAddFields : permissionField.CanEditFields); } if (!string.IsNullOrWhiteSpace(fields)) { string[] token = fields.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); if (token.Contains("-1")) { return new List <string>() { "-1" } } ; //所有字段权限 foreach (string field in token) { if (!fieldNames.Contains(field)) { fieldNames.Add(field); } } return(fieldNames); } //取用户角色权限 List <Guid> roleIds = ObjectReferenceClass.GetUserRoleIds(userId); foreach (Guid roleId in roleIds) { Dictionary <string, bool> tempFields = GetRoleFieldPermissions(roleId, moduleId, fieldPermissionType, true); if (tempFields.ContainsKey("-1")) { return new List <string>() { "-1" } } ; //所有字段权限 foreach (string field in tempFields.Keys) { if (!fieldNames.Contains(field)) { fieldNames.Add(field); } } } return(fieldNames); } } }
/// <summary> /// Initializes the singleton application object. This is the first line of authored code /// executed, and as such is the logical equivalent of main() or WinMain(). /// </summary> public App() { this.InitializeComponent(); this.Suspending += OnSuspending; DAL = new LitedbDAL(); }
public static IResponsitryBase <T> CreateDAL <T>(DBType pp) where T : class, new() { IResponsitryBase <T> dal; switch (pp) { case (DBType.Sql): dataAccess = new BaseDAL <T>(); break; case (DBType.Sql2005): dataAccess = new SQL2005Dal <T>(); break; case (DBType.Oracle): dataAccess = new OracleDal <T>(); break; case (DBType.MySql): dataAccess = new MySqlDal <T>(); break; default: dataAccess = new BaseDAL <T>(); break; } }
private MySqlDataReader CallExcelrawDataDetail_USP(string excelDataJson) { MySqlDataReader dr = null; var errorOutput = ""; try { MySqlParameter excelParam = new MySqlParameter("@customerListData", excelDataJson); excelParam.Direction = ParameterDirection.Input; MySqlParameter outputParam = new MySqlParameter("@_errorOutput", errorOutput); outputParam.Direction = ParameterDirection.Output; MySqlCommand cmd = BaseDAL.GetSqlCommandProcedure(Get_All_Excel_Raw_Data_USP); cmd.Parameters.Add(excelParam); cmd.Parameters.Add(outputParam); dr = cmd.ExecuteReader(); } catch (MySqlException execption) { throw new Exception("Internal Error occurred: " + execption.Message); } return(dr); }
static void Main(string[] args) { try { Console.WriteLine("特性和AOP"); People people = new People(); UserModel userModel = new UserModel(); userModel.Id = 23; string remark = userModel.GetTableName(); BaseDAL.Save <UserModel>(userModel); #region AOP show Console.WriteLine("***********************"); Decorator.Show(); Console.WriteLine("***********************"); Proxy.Show(); Console.WriteLine("***********************"); CastleProxy.Show(); Console.WriteLine("***********************"); UnityAOP.Show(); #endregion } catch (Exception) { throw; } Console.Read(); }
//Delete User from DB public JsonResult DelUser() { try { string sUserids = Request.Form["deluserids"].ToString(); if (sUserids.Contains("_")) { string[] aUserids = sUserids.Split('_'); foreach (var id in aUserids) { int userid = Convert.ToInt32(id); User user = new BaseDAL <User>().GetModel(u => u.UserId == userid); new BaseDAL <User>().Del(user); } } else { int userid = Convert.ToInt32(sUserids); User user = new BaseDAL <User>().GetModel(u => u.UserId == userid); new BaseDAL <User>().Del(user); } dictionary.Add("success", true); } catch { dictionary.Add("success", false); } return(Json(dictionary)); }
private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { int rowIndex = e.RowIndex; if (rowIndex >= 0) { DataGridViewRow rowobj = this.dataGridView1.Rows[e.RowIndex]; var msgIDStr = rowobj.Cells["MsgID"].Value; if (msgIDStr != null) { int msgID = 0; if (Int32.TryParse(msgIDStr.ToString(), out msgID)) { SendMessage singleMsg = BaseDAL.Get <SendMessage>("GetMsgInfo", msgID); if (singleMsg != null) { // Running on the worker thread this.dataGridView1.Invoke((MethodInvoker) delegate { BaseDAL.Update("UpdateMsgReadStatus", singleMsg.ID); refreshDatagrid(this.dataGridView1); }); MessageFrm msgfrm = new MessageFrm(singleMsg); msgfrm.TopMost = true; msgfrm.Show(); } } } } }
public async Task <ModelMetrics> GenerateModel(BaseDAL storage, string modelFileName) { if (storage == null) { Log.Error("Trainer::GenerateModel - BaseDAL is null"); throw new ArgumentNullException(nameof(storage)); } if (string.IsNullOrEmpty(modelFileName)) { Log.Error("Trainer::GenerateModel - modelFileName is null"); throw new ArgumentNullException(nameof(modelFileName)); } if (!File.Exists(modelFileName)) { Log.Error($"Trainer::GenerateModel - {modelFileName} does not exist"); throw new FileNotFoundException(modelFileName); } var startTime = DateTime.Now; var options = new RandomizedPcaTrainer.Options { FeatureColumnName = FEATURES, ExampleWeightColumnName = null, Rank = 4, Oversampling = 20, EnsureZeroMean = true, Seed = Constants.ML_SEED }; var(data, cleanRowCount, maliciousRowCount) = GetDataView(await storage.QueryPacketsAsync(a => a.IsClean), await storage.QueryPacketsAsync(a => !a.IsClean)); IEstimator <ITransformer> dataProcessPipeline = _mlContext.Transforms.Concatenate( FEATURES, typeof(PayloadItem).ToPropertyList <PayloadItem>(nameof(PayloadItem.Label))); IEstimator <ITransformer> trainer = _mlContext.AnomalyDetection.Trainers.RandomizedPca(options: options); EstimatorChain <ITransformer> trainingPipeline = dataProcessPipeline.Append(trainer); TransformerChain <ITransformer> trainedModel = trainingPipeline.Fit(data.TrainSet); _mlContext.Model.Save(trainedModel, data.TrainSet.Schema, modelFileName); var testSetTransform = trainedModel.Transform(data.TestSet); return(new ModelMetrics { Metrics = _mlContext.AnomalyDetection.Evaluate(testSetTransform), NumCleanRows = cleanRowCount, NumMaliciousRows = maliciousRowCount, Duration = DateTime.Now.Subtract(startTime) }); }
static void Main(string[] args) { B1DAL dal = new B1DAL(); b1 b = new b1(); b.b = 10; var m=dal.Add(b); var model = dal.GetModel("id", 1); List<Filter> fl=new List<Filter>(); fl.AddFilter("id",FilterOption.LessThan,3); var list = dal.GetPageList(fl, 1, 15, "id"); BaseDAL<a1> dala = new BaseDAL<a1>(); dala.DbConnect = new DbEnum().GetDbConnectionName(dbE.T.testEntities); List<Filter> afl1=new List<Filter>(); afl1.AddFilter("name",FilterOption.Contains,"3"); List<Filter> afl=new List<Filter>(); afl.AddFilter("name",FilterOption.Contains,"3"); afl.AddFilter("name",FilterOption.Contains,"9"); var alist1 = dala.GetPageList(afl, 1, 100, "a").PageObject as List<a1>; var alist2 = dala.GetPageList(afl1, 1, 100, "a").PageObject as List<a1>; }
/// <summary> /// 获取单据编号 /// </summary> /// <param name="entity"></param> /// <returns></returns> public string GetAutoOrderCode(string tablename) { string strclear = string.Empty; try { string strRes = string.Empty; if (string.IsNullOrWhiteSpace(tablename)) { return strRes; } var ents = from n in GetTable<T_FB_ORDERCODE>() where n.TABLENAME == tablename select n; T_FB_ORDERCODE orderCode = ents.FirstOrDefault(); if (orderCode == null) { return strRes; } string shortName = orderCode.PRENAME; DateTime CurrentDate = orderCode.CURRENTDATE.Value; using (BaseDAL dal = new BaseDAL()) { Tracer.Debug("模块代码:" + tablename); switch (tablename) { case "T_FB_COMPANYBUDGETAPPLYMASTER": tablename = "T_FB_COMPANYBUDGETAPPLY";//名称太长导致无法创建sequence break; case "T_FB_COMPANYBUDGETMODMASTER": tablename = "T_FB_COMPANYBUDGETMOD";//名称太长导致无法创建sequence break; case "T_FB_COMPANYBUDGETSUMMASTER": tablename = "T_FB_COMPANYBUDGETSUM";//名称太长导致无法创建sequence break; case "T_FB_PERSONMONEYASSIGNMASTER": tablename = "T_FB_PERSONMONEYASSIGN";//名称太长导致无法创建sequence break; default: break; } if (CurrentDate.Date != System.DateTime.Now.Date) { orderCode.CURRENTDATE = System.DateTime.Now.Date; orderCode.RUNNINGNUMBER = 1; strclear = @"declare n number(10); tsql varchar2(1000); begin select " + tablename + "_SEQ.nextval into n from dual; " + " n:=-(n);" + " tsql:= 'alter sequence " + tablename + "_SEQ increment by '|| n;" + " execute immediate tsql; " + " select " + tablename + "_SEQ.nextval into n from dual; " + " tsql:= 'alter sequence " + tablename + "_SEQ increment by 1 '; " + " execute immediate tsql; " + " end; "; Tracer.Debug("ExecuteCustomerSql:" + strclear); dal.ExecuteCustomerSql(strclear); } decimal curNumber = 0; string strNextSqense = @" select " + tablename + "_SEQ.nextval from dual"; Tracer.Debug("调用新生成单号接口:tablename:" + tablename + " ExecuteCustomerSql:" + strNextSqense); curNumber = decimal.Parse(dal.ExecuteCustomerSql(strNextSqense).ToString()); string strDate = orderCode.CURRENTDATE.Value.ToString("yyyyMMdd"); string code = shortName + "_" + strDate + curNumber.ToString().PadLeft(6, '0'); Tracer.Debug("生成单号:" + code); orderCode.RUNNINGNUMBER =Convert.ToInt32(curNumber + 1); Update(orderCode); return code; } } catch (Exception ex) { Tracer.Debug("ExecuteCustomerSql:" + strclear + ex.ToString()); throw (ex); } }
public void Test_Select_All_Posts_Data_Table() { BaseDAL bDAL = new BaseDAL("Data Source=vm-dev-sql;Initial Catalog=SolrIndx; User Id=sa; Password=Professional2;Connection Timeout=6;"); var retset = bDAL.ExecuteSPReturnDataTable("SelectAllUsersPosts"); Assert.IsTrue(retset != null); }
protected void loginBtn_Click(object sender, EventArgs e) { string checkCode = user_checkCode.Text.Trim().ToLower(); if (Session["CheckCode"] == null | !checkCode.Equals(Session["CheckCode"].ToString().ToLower())) { string script = "alert('老兄,验证码错误哦!')"; Page.ClientScript.RegisterStartupScript(this.GetType(), null, script, true); user_checkCode.Text = ""; } else { string userName = user_name.Text.Trim(); string userPwd = user_password.Text.Trim(); string encodePwd = FormsAuthentication.HashPasswordForStoringInConfigFile(userPwd, "md5").Substring(0, 30); int failCount=Common.FailLoginCount(Common.GetIp()); if (failCount>5) { if (failCount < 11) { OA_log log = new OA_log(); log.ip = Common.GetIp(); log.wrongPw = "登录失败超五次:" + string.Format("{0}", userName) + "密码:" + userPwd; string[] columnA = { "ip", "wrongPw" }; ArrayList al = new ArrayList { log.ip, log.wrongPw }; logDal.insert(columnA, log, al); } scripthelp.Alert(userName + "登录失败超过五次!请联系管理员或一个小时后再登录", this.Page); return; } OA_users user = new OA_users(); BaseDAL<OA_users> userDal = new BaseDAL<OA_users>(); if (Regex.IsMatch(userName, @"[-|;|,|\/|\(|\)|\[|\]|\}|\{|%|@|\*|!|\']") && Regex.IsMatch(userPwd, @"[-|;|,|\/|\(|\)|\[|\]|\}|\{|%|\*|!|\']")) user = null; else { user = userDal.GetUser("loginName", userName, "pw", encodePwd); } if (user != null) { string userRole = user.roles; FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(1, userName, DateTime.Now, DateTime.Now.AddMinutes(30), false, userRole, "/"); string HashTicket = FormsAuthentication.Encrypt(ticket); HttpCookie userCookie = new HttpCookie(FormsAuthentication.FormsCookieName, HashTicket); Context.Response.Cookies.Add(userCookie); Session["user"] = user; if(FormsAuthentication.GetRedirectUrl(userName,false)=="default.aspx") Response.Redirect(FormsAuthentication.GetRedirectUrl(userName, false)); else Response.Redirect("home.aspx"); } else { OA_log log = new OA_log(); log.ip = Common.GetIp(); log.wrongPw ="登录名:"+ string.Format("{0}", userName) + "密码:" + userPwd; string[] columnA = { "ip", "wrongPw" }; ArrayList al = new ArrayList { log.ip, log.wrongPw }; logDal.insert(columnA, log, al); Common.isDeleteOldLog();//防止日志文件太多所以删除过多过久的日志 scripthelp.Alert("老兄,用户名或密码错误哦!", this.Page); user_checkCode.Text = ""; } } }