private static void InsertLog(FC_SF_TAG tag)
{
if (FCSFDAL.ExistTag(tag))
{
FCSFDAL.UpdateTag(tag);
}
else
{
FCSFDAL.InsertLog(tag);
}
}
public static BDCFilterResult PushSF(PageParams param)
{
BDCFilterResult res = new BDCFilterResult();
FC_SF_TAG tag = new FC_SF_TAG();
try
{
List <DJ_SFD> sfd_list = FCSFDAL.GetSFD(param.PrjId);
if (null != sfd_list)
{
foreach (DJ_SFD sfd in sfd_list)
{
FpList_tyfp fpList = CreateFpList_tyfp(sfd.SLBH);
List <FpmxList_tyfp> fpmx = GetFpmxList_tyfp(sfd.SLBH);
FCSFDAL.PushSF(fpList, fpmx);
}
res.IsSuccess = true;
res.Message = "成功";
}
else
{
res.IsSuccess = true;
res.Message = "表单验证失败，获取收费单数据";
}
}
catch (Exception ex)
{
res.IsSuccess = false;
res.Message = ex.Message;
}
try
{
tag.ID = Guid.NewGuid().ToString();
tag.ISSUCCESS = res.IsSuccess ? "1" : "0";
tag.MESSAGE = res.Message;
tag.PUSHDATE = DateTime.Now;
tag.PUSHUSER = param.UserName;
tag.SLBH = param.PrjId;
InsertLog(tag);
}
catch (Exception ex)
{
res.Message = ex.Message;
}
return(res);
}
internal static bool ExistTag(FC_SF_TAG tag)
{
string sql = "select count(1) from FC_SF_Tag where slbh='{0}'";
sql = string.Format(sql, tag.SLBH);
lock (lockKey)
{
DbHelper dbHelper = new DbHelper();
dbHelper.SetProvider(MyDBType.Oracle);
object o = dbHelper.ExecuteScalar(MyDBType.Oracle, System.Data.CommandType.Text, sql, null);
//object o = dbHelper.ExecuteScalar("FCSF",true, System.Data.CommandType.Text, sql, null);
int count = Convert.ToInt32(o);
if (count > 0)
{
return(true);
}
return(false);
}
}
internal static void UpdateTag(FC_SF_TAG tag)
{
//string sql = "update FC_SF_TAG set ID=@ID,PUSHUSER=@PUSHUSER,PUSHDATE=@PUSHDATE,ISSUCCESS=@ISSUCCESS,MESSAGE=@MESSAGE where SLBH=@SLBH";
//List<DbParameter> list = new List<DbParameter>();
//ListAdd(list, "@ID", tag.ID);
//ListAdd(list, "@PUSHUSER", tag.PUSHUSER);
//ListAdd(list, "@PUSHDATE", tag.PUSHDATE);
//ListAdd(list, "@ISSUCCESS", tag.ISSUCCESS);
//ListAdd(list, "@MESSAGE", tag.MESSAGE);
//ListAdd(list, "@SLBH", tag.SLBH);
string sql = "update FC_SF_TAG set ID='{0}',PUSHUSER='******',PUSHDATE=to_date('{2}','yyyy-mm-dd hh24:mi:ss'),ISSUCCESS={3},MESSAGE='{4}' where SLBH='{5}'";
sql = string.Format(sql, tag.ID, tag.PUSHUSER, tag.PUSHDATE, tag.ISSUCCESS, tag.MESSAGE, tag.SLBH);
lock (lockKey)
{
DbHelper dbHelper = new DbHelper();
dbHelper.SetProvider(MyDBType.Oracle);
//dbHelper.ExecuteNonQuery(MyDBType.Oracle, System.Data.CommandType.Text, sql, list.ToArray());
dbHelper.ExecuteNonQuery(MyDBType.Oracle, System.Data.CommandType.Text, sql, null);
}
}
public static BDCFilterResult CheckSFState(PageParams param)
{
BDCFilterResult res = new BDCFilterResult();
List <DJ_SFD> list = FCSFDAL.GetXCSFState(param.PrjId);
if (null != list && list.Count > 0)
{
foreach (DJ_SFD sfd in list)
{
FC_SF_TAG tag = new FC_SF_TAG();
tag.SLBH = sfd.SLBH;
tag.ID = Guid.NewGuid().ToString();
tag.PUSHDATE = DateTime.Now;
tag.PUSHUSER = param.UserName;
if (sfd.SFZT.Contains("已缴费") || string.IsNullOrEmpty(sfd.ZZSFZT))
{
tag.ISSUCCESS = true.ToString();
tag.MESSAGE = "缴费成功";
}
else
{
JFStateModel model = new JFStateModel(sfd.SLBH);
if (model.CODE.Equals("00"))
{
tag.ISSUCCESS = true.ToString();
tag.MESSAGE = "缴费成功";
if (sfd.YSJE != model.ZFJE)
{
tag.ISSUCCESS = false.ToString();
tag.MESSAGE = "应缴金额与实际缴费金额不符";
}
if (!model.SLBH.Equals(sfd.SLBH))
{
tag.ISSUCCESS = false.ToString();
tag.MESSAGE = "业务宗号与缴费业务宗号不符";
}
if (tag.ISSUCCESS.Equals(true.ToString()))
{
sfd.ZZSFZT = "1";
sfd.ZZSFZFFS = model.ZFFS;
sfd.DYSJ = TryParse(model.ZFSJ);
sfd.SSJE = model.ZFJE;
sfd.DYR = "自助缴费";
sfd.SKRQ = TryParse(model.ZFSJ);
sfd.SFZT = "已缴费";
UpdateSFD_SFZT(sfd);
}
}
else
{
tag.ISSUCCESS = false.ToString();
tag.MESSAGE = model.ERRMSG;//"缴费失败!";
}
}
if (tag.ISSUCCESS.Equals(false.ToString()))
{
res.IsSuccess = false;
res.Message = tag.MESSAGE;
InsertLog(tag);
break;
}
InsertLog(tag);
}
}
else
{
res.IsSuccess = false;
res.Message = "未查询到相关流程";
}
return(res);
}
