private static FpList_tyfp CreateFpList_tyfp(string slbh)
{
FpList_tyfp fpList = new FpList_tyfp();
List <FC_H_QSDC> h_list = FCSFDAL.GetFC_H_QSDC_List(slbh);
fpList.addTime = DateTime.Now;
fpList.djlx = GetDJLX(slbh);
List <DJ_QLRGL> qlr_list = FCSFDAL.GetDyqr(slbh);
fpList.dyqr = GetDyqr(qlr_list);
fpList.FJZMJ = GetFJZMJ(h_list);
fpList.IsNew = "1";
fpList.Pgjz = FCSFDAL.GetPgjz(slbh);
fpList.qzbh = FCSFDAL.GetQzbh(slbh);
//fpList.SFDate=
//fpList.SFName=
fpList.SFState = "0";
fpList.syqr = GetSyqr(qlr_list);
fpList.TS = h_list.Count.ToString();
fpList.ysyqr = FCSFDAL.GetYsyqr(slbh);
fpList.Ywzh = slbh;
fpList.zl = GetZL(h_list);
fpList.zlxz = GetZL(h_list);
return(fpList);
}
internal static void UpdateFpList(FpList_tyfp fpList)
{
string sql = "update FpList_tyfp set syqr=@syqr,dyqr=@dyqr,qzbh=@qzbh,djlx=@djlx,zl=@zl,zlxz=@zlxz,FJZMJ=@FJZMJ,TS=@TS,Pgjz=@Pgjz,SFState=@SFState,IsNew=@IsNew,ysyqr=@ysyqr where Ywzh=@Ywzh";
List <DbParameter> list = new List <DbParameter>();
Sql_ListAdd(list, "@syqr", fpList.syqr);
Sql_ListAdd(list, "@dyqr", fpList.dyqr);
Sql_ListAdd(list, "@qzbh", fpList.qzbh);
Sql_ListAdd(list, "@djlx", fpList.djlx);
Sql_ListAdd(list, "@zl", fpList.zl);
Sql_ListAdd(list, "@zlxz", fpList.zlxz);
Sql_ListAdd(list, "@FJZMJ", fpList.FJZMJ);
Sql_ListAdd(list, "@TS", fpList.TS);
Sql_ListAdd(list, "@Pgjz", fpList.Pgjz);
Sql_ListAdd(list, "@SFState", fpList.SFState);
Sql_ListAdd(list, "@IsNew", fpList.IsNew);
Sql_ListAdd(list, "@ysyqr", fpList.ysyqr);
Sql_ListAdd(list, "@Ywzh", fpList.Ywzh);
lock (lockKey)
{
DbHelper dbHelper = new DbHelper();
dbHelper.SetProvider(MyDBType.Other);
dbHelper.ExecuteNonQuery(MyDBType.Other, System.Data.CommandType.Text, sql, list.ToArray());
}
}
internal static void InsertFpList(FpList_tyfp fpList)
{
string sql = "insert into FpList_tyfp (Ywzh,syqr,dyqr,qzbh,djlx,zl,zlxz,FJZMJ,TS,Pgjz,SFState,IsNew,ysyqr) " +
"values(@Ywzh,@syqr,@dyqr,@qzbh,@djlx,@zl,@zlxz,@FJZMJ,@TS,@Pgjz,@SFState,@IsNew,@ysyqr)";
List <DbParameter> list = new List <DbParameter>();
Sql_ListAdd(list, "@Ywzh", fpList.Ywzh);
Sql_ListAdd(list, "@syqr", fpList.syqr);
Sql_ListAdd(list, "@dyqr", fpList.dyqr);
Sql_ListAdd(list, "@qzbh", fpList.qzbh);
Sql_ListAdd(list, "@djlx", fpList.djlx);
Sql_ListAdd(list, "@zl", fpList.zl);
Sql_ListAdd(list, "@zlxz", fpList.zlxz);
Sql_ListAdd(list, "@FJZMJ", fpList.FJZMJ);
Sql_ListAdd(list, "@TS", fpList.TS);
Sql_ListAdd(list, "@Pgjz", fpList.Pgjz);
Sql_ListAdd(list, "@SFState", fpList.SFState);
Sql_ListAdd(list, "@IsNew", fpList.IsNew);
Sql_ListAdd(list, "@ysyqr", fpList.ysyqr);
lock (lockKey)
{
DbHelper dbHelper = new DbHelper();
dbHelper.SetProvider(MyDBType.Other);
dbHelper.ExecuteNonQuery(MyDBType.Other, System.Data.CommandType.Text, sql, list.ToArray());
}
}
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 void PushSF(FpList_tyfp fpList, List <FpmxList_tyfp> fpmx)
{
//using (var scope = new System.Transactions.TransactionScope())
//{
bool canUpdate = IsCanUpdate(fpList.Ywzh);
if (ExistFpList(fpList.Ywzh))
{
if (canUpdate)
{
UpdateFpList(fpList);
}
}
else
{
InsertFpList(fpList);
}
if (null != fpmx && fpmx.Count > 0)
{
foreach (var fp in fpmx)
{
if (ExistFpmx(fp.Ywzh, fp.类型))
{
if (canUpdate)
{
DeleteFpmx(fp);
InsertFpmx(fp);
}
}
else
{
InsertFpmx(fp);
}
}
}
// scope.Complete();
//}
}
