public override BulkInsertResult <string> InsertMany(IEnumerable <T> entities, InsertMode insertMode) { if (insertMode != InsertMode.db_implementation) { throw new NotImplementedException(); } var insertResult = new BulkInsertResult <string>(); var creationDate = NoSQLRepoHelper.DateTimeUtcNow(); foreach (var entity in entities) { if (AutoGeneratedEntityDate) { entity.SystemCreationDate = creationDate; } if (AutoGeneratedEntityDate) { entity.SystemLastUpdateDate = creationDate; } NoSQLRepoHelper.SetIds(entity); var entityToStore = NewtonJsonHelper.CloneJson(entity, DateTimeZoneHandling.Utc); localDb[entity.Id] = entityToStore; config.ExpireAt(entity.Id, null); insertResult[entity.Id] = InsertResult.unknown; } SaveJSONFile(); return(insertResult); }
public override InsertResult InsertOne(T entity, InsertMode insertMode) { CheckOpenedConnection(); var entitydomain = entity; NoSQLRepoHelper.SetIds(entitydomain); var updateddate = NoSQLRepoHelper.DateTimeUtcNow(); var createdDate = NoSQLRepoHelper.DateTimeUtcNow(); if (!string.IsNullOrEmpty(entity.Id) && localDb.ContainsKey(entity.Id)) { // Document already exists switch (insertMode) { case InsertMode.error_if_key_exists: throw new DupplicateKeyNoSQLException(); case InsertMode.erase_existing: createdDate = localDb[entity.Id].SystemCreationDate; localDb.Remove(entity.Id); break; case InsertMode.do_nothing_if_key_exists: return(InsertResult.not_affected); default: break; } } if (AutoGeneratedEntityDate) { entitydomain.SystemCreationDate = createdDate; entitydomain.SystemLastUpdateDate = updateddate; } // Clone to not shared reference between App instance and repository persisted value // UTC : Ensure to store only utc datetime var entityToStore = NewtonJsonHelper.CloneJson(entitydomain, DateTimeZoneHandling.Utc); if (localDb.ContainsKey(entity.Id)) { localDb[entity.Id] = entityToStore; } else { localDb.Add(entity.Id, entityToStore); } config.ExpireAt(entity.Id, null); SaveJSONFile(); return(InsertResult.inserted); }
/// <summary> /// 获取用户信息 /// </summary> /// <returns></returns> public object GetUserMess() { string userName = Tools.SessionHelper.GetSession <Base_UserInfo>(Tools.SessionHelper.SessinoName.CurUser).UserName; List <string> igorelist = new List <string>() { "Orgs", "Roles" }; Base_UserInfo UserInfo = _userInfoBll.FindBy(t => t.UserName == userName).ToList <Base_UserInfo>().FirstOrDefault(); if (UserInfo != null) { return(Common.NewtonJsonHelper.Deserialize <object>(NewtonJsonHelper.Serialize(UserInfo, igorelist), null)); } return(Common.NewtonJsonHelper.Deserialize <object>(NewtonJsonHelper.Serialize("{}", null), null)); }
public override InsertResult InsertOne(T entity, InsertMode keyExistsAction) { var insertResult = default(InsertResult); var date = NoSQLRepoHelper.DateTimeUtcNow(); if (AutoGeneratedEntityDate) { entity.SystemCreationDate = date; entity.SystemLastUpdateDate = date; } NoSQLRepoHelper.SetIds(entity); if (localDb.ContainsKey(entity.Id)) { if (keyExistsAction == InsertMode.error_if_key_exists) { throw new DupplicateKeyNoSQLException(); } else if (keyExistsAction == InsertMode.do_nothing_if_key_exists) { return(InsertResult.not_affected); } else if (keyExistsAction == InsertMode.erase_existing) { entity.SystemCreationDate = localDb[entity.Id].SystemCreationDate; // keep the origin creation date of the entity // Continue execution } insertResult = InsertResult.updated; } else { insertResult = InsertResult.inserted; } // Clone to not shared reference between App instance and repository persisted value // UTC : Ensure to store only utc datetime var entityToStore = NewtonJsonHelper.CloneJson(entity, DateTimeZoneHandling.Utc); localDb[entity.Id] = entityToStore; config.ExpireAt(entity.Id, null); SaveJSONFile(); return(insertResult); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "application/json"; string action = context.Request.Params["action"]; DriveMgr.Model.UserOperateLog userOperateLog = null; //操作日志对象 try { DriveMgr.Model.User userFromCookie = DriveMgr.Common.UserHelper.GetUser(context); //获取cookie里的用户对象 userOperateLog = new Model.UserOperateLog(); userOperateLog.UserIp = context.Request.UserHostAddress; userOperateLog.UserName = userFromCookie.UserId; switch (action) { case "search": string strWhere = "1=1"; string sort = context.Request.Params["sort"]; //排序列 string order = context.Request.Params["order"]; //排序方式 asc或者desc int pageindex = int.Parse(context.Request.Params["page"]); int pagesize = int.Parse(context.Request.Params["rows"]); string ui_students_name = context.Request.Params["ui_students_name"] ?? ""; string ui_students_code = context.Request.Params["ui_students_code"] ?? ""; string ui_students_cardnum = context.Request.Params["ui_students_cardnum"] ?? ""; string ui_students_status = context.Request.Params["ui_students_status"] ?? ""; string ui_pay_status = context.Request.Params["ui_pay_status"] ?? ""; string ui_students_period = context.Request.Params["ui_students_period"] ?? ""; //string ui_user_userid = context.Request.Params["ui_user_userid"] ?? ""; //string ui_user_username = context.Request.Params["ui_user_username"] ?? ""; //string ui_user_isable = context.Request.Params["ui_user_isable"] ?? ""; //string ui_user_ifchangepwd = context.Request.Params["ui_user_ifchangepwd"] ?? ""; //string ui_user_description = context.Request.Params["ui_user_description"] ?? ""; //string ui_user_adddatestart = context.Request.Params["ui_user_adddatestart"] ?? ""; //string ui_user_adddateend = context.Request.Params["ui_user_adddateend"] ?? ""; strWhere += " and flag=1"; if (ui_students_name.Trim() != "" && !DriveMgr.Common.SqlInjection.GetString(ui_students_name)) //防止sql注入 { strWhere += string.Format(" and StudentsName like '%{0}%'", ui_students_name.Trim()); } if (ui_students_code.Trim() != "" && !DriveMgr.Common.SqlInjection.GetString(ui_students_code)) { strWhere += string.Format(" and StudentCode like '%{0}%'", ui_students_code.Trim()); } if (ui_students_cardnum.Trim() != "" && !DriveMgr.Common.SqlInjection.GetString(ui_students_cardnum)) { strWhere += string.Format(" and CardNum like '%{0}%'", ui_students_cardnum.Trim()); } if (ui_students_status.Trim() != "select" && ui_students_status.Trim() != "") { strWhere += " and Status = '" + ui_students_status.Trim() + "'"; } if (ui_pay_status.Trim() != "select" && ui_pay_status.Trim() != "") { strWhere += " and PayStatus = '" + ui_pay_status.Trim() + "'"; } if (ui_students_period.Trim() != "select" && ui_students_period.Trim() != "") { strWhere += " and PeriodsID = '" + ui_students_period.Trim() + "'"; } int totalCount; //输出参数 string strJson = new DriveMgr.BLL.RegistrationBLL().GetPager("V_StudentsBaseData", "*", sort + " " + order, pagesize, pageindex, strWhere, out totalCount); context.Response.Write("{\"total\": " + totalCount.ToString() + ",\"rows\":" + strJson + "}"); userOperateLog.OperateInfo = "查询学员"; userOperateLog.IfSuccess = true; userOperateLog.Description = "查询条件:" + strWhere + " 排序:" + sort + " " + order + " 页码/每页大小:" + pageindex + " " + pagesize; DriveMgr.BLL.UserOperateLog.InsertOperateInfo(userOperateLog); break; case "add": if (userFromCookie != null && new DriveMgr.BLL.Authority().IfAuthority("registration", "add", userFromCookie.Id)) { string ui_registration_name_add = context.Request.Params["ui_registration_name_add"] ?? ""; string ui_registration_cardnum_add = context.Request.Params["ui_registration_cardnum_add"] ?? ""; int ui_registration_age_add = Int32.Parse(context.Request.Params["ui_registration_age_add"] ?? "-1"); bool ui_registration_sex_add = context.Request.Params["ui_registration_sex_add"] == "0" ? false : true; bool ui_registration_islocal_add = context.Request.Params["ui_registration_islocal_add"] == "0" ? false : true; int ui_registration_period_add = Int32.Parse(context.Request.Params["ui_registration_period_add"] ?? "-1"); string ui_registration_address_add = context.Request.Params["ui_registration_address_add"] ?? ""; string ui_registration_remark_add = context.Request.Params["ui_registration_remark_add"] ?? ""; string fupPic_add = context.Request.Params["fupPic_add"] ?? ""; string ui_registration_phoneNum_add = context.Request.Params["ui_registration_phoneNum_add"] ?? ""; DriveMgr.Model.RegistrationModel registrationAdd = new Model.RegistrationModel(); registrationAdd.StudentsName = ui_registration_name_add; registrationAdd.CardNum = ui_registration_cardnum_add; registrationAdd.Age = ui_registration_age_add; registrationAdd.Sex = ui_registration_sex_add; registrationAdd.IsLocal = ui_registration_islocal_add; registrationAdd.PeriodsID = ui_registration_period_add; registrationAdd.Address = ui_registration_address_add; registrationAdd.Remark = ui_registration_remark_add; registrationAdd.Status = 0; //【0:在学 1:毕业 2:退学】 if (fupPic_add.Trim() == "") { registrationAdd.PicPath = ""; } else { registrationAdd.PicPath = "/images/Pictures/" + fupPic_add; } registrationAdd.PhoneNum = ui_registration_phoneNum_add; FormsIdentity id = (FormsIdentity)context.User.Identity; FormsAuthenticationTicket tickets = id.Ticket; //获取票证里序列化的用户对象(反序列化) DriveMgr.Model.User userCheck = new JavaScriptSerializer().Deserialize <DriveMgr.Model.User>(tickets.UserData); registrationAdd.Operater = userCheck.UserName; DriveMgr.BLL.RegistrationBLL bll = new DriveMgr.BLL.RegistrationBLL(); bool result = bll.Add(registrationAdd); if (result) { //RegistrationModel mod = bll.GetModel(result); //string changeMsg = String.Empty; //try //{ // string srcPath = context.Server.MapPath(mod.PicPath); // string extension = Path.GetFileNameWithoutExtension(srcPath); // string desPath = context.Server.MapPath("/admin/images/Pictures/" + mod.CardNum + ".jpg"); // bool changeResult = FileHelpercs.ChangeFileName(srcPath, desPath); // if (changeResult) // { // changeMsg = "改变照片名称成功!从" + srcPath + "到" + desPath; // } // else // { // changeMsg = "改变照片名称失败!从" + srcPath + "到" + desPath; // } //} //catch //{ // changeMsg = "改变照片名称失败!"; //} userOperateLog.OperateInfo = "添加学员"; userOperateLog.IfSuccess = true; userOperateLog.Description = "添加成功,学员" + ui_registration_name_add; context.Response.Write("{\"msg\":\"添加学员成功!" + "\",\"success\":true}"); } else { userOperateLog.OperateInfo = "添加学员"; userOperateLog.IfSuccess = false; userOperateLog.Description = "添加失败"; context.Response.Write("{\"msg\":\"添加失败!\",\"success\":false}"); } } else { userOperateLog.OperateInfo = "添加学员"; userOperateLog.IfSuccess = false; userOperateLog.Description = "无权限,请联系管理员"; context.Response.Write("{\"msg\":\"无权限,请联系管理员!\",\"success\":false}"); } DriveMgr.BLL.UserOperateLog.InsertOperateInfo(userOperateLog); break; case "edit": if (userFromCookie != null && new DriveMgr.BLL.Authority().IfAuthority("registration", "edit", userFromCookie.Id)) { int id = Convert.ToInt32(context.Request.Params["id"]); string ui_registration_name_edit = context.Request.Params["ui_registration_name_edit"] ?? ""; string ui_registration_cardnum_edit = context.Request.Params["ui_registration_cardnum_edit"] ?? ""; int ui_registration_age_edit = Int32.Parse(context.Request.Params["ui_registration_age_edit"] ?? "-1"); bool ui_registration_sex_edit = context.Request.Params["ui_registration_sex_edit"] == "0" ? false : true; bool ui_registration_islocal_edit = context.Request.Params["ui_registration_islocal_edit"] == "0" ? false : true; int ui_registration_period_edit = Int32.Parse(context.Request.Params["ui_registration_period_edit"] ?? "-1"); string ui_registration_address_edit = context.Request.Params["ui_registration_address_edit"] ?? ""; string ui_registration_remark_edit = context.Request.Params["ui_registration_remark_edit"] ?? ""; string ui_registration_phoneNum_edit = context.Request.Params["ui_registration_phoneNum_edit"] ?? ""; DriveMgr.Model.RegistrationModel registrationedit = new Model.RegistrationModel(); registrationedit.ID = id; registrationedit.StudentsName = ui_registration_name_edit; registrationedit.CardNum = ui_registration_cardnum_edit; registrationedit.Age = ui_registration_age_edit; registrationedit.Sex = ui_registration_sex_edit; registrationedit.IsLocal = ui_registration_islocal_edit; registrationedit.PeriodsID = ui_registration_period_edit; registrationedit.Address = ui_registration_address_edit; registrationedit.Remark = ui_registration_remark_edit; //registrationedit.Status = 0; //【0:在学 1:毕业 2:退学】 registrationedit.PhoneNum = ui_registration_phoneNum_edit; //手机号码 FormsIdentity iid = (FormsIdentity)context.User.Identity; FormsAuthenticationTicket tickets = iid.Ticket; //获取票证里序列化的用户对象(反序列化) DriveMgr.Model.User userCheck = new JavaScriptSerializer().Deserialize <DriveMgr.Model.User>(tickets.UserData); registrationedit.Operater = userCheck.UserName; if (new DriveMgr.BLL.RegistrationBLL().Update(registrationedit)) { userOperateLog.OperateInfo = "修改学员"; userOperateLog.IfSuccess = true; userOperateLog.Description = "修改成功,学员主键:" + registrationedit.ID; context.Response.Write("{\"msg\":\"修改成功!\",\"success\":true}"); } else { userOperateLog.OperateInfo = "修改学员"; userOperateLog.IfSuccess = false; userOperateLog.Description = "修改失败"; context.Response.Write("{\"msg\":\"修改失败!\",\"success\":false}"); } } else { userOperateLog.OperateInfo = "修改学员"; userOperateLog.IfSuccess = false; userOperateLog.Description = "无权限,请联系管理员"; context.Response.Write("{\"msg\":\"无权限,请联系管理员!\",\"success\":false}"); } DriveMgr.BLL.UserOperateLog.InsertOperateInfo(userOperateLog); break; case "delete": if (userFromCookie != null && new DriveMgr.BLL.Authority().IfAuthority("registration", "delete", userFromCookie.Id)) { string ids = context.Request.Params["id"].Trim(','); if (new DriveMgr.BLL.RegistrationBLL().DeleteList(ids)) { userOperateLog.OperateInfo = "删除学员"; userOperateLog.IfSuccess = true; userOperateLog.Description = "删除成功,学员主键:" + ids; context.Response.Write("{\"msg\":\"删除成功!\",\"success\":true}"); } else { userOperateLog.OperateInfo = "删除学员"; userOperateLog.IfSuccess = false; userOperateLog.Description = "删除失败"; context.Response.Write("{\"msg\":\"删除失败!\",\"success\":false}"); } } else { userOperateLog.OperateInfo = "删除学员"; userOperateLog.IfSuccess = false; userOperateLog.Description = "无权限,请联系管理员"; context.Response.Write("{\"msg\":\"无权限,请联系管理员!\",\"success\":false}"); } DriveMgr.BLL.UserOperateLog.InsertOperateInfo(userOperateLog); break; case "bindPeroid": DataTable dt = new DriveMgr.BLL.RegistrationBLL().BindPeroid(); string peroidResult = NewtonJsonHelper.ToJson(dt); context.Response.Write(peroidResult); break; case "pay": if (userFromCookie != null && new DriveMgr.BLL.Authority().IfAuthority("registration", "paytuition", userFromCookie.Id)) { bool payResult = DoTuition(context); if (payResult) { userOperateLog.OperateInfo = "缴纳学费"; userOperateLog.IfSuccess = true; userOperateLog.Description = "交费成功。"; context.Response.Write("{\"msg\":\"交费成功!\",\"success\":true}"); } else { userOperateLog.OperateInfo = "缴纳学费"; userOperateLog.IfSuccess = false; userOperateLog.Description = "交费失败"; context.Response.Write("{\"msg\":\"交费失败!\",\"success\":false}"); } } break; case "payExam": if (userFromCookie != null && new DriveMgr.BLL.Authority().IfAuthority("registration", "payExam", userFromCookie.Id)) { bool payResult = PayExam(context); if (payResult) { userOperateLog.OperateInfo = "缴纳考试费"; userOperateLog.IfSuccess = true; userOperateLog.Description = "交费成功。"; context.Response.Write("{\"msg\":\"交考试费成功!\",\"success\":true}"); } else { userOperateLog.OperateInfo = "缴纳考试费"; userOperateLog.IfSuccess = false; userOperateLog.Description = "交考试费失败"; context.Response.Write("{\"msg\":\"交考试费失败!\",\"success\":false}"); } } break; case "exit": if (userFromCookie != null && new DriveMgr.BLL.Authority().IfAuthority("registration", "exit", userFromCookie.Id)) { bool exitResult = DropOut(context); if (exitResult) { userOperateLog.OperateInfo = "退学"; userOperateLog.IfSuccess = true; userOperateLog.Description = "退学成功。"; context.Response.Write("{\"msg\":\"退学成功!\",\"success\":true}"); } else { userOperateLog.OperateInfo = "退学"; userOperateLog.IfSuccess = false; userOperateLog.Description = "退学失败"; context.Response.Write("{\"msg\":\"退学失败!\",\"success\":false}"); } } break; case "getInfoByCard": string infoResult = GetInfoByCard(context); context.Response.Write(infoResult); break; case "uploadPic": string uploadResult = UploadPic(context); context.Response.Write(uploadResult); break; case "printApplyTable": string printResult = PrintApplyTable(context); context.Response.Write(printResult); break; case "exportStudents": string exportResult = DownloadExcel(context); context.Response.Write(exportResult); break; case "addByCard": if (userFromCookie != null && new DriveMgr.BLL.Authority().IfAuthority("registration", "byCard", userFromCookie.Id)) { string ui_registration_name_byCard = context.Request.Params["ui_registration_name_byCard"] ?? ""; string ui_registration_cardnum_byCard = context.Request.Params["ui_registration_cardnum_byCard"] ?? ""; int ui_registration_age_byCard = Int32.Parse(context.Request.Params["ui_registration_age_byCard"] ?? "-1"); bool ui_registration_sex_byCard = context.Request.Params["ui_registration_sex_byCard"] == "0" ? false : true; bool ui_registration_islocal_byCard = context.Request.Params["ui_registration_islocal_byCard"] == "0" ? false : true; int ui_registration_period_byCard = Int32.Parse(context.Request.Params["ui_registration_period_byCard"] ?? "-1"); string ui_registration_address_byCard = context.Request.Params["ui_registration_address_byCard"] ?? ""; string ui_registration_remark_byCard = context.Request.Params["ui_registration_remark_byCard"] ?? ""; string ui_registration_phoneNum_byCard = context.Request.Params["ui_registration_phoneNum_byCard"] ?? ""; string fupPic_byCard = context.Request.Params["picPath"] ?? ""; DriveMgr.Model.RegistrationModel registrationAdd = new Model.RegistrationModel(); registrationAdd.StudentsName = ui_registration_name_byCard; registrationAdd.CardNum = ui_registration_cardnum_byCard; registrationAdd.Age = ui_registration_age_byCard; registrationAdd.Sex = ui_registration_sex_byCard; registrationAdd.IsLocal = ui_registration_islocal_byCard; registrationAdd.PeriodsID = ui_registration_period_byCard; registrationAdd.Address = ui_registration_address_byCard; registrationAdd.Remark = ui_registration_remark_byCard; registrationAdd.Status = 0; //【0:在学 1:毕业 2:退学】 if (fupPic_byCard.Replace("/images/Pictures/", "").Trim() == "") { registrationAdd.PicPath = ""; } else { registrationAdd.PicPath = fupPic_byCard; } registrationAdd.PhoneNum = ui_registration_phoneNum_byCard; FormsIdentity id = (FormsIdentity)context.User.Identity; FormsAuthenticationTicket tickets = id.Ticket; //获取票证里序列化的用户对象(反序列化) DriveMgr.Model.User userCheck = new JavaScriptSerializer().Deserialize <DriveMgr.Model.User>(tickets.UserData); registrationAdd.Operater = userCheck.UserName; DriveMgr.BLL.RegistrationBLL bll = new DriveMgr.BLL.RegistrationBLL(); bool result = bll.Add(registrationAdd); if (result) { userOperateLog.OperateInfo = "刷卡添加学员"; userOperateLog.IfSuccess = true; userOperateLog.Description = "添加成功,学员" + ui_registration_name_byCard; context.Response.Write("{\"msg\":\"添加学员成功!" + "\",\"success\":true}"); } else { userOperateLog.OperateInfo = "刷卡添加学员"; userOperateLog.IfSuccess = false; userOperateLog.Description = "添加失败"; context.Response.Write("{\"msg\":\"添加失败!\",\"success\":false}"); } } else { userOperateLog.OperateInfo = "刷卡添加学员"; userOperateLog.IfSuccess = false; userOperateLog.Description = "无权限,请联系管理员"; context.Response.Write("{\"msg\":\"无权限,请联系管理员!\",\"success\":false}"); } DriveMgr.BLL.UserOperateLog.InsertOperateInfo(userOperateLog); break; case "uploadPicByCard": string uploadPicByCard = SavePicToServer(context); context.Response.Write(uploadPicByCard); break; default: context.Response.Write("{\"msg\":\"参数错误!\",\"success\":false}"); break; } } catch (Exception ex) { context.Response.Write("{\"msg\":\"" + DriveMgr.Common.JsonHelper.StringFilter(ex.Message) + "\",\"success\":false}"); userOperateLog.OperateInfo = "学员功能异常"; userOperateLog.IfSuccess = false; userOperateLog.Description = DriveMgr.Common.JsonHelper.StringFilter(ex.Message); DriveMgr.BLL.UserOperateLog.InsertOperateInfo(userOperateLog); } }
/// <summary> /// 获取报价表报价成功的数据 /// </summary> /// <param name="page"></param> /// <param name="limit"></param> /// <param name="swhere"></param> /// <param name="sort"></param> /// <returns></returns> public object GetQuoteResultList(int page, int limit, string swhere, string sort) { string user = Tools.SessionHelper.GetSession <Base_UserInfo>(Tools.SessionHelper.SessinoName.CurUser).UserName; List <String> IDs = SessionFactory.GetCurrentSession().QueryOver <SupplierQuote>().Where(o => o.QuotationCompany == user).Select(t => t.InquiryTitle).List <string>().ToList(); //获取我参与过的项目的名称 StringBuilder where = new StringBuilder(); //拼接查询条件(项目名称格式化) foreach (var ID in IDs) { where.Append("'" + ID + "',"); } string ere = where.ToString().TrimEnd(',');//得到字符串并去掉最后的逗号 string temp = "1"; string temp1 = "1"; try { if (swhere != null) { int s = swhere.IndexOf("|"); int a = swhere.LastIndexOf("|"); temp = swhere.Substring(0, s); temp1 = swhere.Substring(a + 1, swhere.Length - a - 1); } } catch (Exception ee) { return("查询抛出异常" + ee); } try { List <SupplierQuote> upLoadList = Tools.ExecSqlHelp.ExecuteSql <SupplierQuote>("SELECT * FROM " + //"SupplierQuote WHERE quotestate=2 and InquiryTitle in (lists)", new List<SqlParameter>(){ // new SqlParameter(){ParameterName="lists",Value=ere} "SupplierQuote WHERE quotestate=2 and " + temp + " like '%" + temp1 + "%' and InquiryTitle in (" + ere + ")", null); //拼接SQL进行查询 return(Common.NewtonJsonHelper.Deserialize <object>("{\"curPage\":" + page + ",\"success\":true,\"total\":" + upLoadList.Count + ",\"QuoteResultList\":" + NewtonJsonHelper.Serialize(upLoadList, null) + "}", null)); //构造返回数据 } catch (Exception ee) { return("查询抛出异常" + ee); } #if debug //try //{ // string userName = Tools.SessionHelper.GetSession<Base_UserInfo>(Tools.SessionHelper.SessinoName.CurUser).UserName;//获取当前用户 // StringBuilder where = new StringBuilder(); // //swhere = swhere != null ? swhere.TrimStart(',') + ",STATE|int|0|=" : "STATE|int|0|="; // //where.Append(swhere); // where.Append(",InquiryTitle|string|"); // foreach (var ID in IDs) // { // where.Append("'" + ID + "',"); // } // string ere = where.ToString().TrimEnd(',') + "|in"; // swhere = string.IsNullOrEmpty(swhere) ? ere : ere + "," + swhere; // ////where.Append(",InquiryTitle in (@"); // //where.Append("InquiryTitle in (@"); // ////foreach (var ID in IDs) // ////{ // //// where.Append("'" + ID + "',"); // ////} // //for (int i = 0; i < IDs.Count; i++) // //{ // // where.Append("'" + IDs[i] + "',"); // //} // //string here = where.ToString().TrimEnd(',') + "@)"; // //swhere = string.IsNullOrEmpty(swhere) ? here : here + "," + swhere; // ////where.Append("@)"); // ////where.AppendFormat(",InquiryTitle in (@{0}@)" , IDs); // ////where.AppendFormat(",InquiryTitle|string|{0}|" + +"in" + ss); // PageParameter pagePara = new PageParameter() // { // PageIndex = page, // Limit = limit, // //Swhere = where.ToString(),a // Swhere = swhere, // Sort = sort, // ObjName = "QuoteResultList", // Igorelist = new List<string>() { "Inquiries" } // }; // QueryParameter query = new QueryParameter("SupplierQuote", pagePara.Swhere, pagePara, null); // return this.GetAllPageList(query); //} //catch (Exception ee) //{ // return null; //} /***/ #endif }