/// <summary>
/// 根据用户登陆名,获取用户资料
/// </summary>
/// <param name="u_LoginName">用户名</param>
/// <returns>用户实体类</returns>
public static sys_UserTable Get_sys_UserTable1(string u_LoginName)
{
QueryParam qp = new QueryParam();
qp.Where = string.Format(" Where U_LoginName='{0}' ", u_LoginName);
int rInt = 0;
if (BusinessFacade.sys_UserList(qp, out rInt).Count > 0)
{
return(BusinessFacade.sys_UserList(qp, out rInt)[0] as sys_UserTable);
}
else
{
return(null);
}
}
/// <summary>
/// 绑定数据
/// </summary>
private void BindDataList()
{
QueryParam qp = new QueryParam();
qp.Where = SearchTerms;
qp.PageIndex = AspNetPager1.CurrentPageIndex;
qp.PageSize = AspNetPager1.PageSize;
qp.Orderfld = Orderfld;
qp.OrderType = OrderType;
DataSet ds = BusinessFacadeDLT.OrderList(qp);
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
this.AspNetPager1.RecordCount = Convert.ToInt32(ds.Tables[1].Rows[0]["RecordCount"]);
}
private void ListBind()
{
QueryParam qp = new QueryParam();
qp.Where = SearchTerms;
qp.PageIndex = AspNetPager1.CurrentPageIndex;
qp.PageSize = AspNetPager1.PageSize;
qp.Orderfld = Orderfld;
qp.OrderType = OrderType;
int RecordCount = 0;
ArrayList lst = BusinessFacade.sys_EventList(qp, out RecordCount);
GridView1.DataSource = lst;
GridView1.DataBind();
this.AspNetPager1.RecordCount = RecordCount;
}
protected void BindDataList()
{
QueryParam qp = new QueryParam();
qp.Where = string.Format(" Where E_U_LoginName='{0}' and E_Type=2", UserData.GetUserDate.U_LoginName);
qp.PageIndex = AspNetPager1.CurrentPageIndex;
qp.PageSize = AspNetPager1.PageSize;
qp.Orderfld = Orderfld;
qp.OrderType = OrderType;
int RecordCount = 0;
ArrayList lst = BusinessFacade.sys_EventList(qp, out RecordCount);
GridView1.DataSource = lst;
GridView1.DataBind();
this.AspNetPager1.RecordCount = RecordCount;
}
/// <summary>
/// 绑定活动
/// </summary>
private void BindActivity()
{
QueryParam qp = new QueryParam();
qp.OrderType = 0;
qp.Orderfld = "Sort";
int RecordCount = 0;
qp.Where = " Where 1=1";
List <tsActivityEntity> lst = BusinessFacadeDLT.tsActivityList(qp, out RecordCount);
foreach (tsActivityEntity var in lst)
{
ddlActivity.Items.Add(new ListItem(var.Name, var.ID.ToString()));
}
}
public string GetUID(string ID)
{
if (ID != "0")
{
QueryParam qp = new QueryParam();
qp.OrderType = 0;
int RecordCount = 0;
qp.Where = " Where [ID]=" + ID;
List <tsUserEntity> lst = BusinessFacadeDLT.tsUserList(qp, out RecordCount);
return(lst[0].UID);
}
else
{
return("");
}
}
/// <summary>
/// 绑定数据
/// </summary>
private void BindDataList()
{
QueryParam qp = new QueryParam();
qp.Where = SearchTerms;
qp.PageIndex = AspNetPager1.CurrentPageIndex;
qp.PageSize = AspNetPager1.PageSize;
qp.Orderfld = Orderfld;
qp.OrderType = OrderType;
int RecordCount = 0;
List <tbImgEntity> lst = BusinessFacadeDLT.tbImgList(qp, out RecordCount);
GridView1.DataSource = lst;
GridView1.DataBind();
this.AspNetPager1.RecordCount = RecordCount;
}
/// <summary>
/// 4 项信息+人像 0x42
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public ResultModelDto GetFourAndFace(GetFourAndFaceInput input)
{
var queryParam = new QueryParam
{
name = input.Name,
idcard = input.IdCardNo,
beginDate = input.UserLifeBegin.ToString("yyyyMMdd"),
endDate = input.UserLifeEnd.ToString("yyyyMMdd"),
cammerPhoto = input.PhotoBuffer,
recogCode = Ctid.RecoRequestMode.Nine
};
ResultModelDto result = OnlineFr(queryParam);
return(result);
}
private void BindDataList5(string ID)
{
QueryParam qp = new QueryParam();
//qp.Where = SearchTerms;
qp.PageIndex = AspNetPager6.CurrentPageIndex;
qp.PageSize = AspNetPager6.PageSize;
int RecordCount = 0;
//DataSet ds = BusinessFacadeDLT.UserListByMAC(ID, qp.PageIndex, qp.PageSize);
DataSet ds = SqlHelper.ExecuteDataset(ConfigurationManager.AppSettings["MSSql"], "BM_UserListByMAC", ID, 5, qp.PageIndex, qp.PageSize);
GridView6.DataSource = ds.Tables[0];
GridView6.DataBind();
RecordCount = int.Parse(ds.Tables[1].Rows[0][0].ToString());
this.AspNetPager6.RecordCount = RecordCount;
}
private void BindDataList1()
{
QueryParam qp = new QueryParam();
qp.Where = SearchTerms1;
qp.PageIndex = AspNetPager2.CurrentPageIndex;
qp.PageSize = AspNetPager2.PageSize;
int RecordCount = 0;
DataSet ds = BusinessFacadeDLT.ActivityAllOrderSelect(qp.PageIndex, qp.PageSize, qp.Where);
GridView2.DataSource = ds.Tables[0];
GridView2.DataBind();
RecordCount = int.Parse(ds.Tables[1].Rows[0][0].ToString());
this.AspNetPager2.RecordCount = RecordCount;
}
/// <summary>
/// 人像+网证
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public ResultModelDto GetFaceAndWz(GetFaceAndWzInput input)
{
var queryParam = new QueryParam
{
authCode = input.AuthCode,
cammerPhoto = input.PhotoBuffer,
CtidIndex = @"B19FABEA60504FB65F3AA087ED0CE155239A7D8EF9D1BC694F31D0B78E0C48B9.wzMIIB1gYKKoEcz1UGAQQCA6CCAcYwggHCAgEAMYHPMIHMAgEAMD0wMTELMAkGA1UEBhMCQ04xETAPBgNVBAoTCEdMQ1RJRDAxMQ8wDQYDVQQDEwZHTENBMDECCH96wSriUCnPMAsGCSqBHM9VAYItAwR7MHkCIQCVeCUcHBGOzwAN0pKxTunD9+UHNkPJjUbndZ3t6jdvCwIgCaA8VqaEYlLRVtnn7jByr+spvhwOCZWdBVQFodkIkoMEII0IOGOVpZNvpRk4zHbGdzwU/oaXGcOExXMUHzrIOQ24BBAwXnXFmBjPgn2UfrF+7pFAMIHqBgoqgRzPVQYBBAIBMAkGByqBHM9VAWiAgdDG6iMWZAszwVYSX2WRT7O7SbaMAxRFYTg1Sp+OxRUr2OZPjDWKAwysLBEB2sMYCprFLEgDk2h+ZTPSz2LQbhY8xuojFmQLM8FWEl9lkU+zu8bqIxZkCzPBVhJfZZFPs7vG6iMWZAszwVYSX2WRT7O7xuojFmQLM8FWEl9lkU+zu8bqIxZkCzPBVhJfZZFPs7vG6iMWZAszwVYSX2WRT7O7xuojFmQLM8FWEl9lkU+zu8bqIxZkCzPBVhJfZZFPs7vGo0se/hleDHuUPAiPpASA",
CtidInfo = @"AwCxn6vqYFBPtl86oIftDOFVI5p9jvnRvGlPMdC3jgxIuTIwMTgwMTIyMTIxMzMzMTQ5AQFsUYlb6JAsewBOFHh2ekBiACAAIAAgACAAIAAgACAyADAAMQA4ADAAMQAyADIAMgAwADMAMQAwADIAMQA1AAjPuPOn8hbjDIX3VHYQu7uiQBJVB83QZT9UA8Kiea9asZ+r6mBQT7ZfOqCH7QzhVSOafY750bxpTzHQt44MSLlQEj+4ml0s19KyUxEAlNyoD/nl80cw0sK2CT22/a6rYQABMEQCIEvGvRzkjuZbxYwLRpm0YCGGnMDPEEn/Sy8XRJrCOeJLAiAUTeZTOkaBzHGlzv1cARcrqsMIboC3sIDti6NXUtKMxwAA",
recogCode = Ctid.RecoRequestMode.Six
};
ResultModelDto result = OnlineFr(queryParam);
return(result);
}
/// <summary>
/// 绑定数据
/// </summary>
private void BindDataList()
{
QueryParam qp = new QueryParam();
qp.Where = SearchTerms;
qp.PageIndex = AspNetPager1.CurrentPageIndex;
qp.PageSize = AspNetPager1.PageSize;
int RecordCount = 0;
DataSet ds = BusinessFacadeDLT.GetRecharge(qp.PageIndex, qp.PageSize, qp.Where);
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
RecordCount = int.Parse(ds.Tables[1].Rows[0][0].ToString());
this.AspNetPager1.RecordCount = RecordCount;
lblTotalRecharge.Text = "当前查询条件下总充值金额：" + ds.Tables[2].Rows[0][0].ToString() + "元";
}
public string AcceptUserID(string acceptuserid)
{
if (acceptuserid != "0")
{
QueryParam qp = new QueryParam();
qp.OrderType = 0;
int RecordCount = 0;
qp.Where = " Where [ID]=" + acceptuserid;
List <tsUserEntity> lst = BusinessFacadeDLT.tsUserList(qp, out RecordCount);
return(lst[0].Nickname);
}
else
{
return("");
}
}
public void BindStatus()
{
QueryParam qp = new QueryParam();
qp.OrderType = 0;
int RecordCount = 0;
qp.Where = " Where [Key]=1011";
List <tsDictEntity> lst = BusinessFacadeDLT.tsDictList(qp, out RecordCount);
foreach (tsDictEntity var in lst)
{
ddlStatus.Items.Add(new ListItem(var.Value, var.Kind.ToString()));
}
}
/// <summary>
/// 构造函数
/// </summary>
static FrameSystemInfo()
{
if (GetSystemInfoTable == null)
{
sys_SystemInfoTable si = new sys_SystemInfoTable();
QueryParam qp = new QueryParam();
qp.PageIndex = 1;
qp.PageSize = 1;
qp.OrderType = 0;
int Recount = 0;
ArrayList lst = BusinessFacade.sys_SystemInfoList(qp, out Recount);
if (Recount == 0)
{
si.DB_Option_Action_ = "Insert";
si.SystemID = BusinessFacade.sys_SystemInfoInsertUpdate(si);
}
else
{
si = lst[0] as sys_SystemInfoTable;
//更新新加配置
sys_ConfigDataTable sys_ConfigDB = si.S_SystemConfigData;
sys_ConfigDataTable sys_Config = new sys_ConfigDataTable();
//foreach (PropertyInfo pi in new sys_ConfigDataTable().GetType().GetProperties(BindingFlags.Public | BindingFlags.NonPublic | BindingFlags.Instance))
foreach (PropertyInfo pi in sys_ConfigDB.GetType().GetProperties(BindingFlags.Public | BindingFlags.NonPublic | BindingFlags.Instance))
{
if (pi.GetValue(sys_ConfigDB, null) == null)
{
pi.SetValue(sys_ConfigDB, pi.GetValue(sys_Config, null), null);
}
}
//从Dll中更新版本
//sys_FrameWorkInfoTable sys_Db = si.S_FrameWorkInfo;
//sys_FrameWorkInfoTable sys_Dll = new sys_FrameWorkInfoTable();
//foreach (PropertyInfo pi in sys_Db.GetType().GetProperties(BindingFlags.Public | BindingFlags.NonPublic | BindingFlags.Instance))
//{
// if (pi.Name != "S_Licensed")
// {
// pi.SetValue(sys_Db, pi.GetValue(sys_Dll, null), null);
// }
//}
}
GetSystemInfoTable = si;
}
FrameWorkPermission.InitStat = true;
}
public async Task <OperateStatus> ReportExcelExceptionLogQuery(QueryParam paging,
ExcelReportDto excelReportDto)
{
var operateStatus = new OperateStatus();
try
{
//获取总共条数
//paging.Rows =await Count();
//组装数据
//IList<SystemExceptionLog> dtos = (await _exceptionLogRepository.PagingQueryProcAsync(paging)).Data.ToList();
var tables = new Dictionary <string, DataTable>(StringComparer.OrdinalIgnoreCase);
//组装需要导出数据
//var dt = new DataTable("ExceptionLog");
//dt.Columns.Add("Num");
//dt.Columns.Add("OperateTime");
//dt.Columns.Add("Code");
//dt.Columns.Add("Message");
//dt.Columns.Add("RequestUrl");
//dt.Columns.Add("ClientHost");
//var num = 1;
//if (dtos.Any())
//{
// foreach (var dto in dtos)
// {
// var row = dt.NewRow();
// dt.Rows.Add(row);
// row[0] = num;
// row[1] = dto.CreateTime;
// row[2] = dto.CreateUserCode;
// row[3] = dto.Message;
// row[4] = dto.RequestUrl;
// row[5] = dto.ClientHost;
// num++;
// }
//}
//tables.Add(dt.TableName, dt);
//OpenXmlExcel.ExportExcel(excelReportDto.TemplatePath, excelReportDto.DownPath, tables);
operateStatus.ResultSign = ResultSign.Successful;
}
catch (Exception)
{
operateStatus.ResultSign = ResultSign.Error;
}
return(operateStatus);
}
private void OnStart()
{
sys_GroupTable gt = BusinessFacade.sys_GroupDisp(GroupID);
this.G_CName.Text = gt.G_CName;
if (gt.G_ParentID == 0)
{
G_ParentID_Txt.Text = "部门列表";
}
else
{
G_ParentID_Txt.Text = BusinessFacade.sys_GroupDisp(gt.G_ParentID).G_CName;
}
CatListTitle.Text = string.Format("<a href='GroupList.aspx'>部门列表</a>{0}", BusinessFacade.GetGroupTitle(GroupID));
//判断是否删除
if (CMD == "Delete")
{
FrameWorkPermission.CheckPermissionVoid(PopedomType.Delete);
//删除子分类
DeleteCat(GroupID);
//删除当前分类
BusinessFacade.Update_Table_Fileds("sys_Group", "G_Delete=1", string.Format("GroupID={0}", GroupID));
if (gt.G_ParentID != 0)
{
//更新父类子类数
BusinessFacade.Update_Table_Fileds("sys_Group", "G_ChildCount=G_ChildCount-1", string.Format("GroupID={0}", gt.G_ParentID));
//更新父类子类排序
int RecordCount = 0;
QueryParam qp = new QueryParam();
qp.Where = string.Format("Where G_ParentID={0} and G_Delete=0", gt.G_ParentID);
qp.Orderfld = "G_Level,G_ShowOrder";
qp.OrderType = 0;
ArrayList lst = BusinessFacade.sys_GroupList(qp, out RecordCount);
RecordCount = 1;
foreach (sys_GroupTable var in lst)
{
BusinessFacade.Update_Table_Fileds("sys_Group", string.Format("G_ShowOrder={0}", RecordCount), string.Format("GroupID={0}", var.GroupID));
RecordCount++;
}
}
EventMessage.MessageBox(1, "操作成功", string.Format("删除部门({0})成功!", gt.G_CName), Icon_Type.OK, Common.GetHomeBaseUrl("GroupList.aspx"), Common.BuildJs);
}
}
protected void Button6_Click(object sender, EventArgs e)
{
if (txtGLNumStart.Text != "" && txtGLNumEnd.Text != " ")
{
if (IsValidate(txtGLNumStart.Text) && IsValidate(txtGLNumEnd.Text))
{
QueryParam qp = new QueryParam();
qp.PageIndex = AspNetPager1.CurrentPageIndex;
qp.PageSize = AspNetPager1.PageSize;
DataSet ds = null;
ds = BusinessFacadeDLT.UserGLCount(ddlGLGameID.SelectedValue, txtGLNumStart.Text, txtGLNumEnd.Text, DateTime.Parse(TextBox2.Text), DateTime.Parse(TextBox3.Text), 1, 1000000, ddlOrderType.SelectedValue);
if ((ds != null) && (ds.Tables[0].Rows.Count > 0))
{
Random rd = new Random();
int rd1 = rd.Next(111111, 999999);
string path = this.Server.MapPath("~\\Public\\Execl\\") + DateTime.Now.ToString("yyyyMMddhhmmss") + rd1.ToString() + ".xls";
if (!Directory.Exists(this.Server.MapPath("~\\Public\\Execl\\")))
{
Directory.CreateDirectory(this.Server.MapPath("~\\Public\\Execl\\"));
}
bool status = ExportExcel(ds, path);
string Redirectpath = "~\\Public\\Execl\\" + path.Substring(path.LastIndexOf("\\") + 1);
if (status)
{
Response.Redirect(Redirectpath);
File.Delete(path);
}
else
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('生成Excel失败！')", true);
}
}
}
else
{
Response.Write("<script language='javascript'>alert('下家接单数必须为正整数！');</script>");
return;
}
}
else
{
Response.Write("<script language='javascript'>alert('下家接单数范围不能为空！');</script>");
return;
}
}
/// <summary>
/// 绑定数据
/// </summary>
private void BindDataList()
{
QueryParam qp = new QueryParam();
SearchTerms = " where FieldsID=" + Request.QueryString["ID"];
qp.Where = SearchTerms;
qp.PageIndex = AspNetPager1.CurrentPageIndex;
qp.PageSize = AspNetPager1.PageSize;
qp.Orderfld = Orderfld;
qp.OrderType = OrderType;
int RecordCount = 0;
List <tbValuesEntity> lst = BusinessFacadeDLT.tbValuesList(qp, out RecordCount);
GridView1.DataSource = lst;
GridView1.DataBind();
this.AspNetPager1.RecordCount = RecordCount;
}
public IEnumerable <TransactionViewModel> Get([FromQuery] QueryParam param)
{
try
{
var currency = param.Currency;
var dateFrom = param.DateFrom;
var dateTo = param.DateTo;
var status = param.Status;
return(_transactionService.GetTransactions(currency, dateFrom, dateTo, status));
}
catch (Exception ex)
{
_logger.LogError(ex, ex.Message);
throw;
}
}
/// <summary>
/// Runs the list statement.
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="session">The session.</param>
/// <param name="statementName">Name of the statement.</param>
/// <param name="paramArray">The param array.</param>
/// <param name="inputParams">The input params.</param>
/// <returns></returns>
public IList <T> RunListStatement <T>(ISession session, string statementName, QueryParam[] paramArray, params object[] inputParams)
{
if (paramArray == null)
{
paramArray = new QueryParam[] { }
}
;
var inObjects = new Dictionary <string, object>();
var statement = PrepareStatement(session, statementName, inObjects, inputParams);
var parameters = BuildParameterArray(statement, paramArray, inObjects);
return(RunListStatementInternal <T>(statement, session, parameters));
}
#endregion
}
private void BindDataList()
{
int RecordCount = 0;
QueryParam qp = new QueryParam();
qp.PageIndex = AspNetPager1.CurrentPageIndex;
qp.PageSize = AspNetPager1.PageSize;
DataSet ds = BusinessFacadeDLT.BankTransferDetailList(DateTime.Parse(S_dtDate_Input.Text), DateTime.Parse(E_dtDate_Input.Text), ddlType.SelectedValue, txtTypeKeywords.Text, ddlResult.SelectedValue, qp.PageIndex, qp.PageSize);
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
RecordCount = int.Parse(ds.Tables[1].Rows[0][0].ToString());
string SPayOut = ds.Tables[2].Rows[0][0].ToString();
lbStatistics.InnerText = "当前查询条件下总汇款金额：" + SPayOut + "元";
this.AspNetPager1.RecordCount = RecordCount;
}
/// <summary>
/// 提交认证。正确保存结果并提示返回信息，错误不保存并提示
/// </summary>
/// <param name="qp"></param>
private ResultModelDto OnlineFr(QueryParam qp)
{
var ctid = new Qxd.Sdk.Ctid2.Ctid(new InitSetParam());
var recogModel = new CtidRecogModel();
var resultModel = ctid.GetCtidRecogModel(qp, ref recogModel);
//如果错误
if (resultModel.ResultCode != 0)
{
Logger.Info("认证失败: " + qp);
return(ObjectMapper.Map <ResultModelDto>(resultModel));
}
//成功就把结果写入数据库
try
{
var ctidRecog = new CtidRecog
{
CustomerNo = recogModel.CustomerNO,
AppName = recogModel.AppName,
TerminalNo = recogModel.TerminalNO,
TimeStamp = recogModel.TimeStamp,
BusinessSerialNumber = recogModel.BusinessSerialNumber,
ResultCode = recogModel.ResultCode,
ResultMessage = recogModel.ResultMessage,
AuthResult = recogModel.AuthResult,
Similarity = recogModel.Similarity,
ReservedData = recogModel.ReservedData
};
//var ctidRecog = ObjectMapper.Map<CtidRecog>(recogModel);
_ctidRecogRepository.Insert(ctidRecog);//插入到数据库
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
return(ObjectMapper.Map <ResultModelDto>(resultModel));
}
public string NickName(string id)
{
if (ID != "0")
{
QueryParam qp = new QueryParam();
qp.OrderType = 0;
int RecordCount = 0;
qp.Where = " Where ID=" + id;
List <tsUserEntity> lst = BusinessFacadeDLT.tsUserList(qp, out RecordCount);
return(lst[0].Nickname);
}
else
{
return("");
}
}
private static string joinParams(Dictionary <string, string> pars)
{
var result = new List <Tuple <string, string> >();
foreach (var paramName in pars.Keys)
{
var paramContent = pars[paramName];
var values = paramContent.Split(',');
foreach (var value in values)
{
result.Add(new Tuple <string, string>(paramName, value));
}
}
return(QueryParam.Join(result));
}
private async Task <List <ChatMessageModel> > DownloadMessages(DateTime earliestTime, DateTime latestTime)
{
var currentUniversalTime = DateTime.UtcNow;
var currentLocalTime = DateTime.Now;
var difference = currentUniversalTime - currentLocalTime;
var correctedEarlyTime = earliestTime.Add(difference);
var correctedLatestTime = latestTime.Add(difference);
var earliestParam = new QueryParam("earliestTime", correctedEarlyTime.ToString(dateFormat));
var latestParam = new QueryParam("latestTime", correctedLatestTime.ToString(dateFormat));
return(await apiGateway.Get <List <ChatMessageModel> >(
"channels",
routeValues : new string[] { Channel.ChannelName, "chatlogs" },
queryParams : new QueryParam[] { earliestParam, latestParam }).ConfigureAwait(false));
}
public async Task <ActionResult> SyncSelectedData(string IDs)
{
if (string.IsNullOrEmpty(IDs))
{
return(Json(new { state = ResultType.error.ToString(), message = "选择的数据为空" }));
}
QueryParam queryParam = new QueryParam();
queryParam.filter = string.Format("TransId in ({0})", IDs.TrimEnd(','));
queryParam.orderby = "BPLId,CreateDate,TransId";
var rt = await _JournalSourceApp.GetJournalSourceAsync(queryParam);
Logger.Writer(Newtonsoft.Json.JsonConvert.SerializeObject(rt));
string errorNum = "";
string errorMsg = "";
foreach (var item in rt)
{
try
{
JournalRelationMap jrMap = new JournalRelationMap();
jrMap = JournalRelationMap.Create(item);
var syncResult = await _JournalRelationMapApp.SaveJournalRelationMapAsync(jrMap);
if (syncResult.Code != 0)
{
errorNum += syncResult.UniqueKey + ",";
errorMsg += syncResult.Message + ";";
}
}
catch (Exception ex)
{
errorNum += item.TransId + ",";
errorMsg += ex.Message + ";";
}
}
if (!string.IsNullOrEmpty(errorNum) && !string.IsNullOrEmpty(errorMsg))
{
return(Json(new { state = ResultType.success.ToString(), message = "" }));
}
else
{
return(Json(new { state = ResultType.error.ToString(), message = $"失败单号：{errorNum};失败原因：{errorMsg}" }));
}
}
//private const string SinlgeQuoteCaracter = "'";
//private const string EqualCaracter = "=";
//private const string TabCaracter = "\t";
//private const string NameParamCaracter = "@";
//private const string AnyCaracter = "%";
//private const string FirstFieldCaracter = "1";
//private const string SecondFieldCaracter = "2";
/// <summary>
/// Pega o nome do banco de dados
/// </summary>
/// <param name="pQueryParam">Parametros da query</param>
/// <param name="pWithNameParam">Com parametros</param>
/// <returns></returns>
public string GetConditionValue(QueryParam pQueryParam, bool pWithNameParam)
{
if (pWithNameParam)
{
return(pQueryParam.Value1Column != null
? GetConditionValueByColumn(pQueryParam)
: GetConditionValueByParam(pQueryParam));
}
var value = string.Empty;
switch (pQueryParam.Condition)
{
case eCondition.ecLikeStart:
value = string.Format("{0}%", pQueryParam.FieldName);
break;
case eCondition.ecLikeEnd:
value = string.Format("%{0}", pQueryParam.FieldName);
break;
case eCondition.ecBetween:
case eCondition.ecNotBetween:
value = string.Format(
"{0}1 {1} {0}2",
pQueryParam.FieldName,
GetRelationShip(eRelationship.erAnd));
break;
case eCondition.ecIsNull:
case eCondition.ecNotNull:
break;
case eCondition.ecIn:
case eCondition.ecNotIn:
value = string.Format("({0})", pQueryParam.FieldName);
break;
default:
value = string.Format(pQueryParam.FieldName);
break;
}
return(value);
}
public static SubscriptionParameter Parse(QueryParam parameter)
{
var subscriptionParameter = new SubscriptionParameter
{
ParameterName = parameter.Name
};
foreach (var value in parameter.Values)
{
subscriptionParameter.Values.Add(new SubscriptionParameterValue
{
Parameter = subscriptionParameter,
Value = value
});
}
return(subscriptionParameter);
}
/// <summary>
/// 绑定数据
/// </summary>
private void BindDataList()
{
QueryParam qp = new QueryParam();
string s = SearchTerms;
s += " AND MsgType = 12 ";
s += " AND UserID = 10012 ";
qp.Where = s;
qp.PageIndex = AspNetPager1.CurrentPageIndex;
qp.PageSize = AspNetPager1.PageSize;
int RecordCount = 0;
DataSet ds = BusinessFacadeDLT.LevelOrderMessage(qp.PageIndex, qp.PageSize, qp.Where);
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
RecordCount = int.Parse(ds.Tables[1].Rows[0][0].ToString());
this.AspNetPager1.RecordCount = RecordCount;
}
public PagedViewModel<UserInfoViewModel> GetUsersByParam(QueryParam queryParam)
{
var pagedUsers = AccountRepository.GetUsersByParam(queryParam);
var userInfos = new List<UserInfoViewModel>((int)pagedUsers.Item2);
foreach (var user in pagedUsers.Item1)
{
userInfos.Add(new UserInfoViewModel
{
UserName = user.UserName,
RealName = user.RealName,
BelongsTo = user.Department.ToString(),
Status = user.Status,
LastVisit = DateTime.Now,
Roles = new List<string>() { "r1" }
});
}
return new PagedViewModel<UserInfoViewModel> { ViewModels = userInfos, Total = pagedUsers.Item2 };
}
