171 lines
7.5 KiB
C#
171 lines
7.5 KiB
C#
using System;
|
||
using System.Collections.Generic;
|
||
using System.Data;
|
||
using System.Linq;
|
||
using System.Web.UI;
|
||
using System.Web.UI.WebControls;
|
||
using SuperMap.RealEstate.CoreFrameWork;
|
||
using SuperMap.RealEstate.ServiceModel;
|
||
using SuperMap.RealEstate.Utility;
|
||
using SuperMap.RealEstate.Web.UI;
|
||
using SuperMap.RealEstate.Web.UI.WebControls;
|
||
using SuperMap.RealEstate.Web.Utility;
|
||
using SuperMap.RealEstate.ExchangeData.Business;
|
||
using Business = SuperMap.RealEstate.HighWay.SellData.Business;
|
||
|
||
namespace SuperMap.RealEstate.HighWay.Modules.EndAccountSeparate
|
||
{
|
||
public partial class ENDACCOUNTPage : SuperMap.RealEstate.Web.UI.Page
|
||
{
|
||
|
||
protected void Page_Load(object sender, EventArgs e)
|
||
{
|
||
if (IsPostBack) return;
|
||
//载入数据
|
||
ButtonDelete.Enabled = ENDACCOUNT1.LoadData();
|
||
//设置删除提示
|
||
SetControlConfirm(ButtonDelete, "您确认删除该记录,删除后将无法恢复数据?");
|
||
//设置按钮状态
|
||
SetControlClientAction(ButtonDelete, false, true, true);
|
||
SetControlClientAction(ButtonSave);
|
||
//注册遮罩式窗口关闭脚本
|
||
SetControlClosePopDialog(ButtonClose);
|
||
try
|
||
{
|
||
if (!string.IsNullOrEmpty(Request["SERVERPART_ID"]))
|
||
{
|
||
Storage.Business.SERVERPART _SERVERPART = new Storage.Business.SERVERPART(Transaction);
|
||
_SERVERPART.SERVERPART_ID_Encrypt = Request["SERVERPART_ID"];
|
||
if (_SERVERPART.Select())
|
||
{
|
||
List<COMMODITYMACHINE> MACHINEINFOList = new COMMODITYMACHINE(Transaction).FillCollection(
|
||
"WHERE SERVERPARTCODE = '" + _SERVERPART.SERVERPART_CODE + "' AND SHOPCODE = '" +
|
||
Request["SHOPCODE"].ToDecrypt() + "' AND MACHINE_ENDDATE > SYSDATE - 1/48");
|
||
if (MACHINEINFOList.Count == 0 && (_SERVERPART.ExecuteDataTable(
|
||
"SELECT 1 FROM HIGHWAY_STORAGE.T_CONNECTPOINT WHERE SERVERPARTCODE = '" +
|
||
_SERVERPART.SERVERPART_CODE + "' AND SHOPCODE = '" + Request["SHOPCODE"].ToDecrypt() +
|
||
"' AND CONNECT_DATE > SYSDATE - 1 / 144").Rows.Count > 0))
|
||
{
|
||
BtnDownLod.Visible = true;
|
||
}
|
||
}
|
||
}
|
||
}
|
||
catch { }
|
||
}
|
||
|
||
protected void ButtonSave_Click(object sender, EventArgs e)
|
||
{
|
||
try
|
||
{
|
||
//刷新类型
|
||
bool _RefreshType = ButtonDelete.Enabled;
|
||
//保存数据
|
||
ButtonDelete.Enabled = ENDACCOUNT1.Save();
|
||
//刷新弹出页列表
|
||
RefreshOpenerGridPage(_RefreshType ? RefreshGridPageType.Update : RefreshGridPageType.Insert);
|
||
//提示信息
|
||
Alert("保存成功!", 3);
|
||
ClosePopDialog();
|
||
}
|
||
catch (Exception ex)
|
||
{
|
||
//回滚事务
|
||
Transaction.Rollback();
|
||
//记录日志
|
||
ErrorLogHelper.Write(ex);
|
||
#if DEBUG
|
||
Alert("保存失败!可能的原因:\n" + ex.Message);
|
||
#else
|
||
Alert("保存失败!");
|
||
#endif
|
||
}
|
||
}
|
||
|
||
protected void ButtonDelete_Click(object sender, EventArgs e)
|
||
{
|
||
try
|
||
{
|
||
//删除数据
|
||
ButtonDelete.Enabled = !ENDACCOUNT1.Delete();
|
||
//刷新弹出页列表
|
||
RefreshOpenerGridPage(RefreshGridPageType.Delete);
|
||
//提示信息
|
||
Alert("删除成功!", 3);
|
||
ClosePopDialog();
|
||
}
|
||
catch (Exception ex)
|
||
{
|
||
//回滚事务
|
||
Transaction.Rollback();
|
||
//记录日志
|
||
ErrorLogHelper.Write(ex);
|
||
#if DEBUG
|
||
Alert("删除失败!可能的原因:\n" + ex.Message);
|
||
#else
|
||
Alert("删除失败!");
|
||
#endif
|
||
}
|
||
}
|
||
|
||
protected void BtnDownLod_Click(object sender, EventArgs e)
|
||
{
|
||
if (!string.IsNullOrEmpty(Request["SERVERPART_ID"]))
|
||
{
|
||
Storage.Business.SERVERPART _SERVERPART = new Storage.Business.SERVERPART(Transaction);
|
||
_SERVERPART.SERVERPART_ID_Encrypt = Request["SERVERPART_ID"];
|
||
if (_SERVERPART.Select())
|
||
{
|
||
List<MACHINEINFO> MACHINEINFOList = new MACHINEINFO(Transaction).FillCollection(
|
||
"WHERE SERVERPARTCODE = '" + _SERVERPART.SERVERPART_CODE + "' AND SHOPCODE = '" +
|
||
Request["SHOPCODE"].ToDecrypt() + "'");
|
||
foreach (MACHINEINFO _MACHINEINFO in MACHINEINFOList)
|
||
{
|
||
COMMODITYMACHINE _COMMODITYMACHINE = new COMMODITYMACHINE(Transaction);
|
||
_COMMODITYMACHINE.AddSearchParameter("SERVERPARTCODE", _MACHINEINFO.SERVERPARTCODE);
|
||
_COMMODITYMACHINE.AddSearchParameter("SHOPCODE", _MACHINEINFO.SHOPCODE);
|
||
_COMMODITYMACHINE.AddSearchParameter("MACHINE_MACADDRESS", _MACHINEINFO.MACHINE_MACADDRESS);
|
||
_COMMODITYMACHINE.AddSearchParameter("HANDWAY", "openapp");
|
||
_COMMODITYMACHINE.AddSearchParameter("HANDCONTENT", "dbsyc.exe");
|
||
if (_COMMODITYMACHINE.Search())
|
||
{
|
||
_COMMODITYMACHINE.FLAG = 1;
|
||
_COMMODITYMACHINE.DOWNLOAD_STATE = 1;
|
||
_COMMODITYMACHINE.UPLOAD_STATE = null;
|
||
_COMMODITYMACHINE.MACHINE_STARTDATE = DateTime.Now.Date;
|
||
_COMMODITYMACHINE.MACHINE_ENDDATE = DateTime.Now;
|
||
_COMMODITYMACHINE.Update();
|
||
}
|
||
else
|
||
{
|
||
_COMMODITYMACHINE.ResetProperty();
|
||
_COMMODITYMACHINE.SERVERPARTCODE = _MACHINEINFO.SERVERPARTCODE;
|
||
_COMMODITYMACHINE.SHOPCODE = _MACHINEINFO.SHOPCODE;
|
||
_COMMODITYMACHINE.MACHINE_MACADDRESS = _MACHINEINFO.MACHINE_MACADDRESS;
|
||
_COMMODITYMACHINE.MACHINENAME = _MACHINEINFO.MACHINENAME;
|
||
_COMMODITYMACHINE.MACHINE_IP = _MACHINEINFO.MACHINE_IP;
|
||
_COMMODITYMACHINE.HANDWAY = "openapp";
|
||
_COMMODITYMACHINE.HANDCONTENT = "dbsyc.exe";
|
||
_COMMODITYMACHINE.FLAG = 1;
|
||
_COMMODITYMACHINE.DOWNLOAD_STATE = 1;
|
||
_COMMODITYMACHINE.REPEAT_STATE = 0;
|
||
_COMMODITYMACHINE.MACHINE_STARTDATE = DateTime.Now.Date;
|
||
_COMMODITYMACHINE.MACHINE_ENDDATE = DateTime.Now;
|
||
_COMMODITYMACHINE.Insert();
|
||
}
|
||
}
|
||
if (MACHINEINFOList.Count > 0)
|
||
{
|
||
Alert("正在尝试上传日结数据,整个过程大约20分钟。请稍后...!", 3);
|
||
Refresh();
|
||
}
|
||
else
|
||
{
|
||
Alert("收银机配置信息不正确,请联系驿网客服!");
|
||
}
|
||
}
|
||
}
|
||
}
|
||
}
|
||
}
|