// Token: 0x0600029B RID: 667 RVA: 0x00017474 File Offset: 0x00015674
private string getSqlStr(int type)
{
int selectedIndex = this.queryItemCB.SelectedIndex;
int selectedIndex2 = this.typeCB.SelectedIndex;
if (selectedIndex >= 0 && selectedIndex2 >= 0 && this.qces != null && this.qces.Count > selectedIndex)
{
QueryConditionEntity queryConditionEntity = this.qces[selectedIndex];
string sqlKeys = queryConditionEntity.SqlKeys;
bool showInputAsCB = queryConditionEntity.ShowInputAsCB;
string text = this.valueTB.Text.Trim();
bool cbDataDirectValue = queryConditionEntity.CbDataDirectValue;
if (showInputAsCB)
{
int selectedIndex3 = this.valuesCB.SelectedIndex;
if (selectedIndex3 >= 0 && selectedIndex3 < queryConditionEntity.CbData.Count)
{
if (!cbDataDirectValue)
{
string input = queryConditionEntity.CbData[selectedIndex3];
Regex regex = new Regex("-");
string[] array = regex.Split(input);
text = array[0];
}
else
{
text = string.Concat(selectedIndex3);
}
}
else
{
text = "";
}
}
if (selectedIndex2 == 2)
{
text = "%" + text + "%";
}
QueryValue queryValue = new QueryValue();
queryValue.AndOr = ((type == this.AND) ? "AND" : "OR");
queryValue.Value = text;
queryValue.Oper = this.operators3[selectedIndex2];
if (this.sqlDicts.ContainsKey(sqlKeys))
{
this.sqlDicts[sqlKeys] = queryValue;
}
else
{
this.sqlDicts.Add(sqlKeys, queryValue);
}
}
string text2 = null;
for (int i = 0; i < this.sqlDicts.Keys.Count; i++)
{
string text3 = this.sqlDicts.Keys.ElementAt(i);
QueryValue queryValue2 = this.sqlDicts[text3];
string text4 = text2;
text2 = string.Concat(new string[]
{
text4,
(i == 0) ? "" : queryValue2.AndOr,
" ",
text3,
" ",
queryValue2.Oper,
" ",
queryValue2.Value,
" "
});
}
return(text2);
}
// Token: 0x060003F8 RID: 1016 RVA: 0x0003717C File Offset: 0x0003537C
public void queryDB(Dictionary <string, QueryValue> dicts)
{
if (this.qb == null || dicts == null || dicts.Count < 0)
{
return;
}
DataTable dataTable = new DataTable();
dataTable.Columns.Add("userId");
dataTable.Columns.Add("username");
dataTable.Columns.Add("identityId");
dataTable.Columns.Add("phoneNum");
dataTable.Columns.Add("address");
dataTable.Columns.Add("usertype");
dataTable.Columns.Add("priceType");
dataTable.Columns.Add("paytype");
dataTable.Columns.Add("pursuitTimes");
dataTable.Columns.Add("pursuitNum");
dataTable.Columns.Add("paynum");
dataTable.Columns.Add("time");
dataTable.Columns.Add("operator");
string text = "";
if (this.qb.getOperationId() == "")
{
WMMessageBox.Show(this, "请输入员工号！");
return;
}
this.db.AddParameter("staffId", this.qb.getOperationId());
if (this.db.ExecuteRow("SELECT * FROM staffTable WHERE staffId=@staffId") == null)
{
WMMessageBox.Show(this, "没有查询到该员工！");
return;
}
List <string> list = new List <string>();
string sqlStrForQueryUser = this.getSqlStrForQueryUser(dicts);
DataTable dataTable2;
if (sqlStrForQueryUser != "")
{
foreach (string key in dicts.Keys)
{
QueryValue queryValue = dicts[key];
this.db.AddParameter(key, queryValue.Value);
}
dataTable2 = this.db.ExecuteQuery("SELECT * FROM usersTable WHERE " + sqlStrForQueryUser + " ORDER BY createTime ASC");
if (dataTable2 != null && dataTable2.Rows != null && dataTable2.Rows.Count > 0)
{
foreach (object obj in dataTable2.Rows)
{
DataRow dataRow = (DataRow)obj;
list.Add(dataRow["permanentUserId"].ToString());
}
}
}
if (list.Count > 0)
{
for (int i = 0; i < list.Count; i++)
{
string text2 = list[i];
this.db.AddParameter("permanentUserId" + text2, text2);
if (i != 0)
{
text += " OR ";
}
text = text + "permanentUserId=@permanentUserId" + text2;
}
}
else if (list.Count == 0 && dicts.Count != 0 && sqlStrForQueryUser != "")
{
this.qb.initDGV(this.initDGV(dataTable));
return;
}
TimeSpan timeSpan = this.qb.getStartDT() - WMConstant.DT1970;
TimeSpan timeSpan2 = this.qb.getEndDT() - WMConstant.DT1970;
this.db.AddParameter("createTimeStart", string.Concat(timeSpan.TotalSeconds));
this.db.AddParameter("createTimeEnd", string.Concat(timeSpan2.TotalSeconds));
this.db.AddParameter("staffId", this.qb.getOperationId());
this.db.AddParameter("lastReadInfo", "0");
string sqlKeys = this.getQueryConditionEntitys()[7].SqlKeys;
if (dicts.ContainsKey(sqlKeys))
{
QueryValue queryValue2 = dicts[sqlKeys];
this.db.AddParameter(sqlKeys, queryValue2.Value);
string text3 = text;
text = string.Concat(new string[]
{
text3,
(text == "") ? "" : (" " + queryValue2.AndOr + " "),
sqlKeys,
queryValue2.Oper,
"@",
sqlKeys
});
if (queryValue2.Value == "1")
{
this.db.AddParameter("operateType1", "0");
text += " OR operateType=@operateType1";
}
}
dataTable2 = this.db.ExecuteQuery("SELECT * FROM userCardLog WHERE " + ((text == "") ? "" : ("(" + text + ") AND ")) + "lastReadInfo=@lastReadInfo AND operator=@staffId AND time>=@createTimeStart AND time<=@createTimeEnd ORDER BY operationId ASC");
text = "";
if (dataTable2 != null && dataTable2.Rows != null && dataTable2.Rows.Count > 0)
{
foreach (object obj2 in dataTable2.Rows)
{
DataRow dataRow2 = (DataRow)obj2;
this.db.AddParameter("permanentUserId", dataRow2["permanentUserId"].ToString());
DataRow dataRow3 = this.db.ExecuteRow("SELECT * FROM usersTable WHERE permanentUserId=@permanentUserId");
if (dataRow3 != null)
{
this.db.AddParameter("typeId", dataRow3["userTypeId"].ToString());
DataRow dataRow4 = this.db.ExecuteRow("SELECT * FROM userTypeTable WHERE typeId=@typeId");
this.db.AddParameter("priceConsistId", dataRow3["userPriceConsistId"].ToString());
DataRow dataRow5 = this.db.ExecuteRow("SELECT * FROM priceConsistTable WHERE priceConsistId=@priceConsistId");
if (dicts.ContainsKey(sqlKeys))
{
QueryValue queryValue3 = dicts[sqlKeys];
text = "payType=@payType";
string value;
if ((value = queryValue3.Value) != null)
{
if (!(value == "0") && !(value == "1") && !(value == "2") && !(value == "4"))
{
if (!(value == "3"))
{
if (value == "5")
{
this.db.AddParameter("payType", "7");
}
}
else
{
this.db.AddParameter("payType", "5");
}
}
else
{
this.db.AddParameter("payType", queryValue3.Value);
}
}
}
this.db.AddParameter("userCardLogId", dataRow2["operationId"].ToString());
DataTable dataTable3 = this.db.ExecuteQuery("SELECT * FROM payLogTable WHERE userCardLogId=@userCardLogId" + ((text == "") ? "" : (" AND " + text)));
if (dataTable3 != null && dataTable3.Rows != null && dataTable3.Rows.Count > 0)
{
foreach (object obj3 in dataTable3.Rows)
{
DataRow dataRow6 = (DataRow)obj3;
DataRow dataRow7 = dataTable.NewRow();
dataRow7["userId"] = dataRow3["userId"].ToString();
dataRow7["username"] = dataRow3["username"].ToString();
dataRow7["identityId"] = dataRow3["identityId"].ToString();
dataRow7["phoneNum"] = dataRow3["phoneNum"].ToString();
dataRow7["address"] = dataRow3["address"].ToString();
dataRow7["usertype"] = ((dataRow4 == null) ? "" : dataRow4["userType"].ToString());
dataRow7["priceType"] = ((dataRow5 == null) ? "" : dataRow5["priceConstistName"].ToString());
dataRow7["paytype"] = WMConstant.PayTypeList[(int)(checked ((IntPtr)(Convert.ToInt64(dataRow6["payType"]))))];
dataRow7["pursuitTimes"] = dataRow2["consumeTimes"].ToString();
dataRow7["pursuitNum"] = dataRow6["pursuitNum"].ToString();
dataRow7["paynum"] = dataRow6["totalPrice"].ToString();
dataRow7["time"] = WMConstant.DT1970.AddSeconds(ConvertUtils.ToDouble(dataRow2["time"].ToString())).ToString("yyyy-MM-dd HH:mm:ss");
dataRow7["operator"] = dataRow2["operator"].ToString();
dataTable.Rows.Add(dataRow7);
dataTable.AcceptChanges();
}
}
}
}
}
this.qb.initDGV(this.initDGV(dataTable));
}
