// 将通信方法调用接入
private void Append_CommMethodNav()
{
if (commMethod_ComboBox.SelectedItem is null)
{
ResourceManager.mainWindowVM.Tips = "需要选定要接入的通信方法！";
return;
}
CommMethod commMethod = (CommMethod)commMethod_ComboBox.SelectedItem;
// 生成通信方法调用的提示字符串并接入
int paramNum = commMethod.Parameters.Count;
string commMethodCallStr = commMethod.Name + "(";
if (paramNum == 0)
{
commMethodCallStr += ")";
}
else
{
for (int i = 0; i < paramNum - 1; i++)
{
commMethodCallStr += "?, ";
}
commMethodCallStr += "?)";
}
Append_Symbol(commMethodCallStr);
}
/// <summary>
/// 根据交款ID得到预交金交款表对象
/// </summary>
/// <param name="rpt">预交金交款表对象</param>
/// <param name="Accountid">交款ID</param>
public void GetAccountRptInfo(AbstractChargeAccountRpt rpt, int[] Accountids, int type)
{
AllAccount Account = new AllAccount();
decimal total_fee = 0;
decimal cash_fee = 0;
decimal pos_fee = 0;
decimal wticketfee = 0;
decimal wticketnum = 0;
decimal bticketfee = 0;
decimal bticketnum = 0;
CommMethod.list_AddString.Clear();
List <ZY_Account> zyAccounts = Account.GetAccounts(Accountids, type);
ZY_Account zyAccount = null;
for (int i = 0; i < zyAccounts.Count; i++)
{
zyAccount = zyAccounts[i];
rpt.交款人 = CommMethod.AddString(zyAccount.AccountName);
total_fee += zyAccount.Total_Fee;
cash_fee += zyAccount.Cash_Fee;
pos_fee += zyAccount.POS_Fee;
wticketfee += zyAccount.WTicketFee;
wticketnum += zyAccount.WTicketNum;
bticketfee += zyAccount.BTicketFee;
bticketnum += zyAccount.BTicketNum;
}
rpt.交款时间 = zyAccount.AccountDate.ToString();
rpt.总金额 = total_fee.ToString();
rpt.总金额大写 = total_fee.ToString();
rpt.现金金额 = cash_fee.ToString();
rpt.POS金额 = pos_fee.ToString();
rpt.收费金额 = wticketfee.ToString();
rpt.收费张数 = wticketnum.ToString();
rpt.退费金额 = bticketfee.ToString();
rpt.退费张数 = bticketnum.ToString();
rpt.次交款时间 = zyAccount.LastDate.ToString();
rpt.医院名称 = HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.WorkName;
string[] AccountIDs = new string[Accountids.Length];
for (int i = 0; i < AccountIDs.Length; i++)
{
AccountIDs[i] = Accountids[i].ToString();
}
List <ZY_ChargeList> zy_Chargelist = zyAccount.GetChargeData(AccountIDs, -1);
for (int i = 0; i < zy_Chargelist.Count; i++)
{
zy_Chargelist[i].ChargeType = zy_Chargelist[i].FeeType == 0 ? "现金" : "POS";
zy_Chargelist[i].PatName = HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.GetPatName(zy_Chargelist[i].PatID);
}
rpt.预交金记录 = HIS.SYSTEM.PubicBaseClasses.ApiFunction.ObjToDataTable(zy_Chargelist);
}
public void Add_CommMethodPair()
{
ComboBox processA_ComboBox = ControlExtensions.FindControl <ComboBox>(this, "processA_ComboBox");
if (processA_ComboBox.SelectedItem == null)
{
ResourceManager.mainWindowVM.Tips = "需要选定发送方进程模板！";
return;
}
Process processA = (Process)processA_ComboBox.SelectedItem;
ComboBox processB_ComboBox = ControlExtensions.FindControl <ComboBox>(this, "processB_ComboBox");
if (processB_ComboBox.SelectedItem == null)
{
ResourceManager.mainWindowVM.Tips = "需要选定接收方进程模板！";
return;
}
Process processB = (Process)processB_ComboBox.SelectedItem;
ComboBox commMethodA_ComboBox = ControlExtensions.FindControl <ComboBox>(this, "commMethodA_ComboBox");
if (commMethodA_ComboBox.SelectedItem == null)
{
ResourceManager.mainWindowVM.Tips = "需要选定发送方法！";
return;
}
CommMethod commMethodA = (CommMethod)commMethodA_ComboBox.SelectedItem;
if (commMethodA.InOutSuffix != InOut.Out)
{
ResourceManager.mainWindowVM.Tips = "发送方法必须是Out！";
return;
}
ComboBox commMethodB_ComboBox = ControlExtensions.FindControl <ComboBox>(this, "commMethodB_ComboBox");
if (commMethodB_ComboBox.SelectedItem == null)
{
ResourceManager.mainWindowVM.Tips = "需要选定接收方法！";
return;
}
CommMethod commMethodB = (CommMethod)commMethodB_ComboBox.SelectedItem;
if (commMethodB.InOutSuffix != InOut.In)
{
ResourceManager.mainWindowVM.Tips = "接收方法必须是In！";
return;
}
CommMethodPair commMethodPair = new CommMethodPair(processA, commMethodA, processB, commMethodB);
((CommChannel_EW_VM)DataContext).CommChannel.CommMethodPairs.Add(commMethodPair);
ResourceManager.mainWindowVM.Tips = "已添加成员：" + commMethodPair;
}
public void Delete_CommMethod()
{
ListBox commMethod_ListBox = ControlExtensions.FindControl <ListBox>(this, "commMethod_ListBox");
if (commMethod_ListBox.SelectedItem == null)
{
ResourceManager.mainWindowVM.Tips = "需要选定要删除的CommMethod！";
return;
}
CommMethod commMethod = (CommMethod)commMethod_ListBox.SelectedItem;
((Process_EW_VM)DataContext).Process.CommMethods.Remove(commMethod);
ResourceManager.mainWindowVM.Tips = "已删除CommMethod：" + commMethod.ShowString;
}
public void Update_CommMethod()
{
ListBox commMethod_ListBox = ControlExtensions.FindControl <ListBox>(this, "commMethod_ListBox");
if (commMethod_ListBox.SelectedItem == null)
{
ResourceManager.mainWindowVM.Tips = "需要选定要更新的CommMethod！";
return;
}
ComboBox inout_ComboBox = ControlExtensions.FindControl <ComboBox>(this, "inout_ComboBox");
if (inout_ComboBox.SelectedItem == null)
{
ResourceManager.mainWindowVM.Tips = "需要选定CommMethod的输入/输出类型！";
return;
}
TextBox commMethodName_TextBox = ControlExtensions.FindControl <TextBox>(this, "commMethodName_TextBox");
if (commMethodName_TextBox.Text == null || commMethodName_TextBox.Text.Length == 0)
{
ResourceManager.mainWindowVM.Tips = "需要给出CommMethod的方法名！";
return;
}
ObservableCollection <Attribute> parameters = ((Process_EW_VM)DataContext).CommParams;
if (parameters.Count == 0)
{
ResourceManager.mainWindowVM.Tips = "至少要在形参表中添加一个参数！";
return;
}
CommMethod commMethod = new CommMethod(
commMethodName_TextBox.Text,
parameters,
(InOut)inout_ComboBox.SelectedItem
);
((Process_EW_VM)DataContext).Process.CommMethods[commMethod_ListBox.SelectedIndex] = commMethod;
ResourceManager.mainWindowVM.Tips = "更新了CommMethod：" + commMethod;
// 更新完成后,要将临时参数列表拿掉,这样再向临时参数列表中添加/更新内容也不会影响刚刚添加的CommMethod
((Process_EW_VM)DataContext).CommParams = new ObservableCollection <Attribute>();
}
/// <summary>
/// 根据交款ID得到结算交款表对象
/// </summary>
/// <param name="rpt">结算交款表对象</param>
/// <param name="Accountid">交款ID</param>
public void GetAccountRptInfo(AbstractCostAccountRpt rpt, int[] Accountids, int type)
{
AllAccount zyAccount = new AllAccount();
List <ZY_Account> zyAccounts = zyAccount.GetAccounts(Accountids, type);
CommMethod.list_AddString.Clear();
for (int i = 0; i < zyAccounts.Count; i++)
{
rpt.交款人 = CommMethod.AddString(zyAccounts[i].AccountName);
}
rpt.医院名称 = HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.WorkName + "住院每日缴款清单";
rpt.交款时间 = zyAccounts[0].AccountDate.ToString();
#region 发票项目
DataTable dt = zyAccount.GetTicketTotle(Accountids);
decimal AllKMFee = 0;
//dt = null;
for (int i = 0; i < dt.Rows.Count; i++)
{
AllKMFee += Convert.ToDecimal(dt.Rows[i]["Tolal_Fee"]);
}
#endregion
rpt.发票项目 = dt;
rpt.发票科目合计 = AllKMFee.ToString();
List <ZY_CostMaster> zy_CML = zyAccount.GetCostData(Accountids);
if (zy_CML != null && zy_CML.Count > 0)
{
#region 收费票据
rpt.收费发票开始号 = zy_CML[0].TicketCode;
rpt.收费发票结束号 = zy_CML[zy_CML.Count - 1].TicketCode;
rpt.收费发票张数 = zy_CML.Count.ToString();
List <ZY_CostMaster> zy_CMLx = zy_CML.FindAll(delegate(ZY_CostMaster x) { return(x.Record_Flag == 2); });
rpt.收费退费张数 = zy_CMLx.Count.ToString();
rpt.收费退费金额 = zy_CMLx.Sum(x => x.Total_Fee).ToString();
rpt.废票张数 = zyAccount.GetBadTicketCount(Accountids).ToString();
#endregion
#region 记账部分
DataTable dt1 = BaseDataFactory.GetData(baseDataType.病人类型);
List <AccountPatType> apts = new List <AccountPatType>();
AccountPatType apt;
int AllNum = 0;
for (int i = 0; i < dt1.Rows.Count; i++)
{
List <ZY_CostMaster> zy_CMLy = zy_CML.FindAll(delegate(ZY_CostMaster y) { return(y.PatType.Trim() == dt1.Rows[i]["code"].ToString()); });
apt = new AccountPatType();
apt.TypeName = dt1.Rows[i]["name"].ToString();
apt.CostNum = zy_CMLy.Count.ToString();
apt.CostFee = zy_CMLy.Sum(x => x.NotWorkUnit_Fee).ToString();
apts.Add(apt);
AllNum += zy_CMLy.Count;
}
apt = new AccountPatType();
//单位
List <ZY_CostMaster> zy_CMLy5 = zy_CML.FindAll(delegate(ZY_CostMaster y) { return(y.WorkUnit_Fee != 0); });
apt.TypeName = "单位";
apt.CostNum = zy_CMLy5.Count.ToString();
apt.CostFee = zy_CMLy5.Sum(y => y.WorkUnit_Fee).ToString();
apts.Add(apt);
//合计
apt = new AccountPatType();
apt.TypeName = "合计";
apt.CostNum = (AllNum + zy_CMLy5.Count).ToString();
apt.CostFee = zy_CML.Sum(y => y.Village_Fee).ToString();
apts.Add(apt);
rpt.记账内容 = apts.ToArray();
#endregion
#region 收现金
rpt.优惠金额 = zy_CML.Sum(z => z.Favor_Fee).ToString();
rpt.应收金额 = zy_CML.Sum(z => z.Self_Fee).ToString();
rpt.预收金额 = zy_CML.Sum(z => z.Deptosit_Fee).ToString();
decimal decR = zy_CML.Sum(z => z.Reality_Fee);
//补收
List <ZY_CostMaster> zy_CML11 = zy_CML.FindAll(delegate(ZY_CostMaster y) { return(y.Reality_Fee > 0); });
//补退
List <ZY_CostMaster> zy_CML22 = zy_CML.FindAll(delegate(ZY_CostMaster y) { return(y.Reality_Fee < 0); });
//欠费
List <ZY_CostMaster> zy_CML33 = zy_CML.FindAll(delegate(ZY_CostMaster y) { return(y.Ntype == 3); });
rpt.补收金额 = zy_CML11.Sum(x => x.Reality_Fee).ToString("0.00");
rpt.补退金额 = (0 - zy_CML22.Sum(x => x.Reality_Fee)).ToString("0.00");
rpt.实收金额 = decR.ToString();
rpt.小写合计 = decR.ToString();
rpt.大写合计 = decR.ToString();
List <ZY_ChargeList> zy_cl = zyAccount.GetChargeListData(Accountids);
//现金
List <ZY_ChargeList> zy_cl0 = zy_cl.FindAll(x => x.FeeType == 0);
//POS
List <ZY_ChargeList> zy_cl1 = zy_cl.FindAll(x => x.FeeType == 1);
rpt.预交金现金 = zy_cl0.Sum(x => x.Total_Fee).ToString();
rpt.预交金POS = zy_cl1.Sum(x => x.Total_Fee).ToString();
rpt.补收金额现金 = zy_CML11.Sum(x => x.Money_Fee).ToString();
rpt.补收金额POS = zy_CML11.Sum(x => x.Pos_Fee).ToString();
rpt.费金额 = zy_CML33.Sum(x => (x.Self_Fee - x.Deptosit_Fee)).ToString();
#endregion
}
}
public void Update_CommMethod()
{
ListBox commMethod_ListBox = ControlExtensions.FindControl <ListBox>(this, "commMethod_ListBox");
if (commMethod_ListBox.SelectedItem == null)
{
ResourceManager.mainWindowVM.Tips = "需要选定要更新的CommMethod！";
return;
}
ComboBox commWay_ComboBox = ControlExtensions.FindControl <ComboBox>(this, "commWay_ComboBox");
if (commWay_ComboBox.SelectedItem == null)
{
ResourceManager.mainWindowVM.Tips = "需要选定CommMethod的通信方式！";
return;
}
ComboBox inout_ComboBox = ControlExtensions.FindControl <ComboBox>(this, "inout_ComboBox");
if (inout_ComboBox.SelectedItem == null)
{
ResourceManager.mainWindowVM.Tips = "需要选定CommMethod的输入/输出类型！";
return;
}
TextBox commMethodName_TextBox = ControlExtensions.FindControl <TextBox>(this, "commMethodName_TextBox");
if (commMethodName_TextBox.Text == null || commMethodName_TextBox.Text.Length == 0)
{
ResourceManager.mainWindowVM.Tips = "需要给出CommMethod的方法名！";
return;
}
ObservableCollection <Attribute> parameters = ((Process_EW_VM)DataContext).CommParams;
if (parameters.Count == 0)
{
ResourceManager.mainWindowVM.Tips = "至少要在形参表中添加一个参数！";
return;
}
CommMethod commMethod = (CommMethod)commMethod_ListBox.SelectedItem;
if (commMethodName_TextBox.Text != commMethod.Name && Checker.Process_Contain_PropName(VM.Process, commMethodName_TextBox.Text))
{
ResourceManager.mainWindowVM.Tips = "标识符重复！";
return;
}
// 类型号
TextBox typeId_TextBox = ControlExtensions.FindControl <TextBox>(this, nameof(typeId_TextBox));
if (typeId_TextBox.Text == null)
{
typeId_TextBox.Text = "";
}
commMethod.Name = commMethodName_TextBox.Text;
commMethod.Parameters = parameters;
commMethod.InOutSuffix = (InOut)inout_ComboBox.SelectedItem;
commMethod.CommWay = (CommWay)commWay_ComboBox.SelectedItem;
commMethod.TypeId = typeId_TextBox.Text; // 类型号
ResourceManager.mainWindowVM.Tips = "更新了CommMethod：" + commMethod.ShowString;
// 更新完成后,要将临时参数列表拿掉,这样再向临时参数列表中添加/更新内容也不会影响刚刚添加的CommMethod
((Process_EW_VM)DataContext).CommParams = new ObservableCollection <Attribute>();
}
public void Add_CommMethod()
{
ComboBox commWay_ComboBox = ControlExtensions.FindControl <ComboBox>(this, "commWay_ComboBox");
if (commWay_ComboBox.SelectedItem == null)
{
ResourceManager.mainWindowVM.Tips = "需要选定CommMethod的通信方式！";
return;
}
ComboBox inout_ComboBox = ControlExtensions.FindControl <ComboBox>(this, "inout_ComboBox");
if (inout_ComboBox.SelectedItem == null)
{
ResourceManager.mainWindowVM.Tips = "需要选定CommMethod的输入/输出类型！";
return;
}
TextBox commMethodName_TextBox = ControlExtensions.FindControl <TextBox>(this, "commMethodName_TextBox");
if (commMethodName_TextBox.Text == null || commMethodName_TextBox.Text.Length == 0)
{
ResourceManager.mainWindowVM.Tips = "需要给出CommMethod的方法名！";
return;
}
// 类型号
TextBox typeId_TextBox = ControlExtensions.FindControl <TextBox>(this, nameof(typeId_TextBox));
if (typeId_TextBox.Text == null)
{
typeId_TextBox.Text = "";
}
if (Checker.Process_Contain_PropName(VM.Process, commMethodName_TextBox.Text))
{
ResourceManager.mainWindowVM.Tips = "标识符重复！";
return;
}
ObservableCollection <Attribute> parameters = ((Process_EW_VM)DataContext).CommParams;
if (parameters.Count == 0)
{
ResourceManager.mainWindowVM.Tips = "至少要在形参表中添加一个参数！";
return;
}
CommMethod commMethod = new CommMethod(
commMethodName_TextBox.Text,
parameters,
(InOut)inout_ComboBox.SelectedItem,
(CommWay)commWay_ComboBox.SelectedItem
);
commMethod.TypeId = typeId_TextBox.Text; // 类型号
((Process_EW_VM)DataContext).Process.CommMethods.Add(commMethod);
ResourceManager.mainWindowVM.Tips = "添加了CommMethod：" + commMethod.ShowString;
// 添加完成后,要将临时参数列表拿掉,这样再向临时参数列表中添加/更新内容也不会影响刚刚添加的CommMethod
// ((Process_EW_VM)DataContext).CommParams = new ObservableCollection<Attribute>();
// 【11月10日bugfix】更新完成后，将这个临时参数表复制一份保留
ObservableCollection <Attribute> tmp = new ObservableCollection <Attribute>();
foreach (Attribute attribute in ((Process_EW_VM)DataContext).CommParams)
{
tmp.Add(new Attribute(attribute));
}
((Process_EW_VM)DataContext).CommParams = tmp;
}
/// <summary>
///根据结算ID数组得到预交金对象集（交款表汇总-打印结算交款表用）
/// </summary>
/// <param name="AccountID"></param>
/// <returns></returns>
public List <ZY_ChargeList> GetChargeListData(int[] AccountIDs)
{
string strWhere = " DELETE_FLAG in (select costmasterid from zy_costmaster where accountid in (" + CommMethod.ToString(AccountIDs) + ") ) ";
return(BindEntity <ZY_ChargeList> .CreateInstanceDAL(oleDb).GetListArray(strWhere));
}
/// <summary>
/// 根据结算ID数组得到结算对象集（交款表汇总-打印结算交款表用）
/// </summary>
/// <param name="AccountID"></param>
/// <returns></returns>
public List <ZY_CostMaster> GetCostData(int[] AccountIDs)
{
string strWhere = "ACCOUNTID in (" + CommMethod.ToString(AccountIDs) + ")" + oleDb.OrderBy("ACCOUNTID");
return(BindEntity <ZY_CostMaster> .CreateInstanceDAL(oleDb).GetListArray(strWhere));
}
public decimal[] GetTotleType(int[] AccountIDs)
{
decimal[] dec = new decimal[3];
string strsql = @"select sum(TOTAL_FEE) as tolal_fee
from {ZY_COSTORDER} where COSTID IN( (select COSTMASTERID from {ZY_COSTMASTER} where ACCOUNTID in (" + CommMethod.ToString(AccountIDs) + @") ) ) and BIGITEMCODE in ('00','01','02','03')";
object obj = oleDb.GetDataResult(strsql);
dec[0] = obj == null ? 0 : Convert.ToDecimal(obj);
strsql = @"select sum(TOTAL_FEE) as tolal_fee
from {ZY_COSTORDER} where COSTID IN( (select COSTMASTERID from {ZY_COSTMASTER} where ACCOUNTID in (" + CommMethod.ToString(AccountIDs) + @") ) ) and BIGITEMCODE not in ('00','01','02','03')";
obj = oleDb.GetDataResult(strsql);
dec[1] = obj == null ? 0 : Convert.ToDecimal(obj);
dec[2] = 0;
return(dec);
}
/// <summary>
/// 根据结算ID数组得到交款对象集（交款表汇总-打印结算交款表用）
/// </summary>
/// <param name="AccountIDs">结算ID数组</param>
/// <returns>交款对象集</returns>
public List <ZY_Account> GetAccounts(int[] AccountIDs, int type)
{
List <ZY_Account> zyAccounts = BindEntity <ZY_Account> .CreateInstanceDAL(oleDb).GetListArray(" AccountType=" + type + " and accountid in (" + CommMethod.ToString(AccountIDs) + ")");
for (int i = 0; i < zyAccounts.Count; i++)
{
zyAccounts[i].AccountName = BaseNameFactory.GetName(baseNameType.用户名称, zyAccounts[i].AccountCode);
}
return(zyAccounts);
}
/// <summary>
///添加（修改）操作
/// </summary>
private void AddInfo()
{
string sql = "";
int adKind = 0, display = 0;
if (yFlash.Checked == true)
{
adKind = 1;
}
else
{
adKind = 0;
}
if (nDisplay.Checked == true)
{
display = 1;
}
else
{
display = 0;
}
//品牌图片路径
string[] uploadeAddress = null;
//上传的文件名
string[] filename = null;
long maxSize = long.Parse(ConfigurationManager.AppSettings.Get("newsPicSize"));
string message = CommMethod.uploadFile(HttpContext.Current.Server.MapPath("~/upload_pic"), null, ".jpg.gif.png.bmp.swf", maxSize, out uploadeAddress, out filename);
string picurl = "upload_pic" + uploadeAddress[0];
if (id == 0)
{
if (uploadeAddress[0] != null)
{
sql = "insert into FY_advertise(adKind,adPath,adPx,adPosition,adDetail,adCompany,addtime,title,linkUrl,display) values(" + adKind + ",'" + Sys.filterSQLStr(picurl) + "','"
+ Sys.filterSQLStr(txtadPx.Text.Trim()) + "','" + Sys.filterSQLStr(txtadPosition.Value.Trim()) + "','" + Sys.filterSQLStr(txtadDetail.Text.Trim()) + "','"
+ Sys.filterSQLStr(txtadCompany.Value.Trim()) + "',getdate(),'" + Sys.filterSQLStr(this.txt_title.Value.Trim()) + "','" + Sys.filterSQLStr(this.txt_linkUrl.Value.Trim()) + "'," + display + ")";
int succtag = SqlHelper.ExecuteNonQuery(SqlHelper.ConnString_insert, CommandType.Text, sql);
if (succtag > 0)
{
succtag = 1;
scripthelp.AlertAndRedirect("保存操作成功!", "ad_list.aspx", this.Page);
}
else
{
scripthelp.Alert("保存操作失败!", this.Page);
return;
}
}
else
{
scripthelp.Alert(message, this.Page);
return;
}
}
else
{
if (uploadeAddress[0] == null)
{
picurl = this.oldPic.Value;
if (string.IsNullOrEmpty(picurl))
{
scripthelp.Alert("上传的文件不能为空！", this.Page);
return;
}
}
string str = "select * from FY_advertise where id=" + Convert.ToInt32(Request.QueryString["id"].ToString());
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString_select, CommandType.Text, str).Tables[0];
if (dt.Rows.Count < 0)
{
return;
}
else
{
string adPath = dt.Rows[0]["adPath"].ToString();
if (File.Exists(Server.MapPath(adPath)))
{
File.Delete(Server.MapPath(adPath));
}
}
sql = "update FY_advertise set adKind=" + adKind + ",adPath='" + picurl + "',"
+ "adPx='" + Sys.filterSQLStr(txtadPx.Text.Trim()) + "',adPosition='" + Sys.filterSQLStr(txtadPosition.Value.Trim()) + "',"
+ "adDetail='" + Sys.filterSQLStr(txtadDetail.Text.Trim()) + "',adCompany='" + Sys.filterSQLStr(txtadCompany.Value.Trim()) + "',"
+ "addtime=getdate(),title='" + Sys.filterSQLStr(txt_title.Value.Trim()) + "',linkUrl='" + Sys.filterSQLStr(txt_linkUrl.Value.Trim()) + "',display=" + display + " where id =" + id + "";
int succtag = SqlHelper.ExecuteNonQuery(SqlHelper.ConnString_insert, CommandType.Text, sql);
if (succtag > 0)
{
succtag = 1;
scripthelp.AlertAndRedirect("保存操作成功!", "ad_list.aspx", this.Page);
}
else
{
scripthelp.Alert("保存操作失败!", this.Page);
return;
}
}
}
public void Update_CommMethodPair()
{
ListBox commMethodPair_ListBox = ControlExtensions.FindControl <ListBox>(this, "commMethodPair_ListBox");
if (commMethodPair_ListBox.SelectedItem == null)
{
ResourceManager.mainWindowVM.Tips = "需要在域内成员列表中选定要修改的成员！";
return;
}
ComboBox processA_ComboBox = ControlExtensions.FindControl <ComboBox>(this, "processA_ComboBox");
if (processA_ComboBox.SelectedItem == null)
{
ResourceManager.mainWindowVM.Tips = "需要选定发送方进程模板！";
return;
}
Process processA = (Process)processA_ComboBox.SelectedItem;
ComboBox processB_ComboBox = ControlExtensions.FindControl <ComboBox>(this, "processB_ComboBox");
if (processB_ComboBox.SelectedItem == null)
{
ResourceManager.mainWindowVM.Tips = "需要选定接收方进程模板！";
return;
}
Process processB = (Process)processB_ComboBox.SelectedItem;
ComboBox commMethodA_ComboBox = ControlExtensions.FindControl <ComboBox>(this, "commMethodA_ComboBox");
if (commMethodA_ComboBox.SelectedItem == null)
{
ResourceManager.mainWindowVM.Tips = "需要选定发送方法！";
return;
}
CommMethod commMethodA = (CommMethod)commMethodA_ComboBox.SelectedItem;
if (commMethodA.InOutSuffix != InOut.Out)
{
ResourceManager.mainWindowVM.Tips = "发送方法必须是Out！";
return;
}
ComboBox commMethodB_ComboBox = ControlExtensions.FindControl <ComboBox>(this, "commMethodB_ComboBox");
if (commMethodB_ComboBox.SelectedItem == null)
{
ResourceManager.mainWindowVM.Tips = "需要选定接收方法！";
return;
}
CommMethod commMethodB = (CommMethod)commMethodB_ComboBox.SelectedItem;
if (commMethodB.InOutSuffix != InOut.In)
{
ResourceManager.mainWindowVM.Tips = "接收方法必须是In！";
return;
}
CommMethodPair commMethodPair = (CommMethodPair)commMethodPair_ListBox.SelectedItem;
commMethodPair.ProcessA = processA;
commMethodPair.CommMethodA = commMethodA;
commMethodPair.ProcessB = processB;
commMethodPair.CommMethodB = commMethodB;
ResourceManager.mainWindowVM.Tips = "已更新成员：" + commMethodPair;
}
public System.Data.DataTable GetTicketTotle(int[] AccountIDs)
{
string strsql = @"select itemname,sum(tolal_fee) as tolal_fee
from
(select (select itemname from (select a.CODE,b.ITEM_NAME as itemname from {base_stat_item as a},{base_stat_zyfp as b} where a.ZYFP_CODE = b.code ) aa where aa.code = BIGITEMCODE ) itemname ,
SUM(TOTAL_FEE) as tolal_fee
from {ZY_COSTORDER}
where COSTID IN( (select COSTMASTERID from {ZY_COSTMASTER} where ACCOUNTID in (" + CommMethod.ToString(AccountIDs) + @") ) )
Group BY BIGITEMCODE ) a group by itemname ";
//strsql = String.Format(strsql, AccountID);
return(oleDb.GetDataTable(strsql));
}
/// <summary>
/// 根据结算ID数组得到得到废票张数（交款表汇总-打印结算交款表用）
/// </summary>
/// <param name="AccountID"></param>
/// <returns></returns>
public int GetBadTicketCount(int[] AccountIDs)
{
string strWhere = "ACCOUNTID in (" + CommMethod.ToString(AccountIDs) + ")";
return(Convert.ToInt32(BindEntity <object> .CreateInstanceDAL(oleDb, "ZY_BADTICKET").GetFieldValue("count(*)", strWhere)));
}
public void FileRequest(IPEndPoint remote, string path)
{
DialogResult dr = MessageBox.Show("是否保存文件：是[保存并打开]，否[仅打开]", "选择", MessageBoxButtons.YesNoCancel);
string fileSavePath = "";
if (dr == DialogResult.Yes)
{
SaveFileDialog sfdlg = new SaveFileDialog();
sfdlg.DefaultExt = path.Substring(path.LastIndexOf("."));
sfdlg.RestoreDirectory = true;
if (sfdlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
fileSavePath = sfdlg.FileName;
}
}
else if (dr == DialogResult.No)
{
int loca = path.LastIndexOf('\\');
//int DateTime.Now.ToString format, fff... stands for milliseconds
//for example ss-ffff:57-2141
fileSavePath = recvTmpPath + "\\" + DateTime.Now.ToString("yyyyMMddHHmmss") + "_";
string fileSaveName;
while (true)
{
fileSaveName = CommMethod.RandString(4) + "_";
if (loca > 0)
{
fileSaveName += path.Substring(loca + 1);
}
else
{
fileSaveName += path;
}
FileInfo fs = new FileInfo(fileSavePath + fileSaveName);
if (!fs.Exists)
{
fileSavePath += fileSaveName;
break;
}
}
}
else
{
return;
}
FileWaitObjcet fwo = new FileWaitObjcet();
fwo.ID = CommMethod.RandString(FileWaitObjcet.IDLength);
fwo.SavePath = fileSavePath;
fileWaitMutex.WaitOne();
while (dicFileWait.ContainsKey(fwo.ID))
{
fwo.ID = CommMethod.RandString(FileWaitObjcet.IDLength);
}
dicFileWait.Add(fwo.ID, fwo);
fileWaitMutex.ReleaseMutex();
FileRequestObjcet fro = new FileRequestObjcet(fwo.ID, netc.LocalFileRecvIEP, path);
netc.SendTCPString(remote, FileRequestHead + fro.ToString());
}
public void Update_CommMethodPair()
{
if (commMethodPair_ListBox.SelectedItem == null)
{
ResourceManager.mainWindowVM.Tips = "需要在通信方法序对列表中选定要修改的成员！";
return;
}
if (processA_ComboBox.SelectedItem == null)
{
ResourceManager.mainWindowVM.Tips = "需要选定发送方进程模板！";
return;
}
Process processA = (Process)processA_ComboBox.SelectedItem;
if (processB_ComboBox.SelectedItem == null)
{
ResourceManager.mainWindowVM.Tips = "需要选定接收方进程模板！";
return;
}
Process processB = (Process)processB_ComboBox.SelectedItem;
if (commMethodA_ComboBox.SelectedItem == null)
{
ResourceManager.mainWindowVM.Tips = "需要选定发送方法！";
return;
}
CommMethod commMethodA = (CommMethod)commMethodA_ComboBox.SelectedItem;
if (commMethodA.InOutSuffix != InOut.Out)
{
ResourceManager.mainWindowVM.Tips = "发送方法必须是Out！";
return;
}
if (commMethodB_ComboBox.SelectedItem == null)
{
ResourceManager.mainWindowVM.Tips = "需要选定接收方法！";
return;
}
CommMethod commMethodB = (CommMethod)commMethodB_ComboBox.SelectedItem;
if (commMethodB.InOutSuffix != InOut.In)
{
ResourceManager.mainWindowVM.Tips = "接收方法必须是In！";
return;
}
ObservableCollection <CommMethodPair> commMethodPairs = VM.CommChannel.CommMethodPairs;
// 判重
foreach (CommMethodPair cmp in commMethodPairs)
{
if (
cmp.ProcessA == processA &&
cmp.ProcessB == processB &&
cmp.CommMethodA == commMethodA &&
cmp.CommMethodB == commMethodB
)
{
ResourceManager.mainWindowVM.Tips = "无效的操作。该通信方法序对已经添加过";
return;
}
}
bool privacy = privacy_CheckBox.IsChecked == null ? false : (bool)privacy_CheckBox.IsChecked;
CommMethodPair commMethodPair = (CommMethodPair)commMethodPair_ListBox.SelectedItem;
commMethodPair.ProcessA = processA;
commMethodPair.CommMethodA = commMethodA;
commMethodPair.ProcessB = processB;
commMethodPair.CommMethodB = commMethodB;
commMethodPair.Privacy = privacy;
ResourceManager.mainWindowVM.Tips = "已更新成员：" + commMethodPair;
}
