public string ValidateCardId(string strCardId)
{
CardDAL dalCard = new CardDAL();
DataTable tblCard = dalCard.ValidateCardID(strCardId);
DataTransfer dataResult = new DataTransfer();
if (tblCard.Rows.Count > 0)
{
dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_SUCCESS;
DataSet ds = new DataSet();
ds.Tables.Add(tblCard.Copy());
dataResult.ResponseDataSet = ds;
}
else
{
dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_FAIL;
dataResult.ResponseErrorMsg = SGMText.GAS_STATION_CARD_ID_NOT_EXIST;
}
return(JSonHelper.ConvertObjectToJSon(dataResult));
}
public LCHRoleData GetRole(string id)
{
if (roles.ContainsKey(id))
{
return(roles[id]);
}
var js = loader.LoadFile(id, SkillDataType.ROLE);
//var v = JSonHelper.DeserializeDictionary(js);
LCHRoleData v = JSonHelper.DeserializeRole(js);
Array.Sort <string>(v.skills);
if (v == null)
{
return(null);
}
roles[id] = v;
v.skills = JSonHelper.ToStringList(v.skills);
////roid["skills"];
return(v);
}
public LCHSkillData GetSkill(string skillId)
{
if (skills.ContainsKey(skillId))
{
return(skills[skillId]);
}
#if UNITY_EDITOR
if (EditorModel && null == loader)
{
loader = new EditorFileLoader();
}
#endif
var js = loader.LoadFile(skillId, SkillDataType.SKILL);
if (js.Length == 0)
{
return(null);
}
var v = JSonHelper.DeserializeSkill(js);
skills[skillId] = v;
return(v);
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (!ValidateDataInput())
{
return;
}
frmGSMMain.s_currentAdminDTO.SysApplyDate = dtpNew.Value;
frmGSMMain.s_currentAdminDTO.SysGas92CurrentPrice = frmGSMMain.s_currentAdminDTO.SysGas92NewPrice = Int32.Parse(txtGas92NewPrice.Text);
frmGSMMain.s_currentAdminDTO.SysGas95CurrentPrice = frmGSMMain.s_currentAdminDTO.SysGas95NewPrice = Int32.Parse(txtGas95NewPrice.Text);
frmGSMMain.s_currentAdminDTO.SysGasDOCurrentPrice = frmGSMMain.s_currentAdminDTO.SysGasDONewPrice = Int32.Parse(txtGasDONewPrice.Text);
DataTransfer request = new DataTransfer();
request.ResponseDataSystemAdminDTO = frmGSMMain.s_currentAdminDTO;
String jsRequest = JSonHelper.ConvertObjectToJSon(request);
Task <String> task = SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterTask(
() =>
{
return(m_service.SGMManager_UpdateSystemPrice(jsRequest));
});
SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterContinuation(task, () =>
{
String stResponse = task.Result as String;
DataTransfer dataResponse = JSonHelper.ConvertJSonToObject(stResponse);
if (dataResponse.ResponseCode == DataTransfer.RESPONSE_CODE_SUCCESS)
{
frmMSg.ShowMsg(SGMText.SGM_INFO, SGMText.ADMIN_UPDATE_PRICE_SUCCESS, SGMMessageType.SGM_MESSAGE_TYPE_INFO);
DataToUIView();
}
else
{
frmMSg.ShowMsg(SGMText.SGM_ERROR, dataResponse.ResponseErrorMsgDetail, SGMMessageType.SGM_MESSAGE_TYPE_ERROR);
frmGSMMain.s_currentAdminDTO.SysGas92CurrentPrice = int.Parse(txtGas92CurrentPrice.Text);
frmGSMMain.s_currentAdminDTO.SysGas95CurrentPrice = int.Parse(txtGas95CurrentPrice.Text);
frmGSMMain.s_currentAdminDTO.SysGasDOCurrentPrice = int.Parse(txtGasDOCurrentPrice.Text);
}
}, SynchronizationContext.Current);
}
private void LoadCustomerList()
{
Task <String> task = SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterTask(
() =>
{
return(m_service.SGMManager_GetCustomer(m_stSearchValue, false));
});
SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterContinuation(task, () =>
{
String stResponse = task.Result as String;
DataTransfer response = JSonHelper.ConvertJSonToObject(stResponse);
dgvCusList.Rows.Clear();
m_dsCustomer = response.ResponseDataSet;
int iOldSelected = m_iCurrentCustomerIndex;
if (m_dsCustomer != null && dgvCusList.ColumnCount > 0)
{
for (int i = 0; i < m_dsCustomer.Tables[0].Rows.Count; i++)
{
dgvCusList.Rows.Add();
dgvCusList.Rows[i].Cells[0].Value = (i + 1);
dgvCusList.Rows[i].Cells[1].Value = m_dsCustomer.Tables[0].Rows[i]["CUS_NAME"] + " (" + m_dsCustomer.Tables[0].Rows[i]["CUS_ID"] + ")";
}
if (iOldSelected >= 0)
{
m_iCurrentCustomerIndex = iOldSelected;
}
if (m_iCurrentCustomerIndex >= dgvCusList.Rows.Count)
{
m_iCurrentCustomerIndex = -1;
}
if (m_iCurrentCustomerIndex >= 0)
{
dgvCusList.Rows[m_iCurrentCustomerIndex].Selected = true;
}
}
//if (dgvCardList.Rows.Count <= 0)
LoadCardList();
}, SynchronizationContext.Current);
}
/// <summary>
/// 查询的方法
/// </summary>
private void Query(string bmid)
{
try
{
//一页显示几行数据
string rows = HttpContext.Current.Request["rows"];
//当前页
string page = HttpContext.Current.Request["page"];
string strWhere = GetWhere();
if (bmid == "1" || string.IsNullOrEmpty(bmid))
{
bmid = "1";
}
//使用存储过程及临时表实现递归方式列表
SqlParameter[] parms =
{
new SqlParameter("@id", bmid)
};
SqlHelper.ExeNonQuery("get_bmzl2", CommandType.StoredProcedure, parms);
DataSet duser = SqlHelper.GetList("v_ygzl", "*", "id", int.Parse(rows), int.Parse(page), false, false, strWhere);
DataTable dt1 = duser.Tables[0];
//获取数据源
DataTable dt = SqlHelper.GetTable("select * from v_ygzl where " + strWhere + " order by cygbh asc");
string str = string.Empty;
//将数据转换成json格式
str = JSonHelper.CreateJsonParameters(dt1, true, dt.Rows.Count);
//str = JSonHelper.SerializeObject(dt1);
//str ="{ " + "\"total\":" + dt.Rows.Count + "," + "\"rows\":" + str + "}";
HttpContext.Current.Response.Write(str);
}
catch (Exception ex)
{
sys e = new sys();
e.GetLog(ex);
}
}
public static string CreatePostHttpResponse(string url, IDictionary <string, string> parameters, IDictionary <string, string> headersParameters)
{
string paraUrlCoded = JSonHelper.Serialize(parameters);
//string str = HttpPost(url, paraUrlCoded);
Task t = new Task(new Action(() =>
{
//推送产品
string str = PostUrl(url, paraUrlCoded);
}));
t.Start();
// string str =PostUrl(url, paraUrlCoded);
return("");
//获取权限
HttpWebResponse request = CreatePostHttpResponse(url, parameters, headersParameters, Encoding.UTF8);
//实例化一个StreamReader对象来获取Response的GetResponseStream返回的响应的体
StreamReader Info_Reader = new StreamReader(request.GetResponseStream(), Encoding.UTF8);
return(Info_Reader.ReadToEnd() + "");
}
public static void Rescan(MainUIViewModel MUVM)
{
MUVM.ActiveWorkspace.Associations = new ObservableCollection <Association>();
MUVM.ContentItems = new ObservableCollection <ContentItem>();
Scannerino.ScanAllMods(MUVM);
JSonHelper.SaveContentItems(MUVM.ContentItems);
foreach (LibraryItem li in MUVM.Library)
{
List <ContentItem> contentItems = MUVM.ContentItems.Where(ci => ci.LibraryItemGuid == li.Guid).ToList();
MUVM.ActiveWorkspace = Slotter.AutomaticSlot(contentItems, MUVM.ActiveWorkspace, MUVM.QuasarModTypes);
}
JSonHelper.SaveWorkspaces(MUVM.Workspaces);
EventSystem.Publish <ModalEvent>(new ModalEvent()
{
Action = "LoadOK",
EventName = "UltraScanning"
});
}
/// <summary>按下 Save 鍵</summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtnSave_Click(object sender, EventArgs e)
{
try
{
if (this.PositionInstances != null && this.PositionInstances.Any())
{
//ToSave();
var currentConfig = this.RobotPathFileConfigSet.GetCurrentConfig(CmbBoxDeviceName.Text);
JSonHelper.SaveInstanceToJsonFile(this.PositionInstances, currentConfig.PositionFileDirectory, TxtBxDevicePath.Text);
RefreshPositionInfoList();
MessageBox.Show("存檔成功");
}
else
{
MessageBox.Show("沒有資料");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void LoadGasStationList()
{
cboGasStation.Items.Clear();
Task <String> task = SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterTask(
() =>
{
return(m_service.SGMSaleGas_GetGasStationList(m_stGasStoreID));
});
SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterContinuation(task, () =>
{
String stResponse = task.Result as String;
DataTransfer dataResponse = JSonHelper.ConvertJSonToObject(stResponse);
if (dataResponse.ResponseCode == DataTransfer.RESPONSE_CODE_SUCCESS)
{
DataSet ds = dataResponse.ResponseDataSet;
DataTable tblResult = ds.Tables[0];
if (tblResult.Rows.Count > 0)
{
ComboboxItem itemAll = new ComboboxItem();
itemAll.Text = SGMText.REPORT_ALL;
itemAll.Value = "";
cboGasStation.Items.Add(itemAll);
foreach (DataRow dr in tblResult.Rows)
{
ComboboxItem item = new ComboboxItem();
item.Text = dr["GASSTATION_NAME"].ToString();
item.Value = dr["GASSTATION_ID"].ToString();
cboGasStation.Items.Add(item);
}
cboGasStation.SelectedIndex = 0;
}
}
else
{
frmMsg.ShowMsg(SGMText.SGM_ERROR, dataResponse.ResponseErrorMsgDetail, SGMMessageType.SGM_MESSAGE_TYPE_ERROR);
}
}, SynchronizationContext.Current);
}
private void GetPriceGas()
{
Task <String> task = SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterTask(
() =>
{
return(m_service.SGMManager_GetCurrentPrice(SystemAdminDTO.GAS_TYPE_92));
});
SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterContinuation(task, () =>
{
bool bHasErr = true;
String stResponse = task.Result as String;
DataTransfer dataResult = JSonHelper.ConvertJSonToObject(stResponse);
if (dataResult.ResponseCode == DataTransfer.RESPONSE_CODE_SUCCESS)
{
m_iPriceGas92 = dataResult.ResponseDataInt;
dataResult = JSonHelper.ConvertJSonToObject(m_service.SGMManager_GetCurrentPrice(SystemAdminDTO.GAS_TYPE_95));
if (dataResult.ResponseCode == DataTransfer.RESPONSE_CODE_SUCCESS)
{
m_iPriceGas95 = dataResult.ResponseDataInt;
dataResult = JSonHelper.ConvertJSonToObject(m_service.SGMManager_GetCurrentPrice(SystemAdminDTO.GAS_TYPE_DO));
if (dataResult.ResponseCode == DataTransfer.RESPONSE_CODE_SUCCESS)
{
m_iPriceGasDO = dataResult.ResponseDataInt;
bHasErr = false;
}
}
}
if (bHasErr)
{
m_iPriceGas92 = m_iPriceGas95 = m_iPriceGasDO = 0;
frmMsg.ShowMsg(SGMText.SGM_ERROR, SGMText.SYS_ADMIN_GET_PRICE_ERR + "\n" + dataResult.ResponseErrorMsg + ":" + dataResult.ResponseErrorMsgDetail, SGMMessageType.SGM_MESSAGE_TYPE_ERROR);
}
txtRechargeGasPrice.Text = SGMText.GAS_92_TEXT + " : " + m_iPriceGas92 + "đ - " + SGMText.GAS_95_TEXT + " : " + m_iPriceGas95 + "đ - " + SGMText.GAS_DO_TEXT + " : " + m_iPriceGasDO + "đ";
this.Enabled = true;
ShowDialog();
}, SynchronizationContext.Current);
}
//个人通知
private void Show(string user, string sState)
{
try
{
//一页显示几行数据
string rows = HttpContext.Current.Request["rows"];
//当前页
string page = HttpContext.Current.Request["page"];
string strWhere = "1=1";
if (!string.IsNullOrEmpty(sState) && sState == "s")
{
if (!string.IsNullOrEmpty(user))
{
strWhere = strWhere + " and cdxmc='" + user + "'";
}
}
else
{
HttpContext.Current.Response.Write("{ \"total\":0,\"rows\":[]");
return;
}
DataSet duser = SqlHelper.GetList("tmp_gcstzb", "*", "id", int.Parse(rows), int.Parse(page), false, true, strWhere);
DataTable dt1 = duser.Tables[0];
//获取数据源
DataTable dt = SqlHelper.GetTable("select * from tmp_gcstzb where " + strWhere + " order by drq desc");
string str = string.Empty;
//将数据转换成json格式
str = JSonHelper.CreateJsonParameters(dt1, true, dt.Rows.Count);
HttpContext.Current.Response.Write(str);
}
catch (Exception ex)
{
sys e = new sys();
e.GetLog(ex);
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
// validate user input
if (ValidateLoginCode() == false)
{
return;
}
// request server
string GASSTORE_ID = txtLoginCode.Text;
string GASSTORE_MACADDRESS = GetMacAddress();
Task <String> task = SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterTask(
() => {
return(service.SGMSaleGas_ValidateGasStoreLogin(GASSTORE_ID, GASSTORE_MACADDRESS));
});
SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterContinuation(task, () =>
{
String stResponse = task.Result as String;
DataTransfer dataResponse = JSonHelper.ConvertJSonToObject(stResponse);
if (dataResponse.ResponseCode == DataTransfer.RESPONSE_CODE_SUCCESS)
{
this.Hide();
if (Program.ReaderPort != null)
{
Program.ReaderPort.DataReceived -= serialDatahandler;
}
frmSGMUpdateStore frm = new frmSGMUpdateStore(dataResponse.ResponseDataGasStoreDTO);
frm.ShowDialog();
this.Close();
}
else
{
frmMsg.ShowMsg(SGMText.SGM_ERROR, dataResponse.ResponseErrorMsg, SGMMessageType.SGM_MESSAGE_TYPE_ERROR);
}
}, SynchronizationContext.Current);
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
string sbid = context.Request["sbid"];
//一页显示几行数据
string rows = HttpContext.Current.Request["rows"];
//当前页
string page = HttpContext.Current.Request["page"];
string strWhere = "";
if (string.IsNullOrEmpty(sbid))
{
strWhere = " 1=1";
}
else
{
strWhere = " isbid=" + sbid;
}
DataSet duser = SqlHelper.GetList("v_sbzl_dj", "*", "id", int.Parse(rows), int.Parse(page), false, false, strWhere);
DataTable dt1 = duser.Tables[0];
//获取数据源
DataTable dt = SqlHelper.GetTable("select * from v_sbzl_dj where " + strWhere);
string str = string.Empty;
//将数据转换成json格式
str = JSonHelper.CreateJsonParameters(dt1, true, dt.Rows.Count);
HttpContext.Current.Response.Write(str);
}
catch (Exception ex)
{
sys e = new sys();
e.GetLog(ex);
}
}
private void search()
{
try
{
//一页显示几行数据
string rows = HttpContext.Current.Request["rows"];
//当前页
string page = HttpContext.Current.Request["page"];
string strWhere = "";
string rq1 = HttpContext.Current.Request["rq1"];
string rq2 = HttpContext.Current.Request["rq2"];
string proline = HttpContext.Current.Request["proline"];
string txt = HttpContext.Current.Request["txt"];
strWhere = " drq>='" + rq1 + "' and drq<='" + rq2 + "' and csxnr like '%" + txt + "%'";
if (proline != "")
{
strWhere = strWhere + " and cscx='" + proline + "'";
}
DataSet duser = SqlHelper.GetList("v_zxdbsx", "*", "id", int.Parse(rows), int.Parse(page), false, true, strWhere);
DataTable dt1 = duser.Tables[0];
//获取数据源
DataTable dt = SqlHelper.GetTable("select * from v_zxdbsx where " + strWhere);
string str = string.Empty;
//将数据转换成json格式
str = JSonHelper.CreateJsonParameters(dt1, true, dt.Rows.Count);
HttpContext.Current.Response.Write(str);
}
catch (Exception ex)
{
sys e = new sys();
e.GetLog(ex);
}
}
public string UpdateRechargeIDForCard(string stCardID)
{
m_dataResponse = m_dalCard.UpdateRechargeIDForCard(stCardID);
return(JSonHelper.ConvertObjectToJSon(m_dataResponse));
}
public static void GetMoveOldLibrary(ILog QuasarLogger)
{
QuasarLogger.Debug("Loading Old Library");
List <Data.V1.LibraryMod> OldLibrary = Quasar.Helpers.XML.XMLHelper.GetLibraryModList();
ObservableCollection <LibraryItem> NewLibrary = new ObservableCollection <LibraryItem>();
QuasarLogger.Debug("Loading API");
GamebananaAPI API = JSonHelper.GetGamebananaAPI();
Directory.CreateDirectory(Properties.Settings.Default.DefaultDir + @"\LibraryBackup");
FileOperation.CheckCopyFolder(Properties.Settings.Default.DefaultDir + @"\Library", Properties.Settings.Default.DefaultDir + @"\LibraryBackup");
foreach (Data.V1.LibraryMod lm in OldLibrary)
{
QuasarLogger.Debug(String.Format("Processing Mod #{0}", lm.ID));
//Creating new item based on old one
LibraryItem li = new LibraryItem()
{
GameID = lm.GameID,
Guid = Guid.NewGuid(),
Time = DateTime.Now,
Name = lm.Name,
};
//Finding corresponding data
GamebananaRootCategory rc = API.Games[0].RootCategories.Single(c => c.Name == lm.TypeLabel);
GamebananaSubCategory sc = rc.SubCategories.Single(c => c.Name == lm.APICategoryName);
GamebananaItem item = new GamebananaItem()
{
Description = "",
GamebananaItemID = lm.ID,
Name = lm.Name,
UpdateCount = lm.Updates,
RootCategoryGuid = rc.Guid,
SubCategoryGuid = sc.Guid,
Authors = new ObservableCollection <Author>()
};
//Processing Authors
foreach (string[] val in lm.Authors)
{
Author au = new Author()
{
Name = val[0],
Role = val[1],
GamebananaAuthorID = int.Parse(val[2])
};
item.Authors.Add(au);
}
//Assigning GBItem to the LibraryItem
li.GBItem = item;
//Assigning item to the new Library
NewLibrary.Add(li);
QuasarLogger.Debug(String.Format("Processed Mod #{0}", lm.ID));
}
QuasarLogger.Debug("Transferring Mods");
//Moving mods to new path
TransferMods(NewLibrary, QuasarLogger);
JSonHelper.SaveLibrary(NewLibrary);
}
//生成检修计划
private void Search()
{
//一页显示几行数据
string rows = HttpContext.Current.Request["rows"];
//当前页
string page = HttpContext.Current.Request["page"];
if (HttpContext.Current.Request["data"] == "no")
{
HttpContext.Current.Response.Write("{ \"total\":0,\"rows\":[]");
return;
}
string value = HttpContext.Current.Request["data"];
string[] strr = value.Split('&');
string s_where = "czt='持续中'";
string s_csbbh = strr[0].Split('=')[1];
if (s_csbbh.Trim().Length > 0)
{
s_where = s_where + " and csbbh like '%" + s_csbbh + "%'";
}
string s_csbmc = strr[1].Split('=')[1];
if (s_csbmc.Trim().Length > 0)
{
s_where = s_where + " and csbmc like '%" + s_csbmc + "%'";
}
string s_cscx = strr[2].Split('=')[1];
if (s_cscx.Trim().Length > 0)
{
s_where = s_where + " and iscxid = '" + s_cscx + "'";
}
string s_csszy = strr[3].Split('=')[1];
if (s_csszy.Trim().Length > 0)
{
s_where = s_where + " and izyid='" + s_csszy + "'";
}
string s_csxlx = strr[4].Split('=')[1];
if (s_csxlx.Trim().Length > 0)
{
s_where = s_where + " and csxlx like '%" + s_csxlx + "%'";
}
string s_cdbr = strr[5].Split('=')[1];
if (s_cdbr.Trim().Length > 0)
{
s_where = s_where + " and cdbr like '%" + s_cdbr + "%'";
}
string s_cnr = strr[6].Split('=')[1];
if (s_cnr.Trim().Length > 0)
{
s_where = s_where + " and csxnr like '%" + s_cnr + "%'";
}
string s_cclfs = strr[7].Split('=')[1];
if (s_cclfs.Trim().Length > 0)
{
s_where = s_where + " and cclfs like '%" + s_cclfs + "%'";
}
DataSet duser = SqlHelper.GetList("v_dbsx", "*", "czt", int.Parse(rows), int.Parse(page), false, false, s_where);
DataTable dt1 = duser.Tables[0];
//获取数据源
DataTable dt = SqlHelper.GetTable("select * from v_dbsx where " + s_where + " order by drq desc");
string str = string.Empty;
//将数据转换成json格式
str = JSonHelper.CreateJsonParameters(dt1, true, dt.Rows.Count);
HttpContext.Current.Response.Write(str);
}
private void btnUpdateCard_Click(object sender, EventArgs e)
{
if (ValidateDataInput())
{
DataTransfer response = null;
DataTransfer request = new DataTransfer();
Task <String> task;
if (m_bRecharge)
{
RechargeDTO dtoRecharge = new RechargeDTO();
dtoRecharge.RechargeDate = dtpRechargeDate.Value;
dtoRecharge.RechargeGas92Price = m_iPriceGas92;
dtoRecharge.RechargeGas95Price = m_iPriceGas95;
dtoRecharge.RechargeGasDOPrice = m_iPriceGasDO;
dtoRecharge.RechargeMoney = Int32.Parse(txtCardMoney.Text.Trim());
dtoRecharge.RechargeMoneyEx = Int32.Parse(txtExMoney.Text.Trim());
dtoRecharge.RechargeNote = txtRechargeNote.Text.Trim();
dtoRecharge.CardID = txtCardID.Text.Trim();
request.ResponseDataRechargeDTO = dtoRecharge;
task = SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterTask(
() =>
{
return(m_service.SGMManager_AddRechargeCard(JSonHelper.ConvertObjectToJSon(request)));
});
SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterContinuation(task, () =>
{
String stResponse = task.Result as String;
response = JSonHelper.ConvertJSonToObject(stResponse);
if (response.ResponseCode == DataTransfer.RESPONSE_CODE_SUCCESS)
{
task = SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterTask(
() =>
{
return(m_service.SGMManager_UpdateRechargeIDForCard(txtCardID.Text.Trim()));
});
SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterContinuation(task, () =>
{
stResponse = task.Result as String;
response = JSonHelper.ConvertJSonToObject(stResponse);
if (response.ResponseCode == DataTransfer.RESPONSE_CODE_SUCCESS)
{
task = SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterTask(
() =>
{
return(m_service.SGMManager_UpdateMoneyForCard(txtCardID.Text.Trim(), m_iCurrentCardMoney + Int32.Parse(txtCardMoney.Text.Trim()) + Int32.Parse(txtExMoney.Text.Trim())));
});
SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterContinuation(task, () =>
{
stResponse = task.Result as String;
response = JSonHelper.ConvertJSonToObject(stResponse);
if (response.ResponseCode == DataTransfer.RESPONSE_CODE_SUCCESS)
{
this.Close();
}
}, SynchronizationContext.Current);
}
}, SynchronizationContext.Current);
}
}, SynchronizationContext.Current);
}
else
{
CardDTO dtoCard = new CardDTO();
dtoCard.CardID = txtCardID.Text.Trim();
dtoCard.CardUnlockState = true;
dtoCard.CardRemainingMoney = Int32.Parse(txtCardMoney.Text.Trim());
dtoCard.CardMoneyEx = 0;
dtoCard.CardBuyDate = dtpRechargeDate.Value;
dtoCard.RechargeID = -1;
dtoCard.CustomerID = m_stCusID;
request.ResponseDataCardDTO = dtoCard;
task = SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterTask(
() =>
{
return(m_service.SGMManager_AddNewCard(JSonHelper.ConvertObjectToJSon(request)));
});
SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterContinuation(task, () =>
{
String stResponse = task.Result as String;
response = JSonHelper.ConvertJSonToObject(stResponse);
if (response.ResponseCode == DataTransfer.RESPONSE_CODE_SUCCESS)
{
RechargeDTO dtoRecharge = new RechargeDTO();
dtoRecharge.RechargeDate = dtpRechargeDate.Value;
dtoRecharge.RechargeGas92Price = m_iPriceGas92;
dtoRecharge.RechargeGas95Price = m_iPriceGas95;
dtoRecharge.RechargeGasDOPrice = m_iPriceGasDO;
dtoRecharge.RechargeMoney = Int32.Parse(txtCardMoney.Text.Trim());
dtoRecharge.RechargeNote = txtRechargeNote.Text.Trim();
dtoRecharge.CardID = txtCardID.Text.Trim();
request.ResponseDataRechargeDTO = dtoRecharge;
task = SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterTask(
() =>
{
if (m_bChangeCard)
{
return(m_service.SGMManager_ChangeCard(m_stCardID, JSonHelper.ConvertObjectToJSon(request)));
}
else
{
return(m_service.SGMManager_AddRechargeCard(JSonHelper.ConvertObjectToJSon(request)));
}
});
SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterContinuation(task, () =>
{
stResponse = task.Result as String;
response = JSonHelper.ConvertJSonToObject(stResponse);
if (response.ResponseCode == DataTransfer.RESPONSE_CODE_SUCCESS)
{
task = SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterTask(
() =>
{
return(m_service.SGMManager_UpdateRechargeIDForCard(txtCardID.Text.Trim()));
});
SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterContinuation(task, () =>
{
stResponse = task.Result as String;
response = JSonHelper.ConvertJSonToObject(stResponse);
if (response.ResponseCode == DataTransfer.RESPONSE_CODE_SUCCESS)
{
this.Close();
}
else
{
frmMsg.ShowMsg(SGMText.SGM_ERROR, response.ResponseErrorMsg + " : " + response.ResponseErrorMsgDetail, SGMMessageType.SGM_MESSAGE_TYPE_ERROR);
}
}, SynchronizationContext.Current);
}
}, SynchronizationContext.Current);
}
}, SynchronizationContext.Current);
}
}
}
public string GetCardsOfCustomer(string stCusID)
{
m_dataResponse = m_dalCard.GetCardsOfCustomer(stCusID);
return(JSonHelper.ConvertObjectToJSon(m_dataResponse));
}
private bool ValidateDataInput()
{
bool bValidate = true;
SGMHelper.ShowToolTip(txtCardID, "");
SGMHelper.ShowToolTip(txtCardMoney, "");
SGMHelper.ShowToolTip(txtExMoney, "");
SGMHelper.ShowToolTip(dtpRechargeDate, "");
if (txtCardID.Text.Trim().Equals(""))
{
SGMHelper.ShowToolTip(txtCardID, SGMText.CARD_DATA_INPUT_CARD_ID_ERR);
bValidate = false;
}
else if (!m_bRecharge)
{
Task <String> task = SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterTask(
() =>
{
return(m_service.SGMManager_CheckCardExist(txtCardID.Text.Trim()));
});
SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterContinuation(task, () =>
{
String stResponse = task.Result as String;
DataTransfer response = JSonHelper.ConvertJSonToObject(stResponse);
if (response.ResponseCode == DataTransfer.RESPONSE_CODE_SUCCESS)
{
if (response.ResponseDataBool)
{
SGMHelper.ShowToolTip(txtCardID, SGMText.CARD_DATA_INPUT_EXIST_CARD_ID_ERR);
bValidate = false;
}
}
else
{
SGMHelper.ShowToolTip(txtCardID, SGMText.CARD_GET_CARD_ERR);
frmMsg.ShowMsg(SGMText.SGM_ERROR, SGMText.CARD_GET_CARD_ERR + "\n" + response.ResponseErrorMsg + ":\n" + response.ResponseErrorMsgDetail, SGMMessageType.SGM_MESSAGE_TYPE_ERROR);
bValidate = false;
}
}, SynchronizationContext.Current);
}
if (txtCardMoney.Text.Trim().Equals(""))
{
SGMHelper.ShowToolTip(txtCardMoney, SGMText.CARD_DATA_INPUT_CARD_MONEY_ERR);
bValidate = false;
}
//else if (txtRechargeMoney.Text.Trim().Equals(""))
//{
// SGMHelper.ShowToolTip(txtRechargeMoney, SGMText.CARD_DATA_INPUT_CARD_PRICE_ERR);
// bValidate = false;
//}
//else if (Int32.Parse(txtCardMoney.Text.Trim()) < Int32.Parse(txtExMoney.Text.Trim()))
//{
// SGMHelper.ShowToolTip(txtExMoney, SGMText.CARD_DATA_INPUT_CARD_MONEY_PRICE_ERR);
// bValidate = false;
//}
//if (!m_bStateUpdate)
{
if (dtpRechargeDate.Value.Date < DateTime.Now.Date)
{
SGMHelper.ShowToolTip(dtpRechargeDate, SGMText.CARD_DATA_INPUT_DATE_ERR);
bValidate = false;
}
}
return(bValidate);
}
public string UpdateMoneyForCard(string stCardID, int iMoney, int iMoneyEx)
{
m_dataResponse = m_dalCard.UpdateMoneyForCard(stCardID, iMoney, iMoneyEx);
return(JSonHelper.ConvertObjectToJSon(m_dataResponse));
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
try
{
bValidation = false;
BeforeUpdate();
if (bValidation == false)
{
MASTERMEMBER mmMst = (from mas in db.MASTERMEMBERs where mas.MEMBER_CODE == dMember_Code select mas).FirstOrDefault();
if (bUpdate == false)
{
DataView dv = new DataView(dtArrearPost);
dv.RowFilter = "AMOUNT>0";
int iTotalDuePay = dv.Count;
ArrearPostMaster arrearMaster = new ArrearPostMaster
{
MemberCode = dMember_Code,
EntryDate = DateTime.Now,
BeforeLastPaymentDate = mmMst.LASTPAYMENT_DATE,
BeforeTotalBF = mmMst.ACCBF,
BeforeTotalSubscription = mmMst.ACCSUBSCRIPTION,
BeforeTotalMonthsPaid = Convert.ToInt32(mmMst.TOTALMONTHSPAID),
TotalDuePay = iTotalDuePay,
UpdatedStatus = "Not Updated"
};
db.ArrearPostMasters.Add(arrearMaster);
db.SaveChanges();
var NewData = new JSonHelper().ConvertObjectToJSon(arrearMaster);
AppLib.EventHistory(this.Tag.ToString(), 0, "", NewData, "ArrearPostMaster");
DataTable dtTemp = new DataTable();
dtTemp = ((DataView)dgArrearPost.ItemsSource).ToTable();
var iMasterId = Convert.ToInt32(db.ArrearPostMasters.Max(x => x.ID));
List <ArrearPostDetail> lstArrearDtl = new List <ArrearPostDetail>();
foreach (DataRow row in dtTemp.Rows)
{
if (Convert.ToDecimal(row["AMOUNT"]) != 0)
{
ArrearPostDetail arrearDtl = new ArrearPostDetail
{
MasterId = iMasterId,
Year = Convert.ToInt32(row["YEAR"]),
Month = Convert.ToDateTime("1/" + row["MONTH"] + row["YEAR"]).Month,
TotalAmount = Convert.ToDecimal(row["AMOUNT"]),
AmounBF = Convert.ToDecimal(row["BF"]),
AmountInsurance = Convert.ToDecimal(row["INSURANCE"]),
AmountSubscription = Convert.ToDecimal(row["SUBSCRIPTION"]),
UpdatedStatus = "Not Updated",
MemberCode = Convert.ToInt32(dMember_Code)
};
lstArrearDtl.Add(arrearDtl);
}
}
if (lstArrearDtl.Count > 0)
{
db.ArrearPostDetails.AddRange(lstArrearDtl);
db.SaveChanges();
var NewData1 = new JSonHelper().ConvertObjectToJSon(lstArrearDtl);
AppLib.EventHistory(this.Tag.ToString(), 0, "", NewData1, "ArrearPostDetail");
}
MessageBox.Show("Details are Saved Sucessfully");
fClear();
}
else
{
ArrearPostMaster mst = (from mas in db.ArrearPostMasters where mas.ID == iArrearMst_ID select mas).FirstOrDefault();
var OldData = new JSonHelper().ConvertObjectToJSon(mst);
DataView dv = new DataView(dtArrearPost);
dv.RowFilter = "AMOUNT>0";
int iTotalDuePay = dv.Count;
if (mst != null)
{
mst.UpdatedEntryDate = DateTime.Now;
mst.IsEdited = true;
mst.TotalDuePay = iTotalDuePay;
}
db.SaveChanges();
var NewData = new JSonHelper().ConvertObjectToJSon(mst);
AppLib.EventHistory(this.Tag.ToString(), 1, OldData, NewData, "ArrearPostMaster");
ArrearPostDetail dtl = (from mas in db.ArrearPostDetails where mas.MasterId == iArrearMst_ID select mas).FirstOrDefault();
var OldData1 = new JSonHelper().ConvertObjectToJSon(dtl);
if (dtl != null)
{
db.ArrearPostDetails.RemoveRange(db.ArrearPostDetails.Where(x => x.MasterId == iArrearMst_ID));
db.SaveChanges();
}
DataTable dtTemp = new DataTable();
dtTemp = ((DataView)dgArrearPost.ItemsSource).ToTable();
List <ArrearPostDetail> lstArrearDtl = new List <ArrearPostDetail>();
foreach (DataRow row in dtTemp.Rows)
{
if (Convert.ToDecimal(row["AMOUNT"]) != 0)
{
ArrearPostDetail arrearDtl = new ArrearPostDetail
{
MasterId = iArrearMst_ID,
Year = Convert.ToInt32(row["YEAR"]),
Month = Convert.ToDateTime("1/" + row["MONTH"] + row["YEAR"]).Month,
TotalAmount = Convert.ToDecimal(row["AMOUNT"]),
AmounBF = Convert.ToDecimal(row["BF"]),
AmountInsurance = Convert.ToDecimal(row["INSURANCE"]),
AmountSubscription = Convert.ToDecimal(row["SUBSCRIPTION"]),
UpdatedStatus = "Not Updated",
MemberCode = Convert.ToInt32(dMember_Code)
};
lstArrearDtl.Add(arrearDtl);
}
}
if (lstArrearDtl.Count > 0)
{
db.ArrearPostDetails.AddRange(lstArrearDtl);
db.SaveChanges();
var NewData1 = new JSonHelper().ConvertObjectToJSon(lstArrearDtl);
AppLib.EventHistory(this.Tag.ToString(), 1, OldData1, NewData1, "ArrearPostDetail");
}
MessageBox.Show("Details are Updated Sucessfully");
fClear();
}
}
}
catch (Exception ex)
{
ExceptionLogging.SendErrorToText(ex);
}
}
public string UpdateCardState(string stCardID, bool bLocked)
{
m_dataResponse = m_dalCard.UpdateCardState(stCardID, bLocked);
return(JSonHelper.ConvertObjectToJSon(m_dataResponse));
}
private void DoDDPayment()
{
AndHUD.Shared.Show(this, "Please wait ...", -1, MaskType.Clear);
string url = Settings.InstanceURL;
var url2 = url + "/Api/MakeDebitPayment";
var amount = Decimal.Parse(this.et_Amount.Text);
if (Settings.MakePaymentIn3Part)
{
paymentType = 2;
}
else
if (Settings.MakePaymentInstallment)
{
paymentType = 3;
}
else
if (amount == Settings.TotalOutstanding)
{
Settings.MakePaymentInFull = true;
paymentType = 1;
}
else
if (amount < Settings.TotalOutstanding)
{
Settings.MakePaymentOtherAmount = true;
paymentType = 4;
}
var DebtorPaymentInstallment = "";
if (Settings.MakePaymentIn3Part || Settings.MakePaymentInstallment)
{
JSonHelper helper = new JSonHelper();
string jsonResult = helper.ConvertObjectToJSon(this.instalmentList);
DebtorPaymentInstallment = jsonResult;
}
var json2 = new
{
Item = new
{
ReferenceNumber = Settings.RefNumber,
Amount = this.et_Amount.Text,
DirectDebitAccountName = this.et_AccountName.Text,
DirectDebitAccountNumber = this.et_AccountNumber.Text,
DirectDebitBSB = this.et_BSB.Text,
PaymentType = paymentType,
PaymentMethod = "2",
DebtorPaymentInstallment = DebtorPaymentInstallment,
InstalmentPaymentFrequency = Settings.Frequency
}
};
try
{
var ObjectReturn2 = new PaymentReturnModel();
string results = ConnectWebAPI.Request(url2, json2);
if (string.IsNullOrEmpty(results))
{
AndHUD.Shared.Dismiss();
this.RunOnUiThread(() => this.bt_Continue.Enabled = true);
this.RunOnUiThread(() => alert = new Alert(this, "Error", Resources.GetString(Resource.String.NoServer)));
this.RunOnUiThread(() => alert.Show());
}
else
{
ObjectReturn2 = Newtonsoft.Json.JsonConvert.DeserializeObject <PaymentReturnModel>(results);
if (ObjectReturn2.IsSuccess)
{
TrackingHelper.SendTracking("Make DD Payment");
Intent Intent = new Intent(this, typeof(UpdatePersonalInformationActivity));
Intent.PutExtra("ScreenComeFrom", "MakeDDPayment");
//////////////////////////////////////////////////////////////////////////////////////////////////
Intent.PutExtra("tv_TransactionDescription", ObjectReturn2.TransactionDescription);
Intent.PutExtra("tv_ReceiptNumber", ObjectReturn2.ReceiptNumber);
Intent.PutExtra("tv_Amount", ObjectReturn2.Amount);
Intent.PutExtra("tv_Time", ObjectReturn2.Time);
Intent.PutExtra("tv_Date", ObjectReturn2.Date);
Intent.PutExtra("tv_Name", ObjectReturn2.Name);
Intent.PutExtra("PaymentMethod", 2);
Intent.PutExtra("PaymentType", this.paymentType);
Intent.PutExtra("PaymentId", ObjectReturn2.PaymentId);
Intent.PutExtra("ClientName", ObjectReturn2.ClientName);
Intent.PutExtra("FirstDebtorPaymentInstallmentId", ObjectReturn2.FirstDebtorPaymentInstallmentId);
StartActivity(Intent);
AndHUD.Shared.Dismiss();
this.Finish();
}
else
{
AndHUD.Shared.Dismiss();
this.RunOnUiThread(() => this.bt_Continue.Enabled = true);
this.RunOnUiThread(() => alert = new Alert(this, "Error", ObjectReturn2.Errors[0].ErrorMessage));
this.RunOnUiThread(() => alert.Show());
}
}
}
catch (Exception ee)
{
this.RunOnUiThread(() => this.bt_Continue.Enabled = true);
AndHUD.Shared.Dismiss();
}
}
public string GetCardReport(string stGasStationID, DateTime dateStart, DateTime dateEnd, string stCardID)
{
DataTransfer dataResult = m_dalCard.GetCardReport(stGasStationID, dateStart, dateEnd, stCardID);
return(JSonHelper.ConvertObjectToJSon(dataResult));
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
try
{
bValidation = false;
BeforeUpdate();
if (bValidation == false)
{
MASTERMEMBER mm = (from mas in db.MASTERMEMBERs where mas.MEMBER_CODE == dMember_Code select mas).FirstOrDefault();
//var OldData = new JSonHelper().ConvertObjectToJSon(mm);
if (mm != null)
{
mm.BANK_CODE = Convert.ToDecimal(cmbBankName.SelectedValue);
mm.BRANCH_CODE = Convert.ToDecimal(cmbBranchName.SelectedValue);
db.SaveChanges();
//var NewData = new JSonHelper().ConvertObjectToJSon(mm);
//AppLib.EventHistory(this.Tag.ToString(), 1, OldData, NewData, "MASTERMEMBER");
MemberTransfer mt = new MemberTransfer();
mt.EntryDate = DateTime.Now.Date;
mt.MemberCode = dMember_Code;
mt.BankCodeBF = dBankCodeBF;
mt.BranchCodeBF = dBranchCodeBF;
mt.BankCodeAF = Convert.ToDecimal(cmbBankCode.SelectedValue);
mt.BranchCodeAF = Convert.ToDecimal(cmbBranchCode.SelectedValue);
mt.UserId = AppLib.iUserCode;
db.MemberTransfers.Add(mt);
db.SaveChanges();
var NewData1 = new JSonHelper().ConvertObjectToJSon(mt);
//AppLib.EventHistory(this.Tag.ToString(), 0, "", NewData1, "MEMBERTRANSFER");
MessageBox.Show(txtMemberName.Text + " Member Has Tranfered Sucessfully");
if (MessageBox.Show("Do you want to Send Mail to NUBE?", "EMAIL Confirmation ", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
//string sMemberMailID = mm.EMAIL.ToString();
if (mm.EMAIL == null)
{
MessageBox.Show("This Member Does Not Contain any Email Address!");
fNew();
return;
}
else
{
progressBar1.Minimum = 1;
progressBar1.Maximum = 10;
progressBar1.Visibility = Visibility.Visible;
MailMessage mail = new MailMessage();
SmtpClient SmtpServer = new SmtpClient("smtp.gmail.com");
var mn = (from m in db.MASTERNAMESETUPs select m).FirstOrDefault();
mail.To.Add(mm.EMAIL.ToString());
if (mn != null)
{
mail.CC.Add(mn.CCEamilId1.ToString());
mail.CC.Add(mn.CCEamilId1.ToString());
}
mail.From = new MailAddress(mn.SenderEmailId.ToString());
mail.Subject = "NUBE TRANSFER MAIL";
mail.Body = "Dear Mr/Ms." + txtMemberName.Text.ToString() + ", \r" +
" Your Bank Transfer has Successfully Transfered \r\r" +
" Given Below the Bank & Branch Details are \r" +
" From " + txtBankName.Text.ToString() + " - " + txtBranchName.Text.ToString() + "\r" +
" To " + cmbBankName.Text.ToString() + " - " + cmbBranchName.Text.ToString();
progressBar1.Value = 2;
System.Windows.Forms.Application.DoEvents();
if (MessageBox.Show("Do you want to Attach any Files in this Email?", "EMAIL Attachment", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
progressBar1.Value = 4;
System.Windows.Forms.Application.DoEvents();
OpenFileDialog OpenDialogBox = new OpenFileDialog();
OpenDialogBox.DefaultExt = ".txt";
OpenDialogBox.Filter = "txt files (*.txt)|*.txt|All files (*.*)|*.*";
var browsefile = OpenDialogBox.ShowDialog();
if (browsefile == true)
{
progressBar1.Value = 6;
System.Windows.Forms.Application.DoEvents();
System.Net.Mail.Attachment attachment;
attachment = new System.Net.Mail.Attachment(OpenDialogBox.FileName.ToString());
mail.Attachments.Add(attachment);
}
}
progressBar1.Value = 7;
System.Windows.Forms.Application.DoEvents();
SmtpServer.Port = 587;
SmtpServer.Credentials = new System.Net.NetworkCredential(mn.SenderEmailId.ToString(), mn.SenderPassword.ToString());
SmtpServer.EnableSsl = true;
progressBar1.Value = 9;
System.Windows.Forms.Application.DoEvents();
SmtpServer.Send(mail);
progressBar1.Value = 10;
System.Windows.Forms.Application.DoEvents();
MessageBox.Show("Mail Send Sucessfully!");
progressBar1.Visibility = Visibility.Hidden;
}
}
fNew();
}
}
}
catch (Exception ex)
{
ExceptionLogging.SendErrorToText(ex);
}
}
/// <summary>
/// 高级查询
/// </summary>
/// <returns></returns>
public void Search()
{
try
{
//一页显示几行数据
string rows = HttpContext.Current.Request["rows"];
//当前页
string page = HttpContext.Current.Request["page"];
string value = HttpContext.Current.Request["data"];
string[] strr = value.Split('&');
string s_where = "1=1";
string s_csbbh = strr[0].Split('=')[1];
if (s_csbbh.Trim().Length > 0)
{
s_where = s_where + " and csbbh like '%" + s_csbbh + "%'";
}
string s_csbmc = strr[1].Split('=')[1];
if (s_csbmc.Trim().Length > 0)
{
s_where = s_where + " and csbmc like '%" + s_csbmc + "%'";
}
string s_csszy = strr[2].Split('=')[1];
if (s_csszy.Trim().Length > 0)
{
s_where = s_where + " and izyid='" + s_csszy + "'";
}
string s_cscx = strr[3].Split('=')[1];
if (s_cscx.Trim().Length > 0)
{
s_where = s_where + " and iscxid = '" + s_cscx + "'";
}
string s_cjllx = strr[4].Split('=')[1];
if (s_cjllx.Trim().Length > 0)
{
s_where = s_where + " and typename like '%" + s_cjllx + "%'";
}
string s_cdjr = strr[5].Split('=')[1];
if (s_cdjr.Trim().Length > 0)
{
s_where = s_where + " and cdjr like '%" + s_cdjr + "%'";
}
sys ex = new sys();
string s_dtp1 = strr[6].Split('=')[1];
if (ex.isDate(s_dtp1) == true)
{
s_dtp1 = s_dtp1.Replace("+", " "); //替换+为空，日期提交后格式为：2016-05-30+10:00:00
if (s_dtp1.Trim().Length > 0)
{
s_where = s_where + " and drq>= '" + s_dtp1 + "'";
}
}
string s_dtp2 = strr[7].Split('=')[1];
if (ex.isDate(s_dtp2) == true)
{
s_dtp2 = s_dtp2.Replace("+", " ");
if (s_dtp2.Trim().Length > 0)
{
s_where = s_where + " and drq<= '" + s_dtp2 + "'";
}
}
DataSet duser = SqlHelper.GetList("v_djjl", "*", "id", int.Parse(rows), int.Parse(page), false, true, s_where);
DataTable dt1 = duser.Tables[0];
//获取数据源
DataTable dt = SqlHelper.GetTable("select * from v_djjl where " + s_where + " order by drq desc");
string str = string.Empty;
//将数据转换成json格式
str = JSonHelper.CreateJsonParameters(dt1, true, dt.Rows.Count);
HttpContext.Current.Response.Write(str);
}
catch (Exception ex)
{
sys e = new sys();
e.GetLog(ex);
}
}
/// <summary>
/// 查询的方法
/// </summary>
private void Query(string csbid, string sState)
{
try
{
if (sState == "" || string.IsNullOrEmpty(sState))
{
HttpContext.Current.Response.Write("{ \"total\":0,\"rows\":[]");
return;
}
//一页显示几行数据
string rows = HttpContext.Current.Request["rows"];
//当前页
string page = HttpContext.Current.Request["page"];
string strWhere = "1=1";
if (!string.IsNullOrEmpty(sState) && sState == "s")
{
if (!string.IsNullOrEmpty(csbid))
{
strWhere = strWhere + " and isbid=" + csbid;
}
}
else
{
HttpContext.Current.Response.Write("{ \"total\":0,\"rows\":[]");
return;
}
string qsrq = HttpContext.Current.Request["qsrq"];
if (!string.IsNullOrEmpty(qsrq))
{
strWhere = strWhere + " and dzysj>='" + qsrq + "'";
}
string jzrq = HttpContext.Current.Request["jzrq"];
if (!string.IsNullOrEmpty(jzrq))
{
strWhere = strWhere + " and dzysj<='" + jzrq + "'";
}
string ckey = HttpContext.Current.Request["ckey"];
string ctext = HttpContext.Current.Request["cmemo"];
if (!string.IsNullOrEmpty(ckey))
{
switch (ckey)
{
case "设备编码":
strWhere = strWhere + " and csbbh like '%" + ctext + "%'";
break;
case "设备名称":
strWhere = strWhere + " and csbmc like '%" + ctext + "%'";
break;
case "生产线":
strWhere = strWhere + " and cscx like '%" + ctext + "%'";
break;
case "所属专业":
strWhere = strWhere + " and csszy like '%" + ctext + "%'";
break;
case "作业项目":
strWhere = strWhere + " and czyxm like '%" + ctext + "%'";
break;
case "作业人员":
strWhere = strWhere + " and czyry like '%" + ctext + "%'";
break;
case "制单人":
strWhere = strWhere + " and cczy like '%" + ctext + "%'";
break;
case "备注":
strWhere = strWhere + " and cbz like '%" + ctext + "%'";
break;
}
}
DataSet duser = SqlHelper.GetList("v_llb", "*", "dzysj", int.Parse(rows), int.Parse(page), false, true, strWhere);
DataTable dt1 = duser.Tables[0];
//获取数据源
DataTable dt = SqlHelper.GetTable("select * from v_llb where " + strWhere);
string str = string.Empty;
//将数据转换成json格式
str = JSonHelper.CreateJsonParameters(dt1, true, dt.Rows.Count);
HttpContext.Current.Response.Write(str);
}
catch (Exception ex)
{
sys e = new sys();
e.GetLog(ex);
}
}
/// <summary>
/// 查询的方法
/// </summary>
private void Query()
{
try
{
//一页显示几行数据
string rows = HttpContext.Current.Request["rows"];
//当前页
string page = HttpContext.Current.Request["page"];
string state = HttpContext.Current.Request["state"];
if (string.IsNullOrEmpty(state))
{
HttpContext.Current.Response.Write("{ \"total\":0,\"rows\":[]");
return;
}
string strWhere = "1=1";
string qsrq = HttpContext.Current.Request["qsrq"];
if (!string.IsNullOrEmpty(qsrq))
{
strWhere = strWhere + " and drq>='" + qsrq + "'";
}
string jzrq = HttpContext.Current.Request["jzrq"];
if (!string.IsNullOrEmpty(jzrq))
{
strWhere = strWhere + " and drq<='" + jzrq + "'";
}
string ckey = HttpContext.Current.Request["ckey"];
string ctext = HttpContext.Current.Request["cmemo"];
if (!string.IsNullOrEmpty(ckey))
{
switch (ckey)
{
case "对象":
strWhere = strWhere + " and cdx like '%" + ctext + "%'";
break;
case "对象名称":
strWhere = strWhere + " and cdxmc like '%" + ctext + "%'";
break;
case "记录":
strWhere = strWhere + " and cjl like '%" + ctext + "%'";
break;
case "制单人":
strWhere = strWhere + " and cczy like '%" + ctext + "%'";
break;
}
}
DataSet duser = SqlHelper.GetList("v_gcstz", "*", "id", int.Parse(rows), int.Parse(page), false, true, strWhere);
DataTable dt1 = duser.Tables[0];
//获取数据源
DataTable dt = SqlHelper.GetTable("select * from v_gcstz where " + strWhere + " order by drq desc");
string str = string.Empty;
//将数据转换成json格式
str = JSonHelper.CreateJsonParameters(dt1, true, dt.Rows.Count);
HttpContext.Current.Response.Write(str);
}
catch (Exception ex)
{
sys e = new sys();
e.GetLog(ex);
}
}
