/// <summary>
/// 获取充值记录列表
/// </summary>
/// <param name="id"></param>
/// <param name="pageIndex"></param>
/// <param name="page"></param>
/// <returns></returns>
public PagedList <V_Recharge_user_bank> Recharge(int id, string startdatetime, string enddatetime, int?pageIndex = 1, int page = 1, int PageSize = 5)
{
Expression <Func <V_Recharge_user_bank, bool> > where = PredicateExtensionses.True <V_Recharge_user_bank>();
where = where.And(p => p.recharge_history_id > 0);
where = where.And(p => p.membertable_registerid == id);
DateTime sdatetime = new DateTime();
DateTime edatetime = new DateTime();
if (Utils.IsDate(startdatetime))
{
sdatetime = DateTime.Parse(startdatetime);
}
if (Utils.IsDate(enddatetime))
{
edatetime = DateTime.Parse(enddatetime);
}
if (sdatetime > DateTime.Parse("0001-01-01 00:00:00") && edatetime > DateTime.Parse("0001-01-01 00:00:00"))
{
where = where.And(p => ((DateTime)p.recharge_time).CompareTo(sdatetime) >= 0);
DateTime dt2 = Convert.ToDateTime(edatetime.ToString("yyyy-MM-dd") + " 23:59:59");
where = where.And(p => ((DateTime)p.recharge_time).CompareTo(dt2) <= 0);
}
var list = ef.V_Recharge_user_bank.Where(where).OrderByDescending(p => p.recharge_history_id).ToPagedList(pageIndex ?? 1, PageSize);
return(list);
}
/// <summary>
/// 邀请记录
/// </summary>
/// <param name="id"></param>
/// <param name="startdatetime"></param>
/// <param name="enddatetime"></param>
/// <param name="pageIndex"></param>
/// <param name="page"></param>
/// <param name="pgaesize"></param>
/// <returns></returns>
public PagedList <hx_td_usrlogininfo> usrlogin(int id, string startdatetime, string enddatetime, int?acttype = 1, int?pageIndex = 1, int page = 1, int pgaesize = 5)
{
Expression <Func <hx_td_usrlogininfo, bool> > where = PredicateExtensionses.True <hx_td_usrlogininfo>();
where = where.And(p => p.registerid == id);
DateTime sdatetime = new DateTime();
DateTime edatetime = new DateTime();
if (Utils.IsDate(startdatetime))
{
sdatetime = DateTime.Parse(startdatetime);
}
if (Utils.IsDate(enddatetime))
{
edatetime = DateTime.Parse(enddatetime);
}
if (sdatetime > DateTime.Parse("0001-01-01 00:00:00") && edatetime > DateTime.Parse("0001-01-01 00:00:00"))
{
where = where.And(p => ((DateTime)p.logintime).CompareTo(sdatetime) >= 0);
DateTime dt2 = Convert.ToDateTime(edatetime.ToString("yyyy-MM-dd") + " 23:59:59");
where = where.And(p => ((DateTime)p.logintime).CompareTo(dt2) <= 0);
}
var list = ef.hx_td_usrlogininfo.Where(where).OrderByDescending(p => p.loginid).ToPagedList(pageIndex ?? 1, pgaesize);
return(list);
}
/// <summary>
/// 用户投资记录
/// </summary>
/// <param name="id"></param>
/// <param name="startdatetime"></param>
/// <param name="enddatetime"></param>
/// <param name="pageIndex"></param>
/// <param name="page"></param>
/// <param name="pgaesize"></param>
/// <returns></returns>
public PagedList <V_hx_Bid_records_borrowing_target> Bid_RecordsList(int id, string startdatetime, string enddatetime, int?pageIndex = 1, int page = 1, int pgaesize = 5)
{
Expression <Func <V_hx_Bid_records_borrowing_target, bool> > where = PredicateExtensionses.True <V_hx_Bid_records_borrowing_target>();
where = where.And(p => p.registerid > 0);
where = where.And(p => p.registerid == id);
DateTime sdatetime = new DateTime();
DateTime edatetime = new DateTime();
if (Utils.IsDate(startdatetime))
{
sdatetime = DateTime.Parse(startdatetime);
}
if (Utils.IsDate(enddatetime))
{
edatetime = DateTime.Parse(enddatetime);
}
if (sdatetime > DateTime.Parse("0001-01-01 00:00:00") && edatetime > DateTime.Parse("0001-01-01 00:00:00"))
{
where = where.And(p => ((DateTime)p.invest_time).CompareTo(sdatetime) >= 0);
DateTime dt2 = Convert.ToDateTime(edatetime.ToString("yyyy-MM-dd") + " 23:59:59");
where = where.And(p => ((DateTime)p.invest_time).CompareTo(dt2) <= 0);
}
var list = ef.V_hx_Bid_records_borrowing_target.Where(where).OrderByDescending(p => p.bid_records_id).ToPagedList(pageIndex ?? 1, pgaesize);
return(list);
}
public PagedList <hx_td_LL_cash> UserLLCash(int id, string startdatetime, string enddatetime, int?pageIndex = 1, int page = 1, int pagesize = 5)
{
Expression <Func <hx_td_LL_cash, bool> > where = PredicateExtensionses.True <hx_td_LL_cash>();
where = where.And(p => p.LLcashid > 0);
where = where.And(p => p.Usrid == id);
where = where.And(p => p.bank_code != null);
DateTime sdatetime = new DateTime();
DateTime edatetime = new DateTime();
if (Utils.IsDate(startdatetime))
{
sdatetime = DateTime.Parse(startdatetime);
}
if (Utils.IsDate(enddatetime))
{
edatetime = DateTime.Parse(enddatetime);
}
if (sdatetime > DateTime.Parse("0001-01-01 00:00:00") && edatetime > DateTime.Parse("0001-01-01 00:00:00"))
{
where = where.And(p => ((DateTime)p.ordertime).CompareTo(sdatetime) >= 0);
DateTime dt2 = Convert.ToDateTime(edatetime.ToString("yyyy-MM-dd") + " 23:59:59");
where = where.And(p => ((DateTime)p.ordertime).CompareTo(dt2) <= 0);
}
var list = ef.hx_td_LL_cash.Where(where).OrderByDescending(p => p.LLcashid).ToPagedList(pageIndex ?? 1, pagesize);
return(list);
}
public ActionResult Index(string mention_charges_name = "", int fees_unit = -1, int Page = 1, int pageSize = 10)
{
int pageNumber = Page / 1;
Expression <Func <hx_Mention_charges, bool> > where = PredicateExtensionses.True <hx_Mention_charges>();
where = where.And(p => p.mention_charges_id > 0);
if (fees_unit > -1)
{
where = where.And(p => p.fees_unit == fees_unit);
}
if (!string.IsNullOrEmpty(mention_charges_name))
{
where = where.And(p => p.mention_charges_name.Contains(mention_charges_name));
}
IPagedList <hx_Mention_charges> list = ef.hx_Mention_charges.Where(where).OrderByDescending(p => p.mention_charges_id).ToPagedList(pageNumber, pageSize);
ViewBag.mention_charges_name = mention_charges_name;
ViewBag.fees_unit = fees_unit;
ViewBag.page = Page;
return(View(list));
}
/// <summary>
/// 加载数据
/// </summary>
private void LoadData(string strName)
{
try
{
if (expr == null)
{
if (expr == null)
{
expr = PredicateExtensionses.True <View_ClientInfo>();
}
}
if (txtSName.Text.Trim() != "")
{
expr = expr.And(n => SqlMethods.Like(n.Client_NAME, "%" + txtSName.Text.Trim() + "%"));
}
if (cmbSState.Text != "全部" && cmbSState.Text != "")
{
int did = Convert.ToInt32(cmbSState.SelectedValue.ToString());
expr = expr.And(n => (n.Dictionary_ID == did));
}
this.dgvClient.DataSource = null;
page.PageMaxCount = tscbxPageSize2.SelectedItem.ToString();
this.dgvClient.AutoGenerateColumns = false;
dgvClient.DataSource = page.BindBoundControl <View_ClientInfo>(strName, txtCurrentPage2, lblPageCount2, expr);
}
catch (Exception ex)
{
Common.WriteTextLog("客户端管理 LoadData()" + ex.Message.ToString());
}
}
public ActionResult Index(string adname = "", int AdTypeState = -1, int ddlType = 8, int adstate = 0, int Page = 1, int pageSize = 10)
{
int pageNumber = Page / 1;
Expression <Func <V_AD_type, bool> > where = PredicateExtensionses.True <V_AD_type>();
where = where.And(p => p.Adid > 0);
if (!string.IsNullOrEmpty(adname))
{
where = where.And(p => p.AdName.Contains(adname));
}
if (adstate == 1)
{
where = where.And(p => p.AdState == 0);
}
else if (adstate == 2)
{
where = where.And(p => p.AdState == 1);
}
if (AdTypeState != -1)
{
where = where.And(p => p.AdTypeId == AdTypeState);
}
IPagedList <V_AD_type> list = ef.V_AD_type.Where(where).OrderByDescending(p => p.Adid).ToPagedList(pageNumber, pageSize);
ViewBag.adname = adname;
ViewBag.adstate = adstate;
ViewBag.AdTypeState = AdTypeState;
ViewBag.ddlType = ddlType;
return(View(list));
}
public ActionResult Index(int page = 1, int pgaesize = 10)
{
int pageIndex = page / 1;
string channelName = Utils.CheckSQLHtml(DNTRequest.GetString("ChannelName"));
Expression <Func <hx_Channel, bool> > where = PredicateExtensionses.True <hx_Channel>();
if (!string.IsNullOrEmpty(channelName))
{
where = where.And(p => p.ChannelName.Contains(channelName));
}
var list = ef.hx_Channel.Where(where).OrderByDescending(p => p.ChannelID).ToPagedList(pageIndex, pgaesize);
Dictionary <int, int> dictRegister = new Dictionary <int, int>(); //邀请注册总数
Dictionary <int, int> dictOrder = new Dictionary <int, int>(); //邀请注册下单总数
foreach (var item in list)
{
var count = ef.hx_member_table.Where(p => p.channel_invitedcode == item.Invitedcode).Count();
dictRegister.Add(item.ChannelID, count);
count = ef.V_Channel_Invite.Where(p => p.channel_invitedcode == item.Invitedcode).Count();
dictOrder.Add(item.ChannelID, count);
}
ViewBag.DictRegister = dictRegister;
ViewBag.DictOrder = dictOrder;
ViewBag.ChannelName = channelName;
return(View(list));
}
public List <PointPacketConfig> GetPointPacketConfigsList(ref DataPage dp)
{
Expression <Func <PointPacketConfig, bool> > exp = PredicateExtensionses.True <PointPacketConfig>();
List <PointPacketConfig> packetentrylist = GetEntityQueryList(ref dp, exp, p => p.ConfigId);
return(packetentrylist);
}
public JsonResult GetZCZNow()
{
int _userid = (int)Session["user_id"];
var _mc = Request["mc"] ?? "";
var _bh = Request["bh"] ?? "";
var _gg = Request["gg"] ?? "";
Expression <Func <base_shangpinzcz, bool> > where = PredicateExtensionses.True <base_shangpinzcz>();
if (string.IsNullOrEmpty(_mc) && string.IsNullOrEmpty(_bh) && string.IsNullOrEmpty(_gg))
{
return(Json(1));
}
if (!string.IsNullOrEmpty(_mc))
{
where = where.And(p => p.Mingcheng.Contains(_mc));
}
if (!string.IsNullOrEmpty(_bh))
{
where = where.And(p => p.Bianhao.Contains(_bh));
}
if (!string.IsNullOrEmpty(_gg))
{
var _gglist = ServiceFactory.base_zhucezhengggservice.LoadEntities(g => g.Guige.Contains(_gg)).ToList <base_zhucezhenggg>();
var _zidlist = from gg in _gglist
select(int) gg.ZCZID;
var _zid = _zidlist.Distinct().ToList();
where = where.And(p => _zid.Contains(p.ID));
}
where = where.And(p => p.ShixiaoSF == false && p.IsDelete == false);
var _zczlist = ob_base_shangpinzczservice.LoadSortEntities(where.Compile(), true, s => s.Bianhao);
return(Json(_zczlist.ToList <base_shangpinzcz>()));
}
public ActionResult Index(string username = "", int OrdIdState = -1, int ddlType = 3, int OrdIdState1 = -1, int Page = 1, int pageSize = 10)
{
Response.BufferOutput = true;
int pageNumber = Page / 1;
Expression <Func <V_UserCash_Bank, bool> > where = PredicateExtensionses.True <V_UserCash_Bank>();
where = where.And(p => p.UserCashId > 0);
if (ddlType != 3 && OrdIdState == -1)
{
OrdIdState = OrdIdState1;
}
if (!string.IsNullOrEmpty(username))
{
where = where.And(p => p.username.Contains(username));
}
if (OrdIdState >= 0)
{
where = where.And(p => p.OrdIdState == (OrdIdState));
}
IPagedList <V_UserCash_Bank> list = ef.V_UserCash_Bank.Where(where).OrderByDescending(p => p.UserCashId).ToPagedList(pageNumber, pageSize);
ViewBag.username = username;
ViewBag.OrdIdState = OrdIdState;
ViewBag.ddlType = ddlType;
ViewBag.OrdIdState1 = OrdIdState1;
return(View(list));
}
public List <TaskConfig> GetTaskConfig(ref DataPage dp)
{
Expression <Func <TaskConfig, bool> > exp = PredicateExtensionses.True <TaskConfig>();
List <TaskConfig> resultlist2 = ptx.GetEntityQueryList(ref dp, exp, p => p.TaskConfigId);
return(resultlist2);
}
public ActionResult Index(string contract_template_name = "", int contract_type_id = -1, int Page = 1, int pageSize = 10)
{
int pageNumber = Page / 1;
Expression <Func <V_contract_type_template, bool> > where = PredicateExtensionses.True <V_contract_type_template>();
where = where.And(p => p.contract_template_id > 0);
if (!String.IsNullOrEmpty(contract_template_name))
{
where = where.And(p => p.contract_template_name.Contains(contract_template_name));
}
if (contract_type_id >= 0)
{
where = where.And(p => p.contract_type_id == contract_type_id);
}
IPagedList <V_contract_type_template> list = ef.V_contract_type_template.Where(where).OrderByDescending(p => p.contract_template_id).ToPagedList(pageNumber, pageSize);
//IEnumerable<SelectListItem> list_ConType = ef.hx_contract_type.OrderByDescending(p => p.contract_type_id).Select(p => new SelectListItem { Value = p.contract_type_id.ToString(), Text = p.contract_type_name });
ViewBag.list_ConType = GetContractTypeList();
ViewBag.contract_template_name = contract_template_name;
ViewBag.contract_type_id = contract_type_id;
return(View(list));
}
private void SelectShere()
{
try
{
//if (expr == null)
//{
expr = PredicateExtensionses.True <RoleInfo>();
//}
string SearchName = txtSearchName.Text.Trim();
int i = 0;
if (SearchName != "")//根据角色名查询
{
//expr = expr.And(n => n.Role_Name == SearchName);
expr = expr.And(n => SqlMethods.Like(n.Role_Name, "%" + SearchName + "%"));
i++;
}
if (i == 0)
{
expr = null;
}
}
catch (Exception ex)
{
Common.WriteTextLog("UserRole.SelectShere()" + ex.Message.ToString());
}
finally
{
page = new PageControl();
page.PageMaxCount = tscbxPageSize2.SelectedItem.ToString();
LoadData();
}
}
public ActionResult Index(string activity_schedule_name = "", int reward = -1, int Page = 1, int pageSize = 10)
{
int pageNumber = Page / 1;
Expression <Func <hx_Activity_schedule, bool> > where = PredicateExtensionses.True <hx_Activity_schedule>();
where = where.And(p => p.activity_schedule_id > 0);
if (reward > -1)
{
where = where.And(p => p.reward == reward);
}
if (!string.IsNullOrEmpty(activity_schedule_name))
{
where = where.And(p => p.activity_schedule_name.Contains(activity_schedule_name));
}
IPagedList <hx_Activity_schedule> list = ef.hx_Activity_schedule.Where(where).OrderByDescending(p => p.activity_schedule_id).ToPagedList(pageNumber, pageSize);
ViewBag.activity_schedule_name = activity_schedule_name;
ViewBag.reward = reward;
ViewBag.page = Page;
return(View(list));
}
public ActionResult Index(string page)
{
if (string.IsNullOrEmpty(page))
page = "1";
int userid = (int)Session["user_id"];
string pagetag = "quan_zhiliangwh_index";
PageMenu.Set("Index", "quan_zhiliangwh", "质量管理");
Expression<Func<quan_zhiliangwh, bool>> where = PredicateExtensionses.True<quan_zhiliangwh>();
searchcondition sc = searchconditionService.GetInstance().GetEntityById(searchcondition => searchcondition.UserID == userid && searchcondition.PageBrief == pagetag);
if (sc != null && sc.ConditionInfo != null)
{
string[] sclist = sc.ConditionInfo.Split(';');
foreach (string scl in sclist)
{
string[] scld = scl.Split(',');
switch (scld[0])
{
case "chid":
string chid = scld[1];
string chidequal = scld[2];
string chidand = scld[3];
if (!string.IsNullOrEmpty(chid))
{
if (chidequal.Equals("="))
{
if (chidand.Equals("and"))
where = where.And(quan_zhiliangwh => quan_zhiliangwh.CHID == int.Parse(chid));
else
where = where.Or(quan_zhiliangwh => quan_zhiliangwh.CHID == int.Parse(chid));
}
if (chidequal.Equals(">"))
{
if (chidand.Equals("and"))
where = where.And(quan_zhiliangwh => quan_zhiliangwh.CHID > int.Parse(chid));
else
where = where.Or(quan_zhiliangwh => quan_zhiliangwh.CHID > int.Parse(chid));
}
if (chidequal.Equals("<"))
{
if (chidand.Equals("and"))
where = where.And(quan_zhiliangwh => quan_zhiliangwh.CHID < int.Parse(chid));
else
where = where.Or(quan_zhiliangwh => quan_zhiliangwh.CHID < int.Parse(chid));
}
}
break;
default:
break;
}
}
ViewBag.SearchCondition = sc.ConditionInfo;
}
where = where.And(quan_zhiliangwh => quan_zhiliangwh.IsDelete == false);
var tempData = ob_quan_zhiliangwhservice.LoadSortEntities(where.Compile(), false, quan_zhiliangwh => quan_zhiliangwh.ID).ToPagedList<quan_zhiliangwh>(int.Parse(page), int.Parse(System.Web.Configuration.WebConfigurationManager.AppSettings["ShowPerPage"]));
ViewBag.quan_zhiliangwh = tempData;
return View(tempData);
}
public ActionResult ChannelInvList(int page = 1, int pagesize = 10)
{
int pageIndex = page / 1;
string adminUserName = Utils.CheckSQLHtml(DNTRequest.GetString("AdminUserName"));
string channelName = Utils.CheckSQLHtml(DNTRequest.GetString("ChannelName"));
string ordId = Utils.CheckSQLHtml(DNTRequest.GetString("OrdId"));
string btitle = Utils.CheckSQLHtml(DNTRequest.GetString("BTitle"));
string startTime = DNTRequest.GetString("StartTime");
string endTime = DNTRequest.GetString("EndTime");
decimal orderid = 0;
decimal.TryParse(ordId, out orderid);
Expression <Func <V_Channel_Invite, bool> > where = PredicateExtensionses.True <V_Channel_Invite>();
if (!string.IsNullOrEmpty(channelName))
{
where = where.And(p => p.ChannelName.Contains(channelName));
}
if (!string.IsNullOrEmpty(adminUserName))
{
where = where.And(p => p.AdminUserName.Contains(adminUserName.Trim()));
}
if (!string.IsNullOrEmpty(ordId) && orderid > 0)
{
where = where.And(p => p.OrdId.ToString().Contains(ordId.Trim()));
}
if (!string.IsNullOrEmpty(btitle))
{
where = where.And(p => p.borrowing_title.Contains(btitle.Trim()));
}
if (!string.IsNullOrEmpty(startTime) && startTime != "")
{
DateTime stime = Convert.ToDateTime(startTime);
where = where.And(p => DbFunctions.DiffDays(p.invest_time, stime) <= 0);
DateTime etime = DateTime.Now;
if (!string.IsNullOrEmpty(endTime) && endTime != "")
{
etime = Convert.ToDateTime(endTime);
}
etime = etime.AddDays(1).AddSeconds(-1);
where = where.And(p => DbFunctions.DiffDays(p.invest_time, etime) >= 0);
}
var list1 = ef.V_Channel_Invite.Where(where).ToList();
var list2 = ef.V_Channel_Invite.Where(where).OrderByDescending(p => p.invest_time).ToList();
var list = ef.V_Channel_Invite.Where(where).OrderByDescending(p => p.invest_time).ToPagedList(pageIndex, pagesize);
ViewBag.AdminUserName = adminUserName;
ViewBag.ChannelName = channelName;
ViewBag.OrdId = ordId;
ViewBag.StartTime = startTime;
ViewBag.EndTime = endTime;
ViewBag.BTitle = btitle;
return(View(list));
}
private void UpdateQCDetailsForm_Load(object sender, EventArgs e)
{
//调用显示状态
BindState();
expr = (Expression <Func <View_QCRecordInfo, bool> >)PredicateExtensionses.True <View_QCRecordInfo>();
expr = n => n.QCInfo_ID == iqcinfoid;
//调用显示加载数据的方法(查看详情)
LoadData();
}
/// <summary>
/// 加载用户
/// </summary>
private void InitUser()
{
expr = PredicateExtensionses.True <UserInfo>();
expr = expr.And(n => n.UserLoginId != "emewe");
this.lvwUserList.AutoGenerateColumns = false;//设置只显示列表控件绑定的列
tscbxPageSize.SelectedIndex = 2;
//LoadData();
cmbRoleUserDate();
}
public JsonResult AUListExcel()
{
//导出已注册的用户列表
string adminUserName = Utils.CheckSQLHtml(DNTRequest.GetString("AdminUserName"));
string username = Utils.CheckSQLHtml(DNTRequest.GetString("UserName"));
string startTime = DNTRequest.GetString("StartTime");
string endTime = DNTRequest.GetString("EndTime");
Expression <Func <V_Channel_UserList, bool> > where = PredicateExtensionses.True <V_Channel_UserList>();
if (!string.IsNullOrEmpty(adminUserName))
{
where = where.And(p => p.AdminUserName.Contains(adminUserName.Trim()));
}
if (!string.IsNullOrEmpty(username))
{
where = where.And(p => p.username.Contains(username.Trim()));
}
if (!string.IsNullOrEmpty(startTime) && startTime != "")
{
DateTime stime = Convert.ToDateTime(startTime);
where = where.And(p => DbFunctions.DiffDays(p.registration_time, stime) <= 0);
DateTime etime = DateTime.Now;
if (!string.IsNullOrEmpty(endTime) && endTime != "")
{
etime = Convert.ToDateTime(endTime);
}
etime = etime.AddDays(1).AddSeconds(-1);
where = where.And(p => DbFunctions.DiffDays(p.registration_time, etime) >= 0);
}
var list = ef.V_Channel_UserList.Where(where).OrderByDescending(p => p.registration_time).ToList();
var dt = new DataTable();
#region List TO DataTable
dt.Columns.Add("编号", typeof(string));
dt.Columns.Add("渠道使用者", typeof(string));
dt.Columns.Add("被邀请账号", typeof(string));
dt.Columns.Add("被邀请真实姓名", typeof(string));
dt.Columns.Add("注册时间", typeof(string));
foreach (var item in list)
{
DataRow dr = dt.NewRow();
dr[0] = item.ID.ToString();
dr[1] = item.AdminUserName;
dr[2] = item.username;
dr[3] = item.realname;
dr[4] = item.registration_time;
dt.Rows.Add(dr);
}
#endregion
string url = Extensions.ExportExcel(dt);
var result = new { state = 1, msg = "投资列表导出完成！", data = url };
if (string.IsNullOrEmpty(url))
{
result = new { state = 0, msg = "导出数据为空！", data = string.Empty };
}
return(Json(result));
}
/// <summary>
/// 搜索待检测记录条件
/// </summary>
private void GetDgvDictionarySeacher()
{
try
{
var i = 0;
if (expr == null)
{
expr = (Expression <Func <Dictionary, bool> >)PredicateExtensionses.True <Dictionary>();
}
if (!string.IsNullOrEmpty(cbxDictionary_State.Text))
{
if (cbxDictionary_State.Text == "启动")
{
expr = expr.And(n => n.Dictionary_State == true);
}
else
{
expr = expr.And(n => n.Dictionary_State == false);
}
i++;
}
if (!string.IsNullOrEmpty(txtDictionary_Value.Text))
{
expr = expr.And(n => n.Dictionary_Value == txtDictionary_Value.Text.Trim());
i++;
}
if (!string.IsNullOrEmpty(txtDictionary_Name.Text))
{
expr = expr.And(n => n.Dictionary_Name == txtDictionary_Name.Text.Trim());
i++;
}
if (cbxDictionary_OtherID.SelectedIndex >= 0)
{
int itemid = Converter.ToInt(cbxDictionary_OtherID.SelectedValue.ToString());
if (itemid > 0)
{
expr = expr.And(n => n.Dictionary_OtherID == itemid);
}
i++;
}
if (!string.IsNullOrEmpty(txtDictionary_Remark.Text))
{
expr = expr.And(n => n.Dictionary_Remark == txtDictionary_Remark.Text.Trim());
i++;
}
if (i == 0)
{
expr = null;
}
}
catch (Exception ex)
{
Common.WriteTextLog("DictionaryAdmin.GetDgvDictionarySeacher异常:" + ex.Message.ToString());
}
}
/// <summary>
/// 搜索
/// </summary>
private void selectTJ()
{
try
{
//if (expr == null)
//{
//expr = PredicateExtensionses.True<View_UserInfo_D_R_d>();
expr = (Expression <Func <View_UserInfo2_D_R_d, bool> >)PredicateExtensionses.True <View_UserInfo2_D_R_d>();
//}
int i = 0;
//if (txtSearchId.Text.Trim() != "")//用户名
//{
// //expr = expr.And(n => n.UserLoginId == txtSearchId.Text.Trim());
// expr = expr.And(n => SqlMethods.Like(n.UserLoginId, "%" + txtSearchId.Text.Trim() + "%") && n.UserLoginId != "emewe");
// i++;
//}
if (txt_Name.Text.Trim() != "")//真实姓名
{
//expr = expr.And(n => n.UserName == txt_Name.Text.Trim());
expr = expr.And(n => SqlMethods.Like(n.UserName, "%" + txt_Name.Text.Trim() + "%"));
i++;
}
if (cobDuty_Name2.SelectedValue != "") //职位
{
expr = expr.And(n => SqlMethods.Like(n.Duty_Name, "%" + cobDuty_Name2.Text.Trim() + "%"));
i++;
}
//if (cmbSearchRole.Text != "")//角色
//{
// expr = expr.And(n => n.Role_Name == cmbSearchRole.Text && n.UserLoginId != "emewe");
// i++;
//}
//if (i == 0)
//{
// expr = expr.And(n => n.UserLoginId != "emewe");
//}
}
catch (Exception ex)
{
Common.WriteTextLog("用户管理 selectTJ()" + ex.Message.ToString());
}
finally
{
page = new PageControl();
page.PageMaxCount = tscbxPageSize2.SelectedItem.ToString();
LoadData();
}
}
private void LoadData(string strName)
{
if (expr == null)
{
expr = (Expression <Func <idebarJoinU9, bool> >)PredicateExtensionses.True <idebarJoinU9>();
}
if (txtPRODID2.Text != "")
{
expr = expr.And(n => SqlMethods.Like(n.idebarJoinU9_PROD_ID, "%" + txtPRODID2.Text.Trim() + "%"));
}
dgvView_WaterSet.AutoGenerateColumns = false;
dgvView_WaterSet.DataSource = page.BindBoundControl <idebarJoinU9>(strName, txtCurrentPage1, lblPageCount1, expr, "idebarJoinU9_id");
}
public ActionResult InvalidInvst()
{
Expression <Func <V_Bid_records_Lost, bool> > where = PredicateExtensionses.True <V_Bid_records_Lost>();
where = where.And(p => p.bid_records_id > 0);
//清理10分钟之前的无效标的
DateTime dt2 = DateTime.Now.AddMinutes(-10);
where = where.And(a => ((DateTime)a.invest_time) <= dt2);
List <V_Bid_records_Lost> list = ef.V_Bid_records_Lost.Where(where).AsNoTracking().ToList();
foreach (V_Bid_records_Lost item in list)
{
setRecords_Lost(item.investor_registerid.ToString(), item.bid_records_id.ToString(), item.OrdId.ToString(), DateTime.Parse(item.invest_time.ToString()).ToString("yyyyMMdd"), item.UsrCustId.ToString(), item.FrozenidNo, item.investment_amount.ToString(), item.FreezeTrxId == null ? "" : item.FreezeTrxId.ToString(), "", "TENDER");
}
return(Content("远程调用成功"));
}
public PagingOutput <Accounts> GetPageList(GetPageListInput input)
{
return(AutofacConfig.Resolve <AccountsRepository>().GetPageList(
input.PageIndex,
input.PageSize,
PredicateExtensionses.True <Accounts>().AndIf(a => a.LoginAccount == input.LoginAccount, !string.IsNullOrWhiteSpace(input.LoginAccount))
.AndIf(a => a.LoginName.Contains(input.LoginName), !string.IsNullOrWhiteSpace(input.LoginName))
.And(a => a.IsDeleted == input.IsDeleted)
.AndIf(a => a.Email == input.Email, !string.IsNullOrWhiteSpace(input.Email))
.AndIf(a => a.CreateTime >= input.CreateTimeBegin.Value, input.CreateTimeBegin.HasValue)
.AndIf(a => a.CreateTime < input.CreateTimeEnd.Value, input.CreateTimeEnd.HasValue)
.AndIf(a => a.DeleteTime >= input.DeleteTimeBegin.Value, input.DeleteTimeBegin.HasValue)
.AndIf(a => a.DeleteTime < input.DeleteTimeEnd.Value, input.DeleteTimeEnd.HasValue),
a => a.CreateTime,
true
));
}
private void Search()
{
Expression <Func <MODEL.GoodsInfo, bool> > where = PredicateExtensionses.True <MODEL.GoodsInfo>();
if (!string.IsNullOrWhiteSpace(strGiEncoder))
{
where = where.And(u => u.GIEncoder == strGiEncoder);
}
if (!string.IsNullOrWhiteSpace(strGiName))
{
where = where.And(u => u.GIName == strGiName);
}
if (!string.IsNullOrWhiteSpace(strGiSize))
{
where = where.And(u => u.GISize == strGiSize);
}
GoodsInfoList = bllGoodsInfo.GetListBy(where);
}
public ActionResult AdminUserList(int page = 1, int pagesize = 10)
{
//渠道用户非,非后台登录用户
hx_Channel_AdminUser adminUser = Session["Channel_AdminUser"] as hx_Channel_AdminUser;
//判定用户
if (adminUser == null)
{
return(RedirectToAction("LoginOut", "Channel"));
}
int pageIndex = page / 1;
string realname = Utils.CheckSQLHtml(DNTRequest.GetString("RealName"));
string username = Utils.CheckSQLHtml(DNTRequest.GetString("UserName"));
string startTime = DNTRequest.GetString("StartTime");
string endTime = DNTRequest.GetString("EndTime");
Expression <Func <V_Channel_UserList, bool> > where = PredicateExtensionses.True <V_Channel_UserList>();
where = where.And(p => p.AdminUserName == adminUser.AdminUserName);
if (!string.IsNullOrEmpty(realname))
{
where = where.And(p => p.realname.Contains(realname.Trim()));
}
if (!string.IsNullOrEmpty(username))
{
where = where.And(p => p.username.Contains(username.Trim()));
}
if (!string.IsNullOrEmpty(startTime) && startTime != "")
{
DateTime stime = Convert.ToDateTime(startTime);
where = where.And(p => DbFunctions.DiffDays(p.registration_time, stime) <= 0);
DateTime etime = DateTime.Now;
if (!string.IsNullOrEmpty(endTime) && endTime != "")
{
etime = Convert.ToDateTime(endTime);
}
etime = etime.AddDays(1).AddSeconds(-1);
where = where.And(p => DbFunctions.DiffDays(p.registration_time, etime) >= 0);
}
var list = ef.V_Channel_UserList.Where(where).OrderByDescending(p => p.registration_time).ToPagedList(pageIndex, pagesize);
ViewBag.Username = username;
ViewBag.RealName = realname;
ViewBag.StartTime = startTime;
ViewBag.EndTime = endTime;
return(View(list));
}
public Expression <Func <T, bool> > CreateDydaminWhereAndExpression <T>(T querymodel) where T : class
{
Expression <Func <T, bool> > finalexpression = PredicateExtensionses.True <T>();
if (querymodel == null)
{
return(finalexpression);
}
Type t = querymodel.GetType();
PropertyInfo[] properties = t.GetProperties();
foreach (PropertyInfo item in properties)
{
object value = item.GetValue(querymodel, null);
if (value != null)
{
Type valuetype = value.GetType();
if (valuetype != typeof(Int32) && valuetype != typeof(Int64))
{
if (valuetype == typeof(DateTime) && (DateTime)value != DateTime.Parse("1900/1/1 0:00:00") && (DateTime)value != default(DateTime))
{
DateTime startdate = DateTime.Parse(Convert.ToDateTime(value).ToShortDateString());
DateTime enddate = startdate.AddDays(1);
Expression <Func <T, bool> > startexpression = ExpressionOperator.CreateCompareExpression <T>(item.Name, startdate, "greaterthanorequal");
Expression <Func <T, bool> > endexpression = ExpressionOperator.CreateCompareExpression <T>(item.Name, enddate, "lessthan");
finalexpression = finalexpression.And <T>(startexpression).And <T>(endexpression);
}
if (valuetype != typeof(DateTime) && valuetype != typeof(Boolean))
{
Expression <Func <T, bool> > currentexpression = ExpressionOperator.CreateCompareExpression <T>(item.Name, value);
finalexpression = finalexpression.And <T>(currentexpression);
}
}
else
{
long convervalue = Convert.ToInt64(value);
if (convervalue != 0)
{
Expression <Func <T, bool> > currentexpression = ExpressionOperator.CreateCompareExpression <T>(item.Name, value);
finalexpression = finalexpression.And <T>(currentexpression);
}
}
}
}
return(finalexpression);
}
/// <summary>
/// 加载用户
/// </summary>
private void InitUser()
{
expr = PredicateExtensionses.True <View_UserInfo2_D_R_d>();
// expr = expr.And(n => n.UserLoginId != "emewe");
this.lvwUserList.AutoGenerateColumns = false;//设置只显示列表控件绑定的列
LoadData();
bingcob_Duty_Name();
bingcob_QCGroup_Name(cbxState);
// bingcob_QCGroup_Name(cmbSearchRole);
btnUpUser.Visible = false;
btnUserCancle.Visible = false;
mf = new MainFrom();
if (btnAdd.Visible)
{
rbool = true;
}
}
public ActionResult Index(string page)
{
if (string.IsNullOrEmpty(page))
{
page = "1";
}
string zhanghao = Request["zhanghao"] ?? "";
string zhanghaoequal = Request["zhanghaoequal"] ?? "";
string zhanghaoand = Request["zhanghaoand"] ?? "";
Expression <Func <base_yonghu, bool> > where = PredicateExtensionses.True <base_yonghu>();
if (!string.IsNullOrEmpty(zhanghao))
{
if (zhanghaoequal.Equals("="))
{
if (zhanghaoand.Equals("and"))
{
where = where.And(base_yonghu => base_yonghu.Zhanghao == zhanghao);
}
else
{
where = where.Or(base_yonghu => base_yonghu.Zhanghao == zhanghao);
}
}
if (zhanghaoequal.Equals("like"))
{
if (zhanghaoand.Equals("and"))
{
where = where.And(base_yonghu => base_yonghu.Zhanghao.Contains(zhanghao));
}
else
{
where = where.Or(base_yonghu => base_yonghu.Zhanghao.Contains(zhanghao));
}
}
}
where = where.And(base_yonghu => base_yonghu.IsDelete == false);
var tempData = ob_base_yonghuservice.LoadSortEntities(where.Compile(), false, base_yonghu => base_yonghu.ID).ToPagedList <base_yonghu>(int.Parse(page), int.Parse(System.Web.Configuration.WebConfigurationManager.AppSettings["ShowPerPage"]));
ViewBag.base_yonghu = tempData;
return(View(tempData));
}
