private static void InsertLog(MZ_YGFP_TAG tag) { if (YGFPDAL.ExistTag(tag)) { YGFPDAL.UpdateTag(tag); } else { YGFPDAL.InsertLog(tag); } }
internal static bool ExistTag(MZ_YGFP_TAG tag) { string sql = "select count(1) from MZ_YGFP_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(MZ_YGFP_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 MZ_YGFP_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.ToString(), 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); } }
internal static BDCFilterResult PushData(PageParams param) { List <BDCFilterResult> resList = new List <BDCFilterResult>(); MZ_YGFP nonghu = YGFPDAL.CheckPerson(param.PrjId); //判断是否推送 if (null != nonghu) { try { //需推送阳光扶贫接口 DataTable dt = GetYGFPModel(param.PrjId, nonghu.CardID); //判断是否直接推送接口 if (PostToYGFP.Equals("是")) { List <YGFPModel> models = ModelHelper <YGFPModel> .FillModel(dt); foreach (YGFPModel model in models) { try { model.IDCard = nonghu.CardID; string paramStr = GetParams(model); ReturnValue rv = SendPost(paramStr); if (rv.result == "1") { resList.Add(new BDCFilterResult { IsSuccess = true, Message = "推送成功" }); } else { resList.Add(new BDCFilterResult { IsSuccess = false, Message = rv.message }); } } catch (Exception ex) { resList.Add(new BDCFilterResult { IsSuccess = false, Message = ex.Message }); continue; } } if (resList.Count == 0) { } } //无法推送直接导出EXCEL else { if (File.Exists(YGFPExcelPath)) { DataTable old_dt = DataTableRenderToExcel.RenderDataTableFromExcel(YGFPExcelPath); dt.Merge(old_dt, true, MissingSchemaAction.Ignore); } int flag = DataTableRenderToExcel.RenderDataTableToExcel(dt, YGFPExcelPath); if (flag == 1) { resList.Add(new BDCFilterResult { IsSuccess = true, Message = "推送成功" }); } else { resList.Add(new BDCFilterResult { IsSuccess = false, Message = "推送失败" }); } } } catch (Exception ex) { resList.Add(new BDCFilterResult { IsSuccess = false, Message = ex.Message }); } foreach (BDCFilterResult res in resList) { MZ_YGFP_TAG tag = new MZ_YGFP_TAG(); 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; try { InsertLog(tag); } catch (Exception ex) { string str = ex.Message; } } return(resList[0]); } return(new BDCFilterResult { IsSuccess = true, Message = "OK" }); }