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); }