/// <summary>
/// 算费回滚方法
/// </summary>
/// <param name="pgid"></param>
/// <param name="clientInf"></param>
/// <param name="t"></param>
private void CountRollBackJS(string pgid, string clientInf, Eva.Library.Data.AccessDataTrans.IAccessDataTrans t)
{
sara.dd.ldsw.idal.Itbl_ld_khb idal_tbl_ld_khb = new sara.dd.ldsw.dal.tbl_ld_khb();
//查询评估下的全部客户,并修改客户的累积欠费字段
string querycbsql = "select F_KHBHID,F_BQJE from TBL_LD_CBIAO where F_PGBHID='" + pgid + "' and F_ZTID='2'";
DataTable dt = t.Query(querycbsql).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
//获取客户信息,并修改客户的累积欠费字段
IList <sara.dd.ldsw.model.tbl_ld_khb> ml = idal_tbl_ld_khb.GetList("sys_id = ('" + dt.Rows[i]["f_khbhid"] + "') ", "", "*", "", "", t);
if (ml.Count > 0)
{
sara.dd.ldsw.model.tbl_ld_khb model_tbl_ld_khb = ml[0];
string f_ljqf_old = model_tbl_ld_khb.f_ljqf;
double ljqf = Eva.Library.Text.NumberTool.Parse(model_tbl_ld_khb.f_ljqf);
ljqf -= Eva.Library.Text.NumberTool.Parse(dt.Rows[i]["f_bqje"].ToString());
model_tbl_ld_khb.f_ljqf = Eva.Library.Text.NumberTool.GetNumberByLength(ljqf.ToString(), 2);
#region 客户表写日志
List <IDictionary <string, string> > array = new List <IDictionary <string, string> >();
IDictionary <string, string> f_ljqf = new Dictionary <string, string>();
f_ljqf.Add("key", "f_ljqf");
f_ljqf.Add("oldvalue", f_ljqf_old);
f_ljqf.Add("newvalue", model_tbl_ld_khb.f_ljqf);
f_ljqf.Add("name", "累计欠费");
array.Add(f_ljqf);
sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_khb", model_tbl_ld_khb.sys_id.ToString(), "tbl_ld_cben_cbiao_treelist", "算费", array, clientInf, t);
#endregion
idal_tbl_ld_khb.Update(model_tbl_ld_khb, "f_ljqf", t);
IList <sara.dd.ldsw.model.tbl_ld_pgb> pgb = _idal_tbl_ld_pgb.GetList("sys_id = '" + pgid + "' ", "", "*", "", "", t);
sara.dd.ldsw.model.tbl_ld_pgb model = pgb[0];
#region 算费回滚写日志
List <IDictionary <string, string> > arr = new List <IDictionary <string, string> >();
IDictionary <string, string> temp = new Dictionary <string, string>();
temp.Add("key", "rollback");
temp.Add("oldvalue", "算费编号：" + model.f_pgbh + " 算费批次名称：" + model.f_pgpcmc);
temp.Add("newvalue", "");
temp.Add("name", "算费回滚");
arr.Add(temp);
sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_pgb", model.sys_id.ToString(), "tbl_ld_pgb_detail", "算费回滚", arr, clientInf, t);
#endregion
}
}
//处理减免信息
int flag = 0;
string queryjmsql = "select SYS_ID,F_CB_CBBH FROM TBL_LD_CBIAO where F_PGBHID='" + pgid + "' and F_ZTID='2' and F_JMBHID is not null";
dt = t.Query(queryjmsql).Tables[0];
string jmids = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
jmids += dt.Rows[i]["sys_id"] + ",";
}
jmids = jmids.TrimEnd(',');
if (jmids != "")
{
//更新抄表记录中的减免数据
string updatecbsql = "update TBL_LD_CBIAO set F_JMBH='',F_JMBHID='',F_JMJE='0' where SYS_ID in(" + jmids + ")";
flag = t.ExecuteSql(updatecbsql);
//更新减免表的数据
string updatejmsql = "update TBL_LD_JMB set F_CBBH='',F_CBBHID='',F_ZTID='0',F_ZT='新建' where F_CBBHID in(" + jmids + ")";
flag = t.ExecuteSql(updatejmsql);
}
//更新评估表的数据
string updatepgsql = "update TBL_LD_PGB set F_ZTID='2',F_ZT='已回滚' where SYS_ID='" + pgid + "'";
flag = t.ExecuteSql(updatepgsql);
//更新抄表表的数据
string updatesql = "update TBL_LD_CBIAO set F_ZT='已抄表',F_ZTID='1',F_SF='0',F_PWF='0',F_BQJE='0',F_SFJL='' where F_PGBHID='" + pgid + "' and F_ZTID='2'";
flag = t.ExecuteSql(updatesql);
}
public string ycDHPay(string paynostr, string wdstr, string sfystr, string gmrq, string khbh, decimal je)
{
try
{
sara.dd.ldsw.idal.Itbl_ld_cbiao _idal_tbl_ld_cbiao = new sara.dd.ldsw.dal.tbl_ld_cbiao();
sara.dd.ldsw.idal.Itbl_ld_khb _idal_tbl_ld_khb = new sara.dd.ldsw.dal.tbl_ld_khb();
sara.dd.ldsw.idal.Itbl_ld_jfb idal_tbl_ld_jfb = new sara.dd.ldsw.dal.tbl_ld_jfb();
List <sara.dd.ldsw.model.tbl_ld_cbiao> modellist = _idal_tbl_ld_cbiao.GetList(" f_khbh='" + khbh + "' and f_ztid='2' and (f_cbbh like 'DH%' or f_cbbh like 'ZB%')", "false", "", "*", "", "", null);
List <sara.dd.ldsw.model.tbl_ld_khb> khmodellist = _idal_tbl_ld_khb.GetList(" f_khbh='" + khbh + "'", "", "*", "", "", null);
if (modellist.Count == 1 && Eva.Library.Text.NumberTool.Parse(modellist[0].f_bqje) == (double)je)
{
sara.dd.ldsw.model.tbl_ld_cbiao model = modellist[0];
sara.dd.ldsw.model.tbl_ld_khb khmodel = khmodellist[0];
#region 创建缴费记录
//时间信息
DateTimeFormatInfo dtFormat = new DateTimeFormatInfo();
dtFormat.ShortDatePattern = "yyyy/MM/dd";
System.DateTime currentTime = new System.DateTime();
currentTime = System.DateTime.Now;
DateTime blankTime = DateTime.Parse("1900-01-01");
sara.dd.ldsw.model.tbl_ld_jfb jfmodel = new model.tbl_ld_jfb();
//jfmodel.sys_id = int.Parse(idal_tbl_ld_jfb.GetMaxId(null));
jfmodel.sys_creatuserid = "1564";
jfmodel.sys_creatusername = "******";
jfmodel.sys_creatdate = currentTime;
jfmodel.sys_lastedituserid = "1564";
jfmodel.sys_lasteditusername = "******";
jfmodel.sys_lasteditdate = currentTime;
jfmodel.sys_deldate = blankTime;
jfmodel.sys_delflag = "0";
jfmodel.f_jfbh = commonclass.commonclass.getBusinessNum("JF", "", null);
jfmodel.f_jfrq = currentTime;
jfmodel.f_jffs = "邮储代缴大用户";
jfmodel.f_jffsid = "05740014";
jfmodel.f_jcfs = "全额找零";
jfmodel.f_jcfsid = "05750001";
jfmodel.f_yyy = "PBT";
jfmodel.f_yyyid = "1564";
jfmodel.f_czsj = currentTime;
jfmodel.f_sfykfp = "false";
jfmodel.f_zt = "已提交";
jfmodel.f_ztid = "2";
jfmodel.f_khbh = khmodel.f_khbh;
jfmodel.f_khbhid = khmodel.sys_id.ToString();
jfmodel.f_yhbh = khmodel.f_yhbh;
jfmodel.f_yhbhid = khmodel.f_yhbhid;
jfmodel.f_yhm = khmodel.f_yhm;
jfmodel.f_jfm = khmodel.f_jfm;
jfmodel.f_dh = khmodel.f_dh;
jfmodel.f_dz = khmodel.f_dz;
jfmodel.f_dy = khmodel.f_dy;
jfmodel.f_dyid = khmodel.f_dyid;
jfmodel.f_sc = khmodel.f_sc;
jfmodel.f_scid = khmodel.f_scid;
jfmodel.f_qy = khmodel.f_qy;
jfmodel.f_qyid = khmodel.f_qyid;
jfmodel.f_pq = khmodel.f_pq;
jfmodel.f_pqid = khmodel.f_pqid;
jfmodel.f_sbbh = khmodel.f_sbbh;
jfmodel.f_sbbhid = khmodel.f_sbbhid;
jfmodel.f_sblx = khmodel.f_sblx;
jfmodel.f_sblxid = khmodel.f_sblxid;
jfmodel.f_yslx = khmodel.f_yslx;
jfmodel.f_yslxid = khmodel.f_yslxid;
jfmodel.f_lxtkhh = khmodel.f_lxth;
jfmodel.f_rs = khmodel.f_rs;
jfmodel.f_cbbh = model.f_cb_cbbh;
jfmodel.f_cbbhid = model.sys_id.ToString();
jfmodel.f_cbyslj = model.f_bqje;
jfmodel.f_sllj = model.f_bqsl;
jfmodel.f_sflj = model.f_sf;
jfmodel.f_pwflj = model.f_pwf;
jfmodel.f_dj = Eva.Library.Text.NumberTool.GetNumberByLength(Eva.Library.Text.NumberTool.Parse(jfmodel.f_cbyslj) / Eva.Library.Text.NumberTool.Parse(jfmodel.f_sllj), 2);
jfmodel.f_jmhyslj = model.f_bqje;
jfmodel.f_khytjjzsf = khmodel.f_tjjzsf;
jfmodel.f_khytjjzpwf = khmodel.f_tjjzpwf;
jfmodel.f_sfsytjjz = "false";
jfmodel.f_sytjjzsf = "0";
jfmodel.f_sytjjzpwf = "0";
jfmodel.f_syhtjjzsf = khmodel.f_tjjzsf;
jfmodel.f_syhtjjzpwf = khmodel.f_tjjzpwf;
jfmodel.f_khyye = khmodel.f_ycje;
jfmodel.f_sfsyye = "false";
jfmodel.f_syye = "0";
jfmodel.f_yhye = khmodel.f_ycje;
jfmodel.f_shys = model.f_bqje;
jfmodel.f_shss = model.f_bqje;
jfmodel.f_hszl = "0";
jfmodel.f_shssdx = sara.dd.ldsw.commonclass.commonclass.num2String((Eva.Library.Text.NumberTool.Parse(jfmodel.f_cbyslj)));
jfmodel.f_khfz = khmodel.f_khfz;
jfmodel.f_khfzid = khmodel.f_khfzid;
jfmodel.f_cbenbh = khmodel.f_cbbh;
jfmodel.f_cbenbhid = khmodel.f_cbbhid;
jfmodel.f_ljqf = khmodel.f_ljqf;
jfmodel.f_jmjelj = "0";
jfmodel.f_ly = "邮储银行缴费";
jfmodel.f_lyid = "08080008";
jfmodel.f_sfjl = model.f_sfjl;
//插入缴费表
string jfsysid = idal_tbl_ld_jfb.Add(jfmodel, null);
#endregion
#region 更新抄表表
model.f_zt = "已缴费";
model.f_ztid = "3";
model.f_jfbh = jfmodel.f_jfbh;
model.f_jfbhid = jfsysid;
model.f_jfsj = jfmodel.f_jfrq;
_idal_tbl_ld_cbiao.Update(model, "f_zt,f_ztid,f_jfbh,f_jfbhid,f_jfsj", null);
#endregion
#region 更新客户表
khmodel.f_ljqf = "0";
_idal_tbl_ld_khb.Update(khmodel, "f_ljqf", null);
List <IDictionary <string, string> > array = new List <IDictionary <string, string> >();
IDictionary <string, string> temp = null;
temp = new Dictionary <string, string>();
temp.Add("key", "f_ljqf");
temp.Add("oldvalue", khmodel.f_ljqf);
temp.Add("newvalue", "0");
temp.Add("name", "累计欠费");
array.Add(temp);
sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_khb", model.f_khbhid.ToString(), "tbl_ld_jfb_detail", "邮储代缴大用户", array, "", null);
#endregion
#region 增加对账记录
_iAccessData = sara.dd.ldsw.commonclass.commonclass.CreateIAccessData();
string sql = "insert into TBL_LD_YCXZJL (f_lsh,f_wd,f_sfy,f_gmrq,f_khbh,f_gmsl,f_sfje,f_lx,sys_id) VALUES ('" + paynostr + "','" + wdstr + "','" + sfystr + "','" + gmrq + "','" + khbh + "','" + model.f_bqsl + "','" + je + "','DH',SEQ_TBL_LD_YCXZJL.nextval)";
int ins = _iAccessData.ExecuteSql(sql);
if (ins > 0)
{
return("true");
}
else
{
return("false");
}
#endregion
}
else
{
//销账状态
return("false");
}
}
catch (Exception ex)
{
//程序异常
return("error");
}
}
