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