/// <summary>
/// 取消上传后
/// </summary>
/// <param name="list">数据信息 为list 集合 类似于datatable 比dt 轻量</param>
/// <param name="model"></param>
/// <param name="db"></param>
/// <param name="transaction"></param>
public void AfterCancel(List <IDictionary <string, object> > list, EACmpCategory model, IDbConnection db, IDbTransaction transaction)
{
var info = db.Query <dynamic>("select * from lsbzdw where rownum=1 ", transaction: transaction).ToList();
var diclist = info.Select(x => (IDictionary <string, object>)x).ToList();
throw new Exception("不能取消上传" + model.ID + "单位数据" + Newtonsoft.Json.JsonConvert.SerializeObject(diclist));
}
/// <summary>
/// 确认上传后
/// </summary>
/// <param name="list"></param>
/// <param name="model"></param>
/// <param name="db"></param>
/// <param name="transaction"></param>
public void AfterUpload(List <IDictionary <string, object> > list, EACmpCategory model, IDbConnection db, IDbTransaction transaction)
{
//var count = db.ExecuteScalar<int>("select count(*) from lsbzdw ", transaction: transaction);
//throw new Exception("不能上传" + model.ID + "单位个数" + count.ToString());
/* var info = db.Query<dynamic>("select * from lsbzdw where rownum=1 ", transaction: transaction).ToList();
* var diclist = info.Select(x => (IDictionary<string, object>)x).ToList();
* new ExcelAPPWeb.Service.ImportService().WriteLogFile("获取" + Newtonsoft.Json.JsonConvert.SerializeObject(new { Bills = list }));
* throw new Exception("不能取消上传" + model.ID + "单位数据" + Newtonsoft.Json.JsonConvert.SerializeObject(diclist));
*/
try
{
var YWID = model.ID.Replace(model.DWBH, "");
new YzDrpInterFace().DrpIMInterFace(YWID, list, model, db, transaction);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 自定义按钮点击后
/// </summary>
/// <param name="list"></param>
/// <param name="model"></param>
/// <param name="db"></param>
/// <param name="transaction"></param>
public void CustomBtnClick(List <IDictionary <string, object> > list, EACmpCategory model, IDbConnection db, IDbTransaction transaction)
{
throw new NotImplementedException();
}
/// <summary>
/// 关联上传后
/// </summary>
/// <param name="list"></param>
/// <param name="model"></param>
/// <param name="db"></param>
/// <param name="transaction"></param>
public void AfterRefUpload(List <IDictionary <string, object> > list, EACmpCategory model, IDbConnection db, IDbTransaction transaction)
{
throw new Exception("不能关联上传" + model.ID);
}
/// <summary>
/// 删除关联后
/// </summary>
/// <param name="list"></param>
/// <param name="model"></param>
/// <param name="db"></param>
/// <param name="transaction"></param>
public void AfterRefDelete(List <IDictionary <string, object> > list, EACmpCategory model, IDbConnection db, IDbTransaction transaction)
{
throw new NotImplementedException();
}
public string DrpIMInterFace(string ywid, List <IDictionary <string, object> > list, EACmpCategory model, IDbConnection db, IDbTransaction transaction)
{
var reparm = JsonConvert.SerializeObject(new { Bills = list });
string parms = "", ret = "", classsetcode = "";
/*IMGM 库存单据
* SalesOrder 销售订单
* RPBills 收付款单
* GoodsRecReq 入库通知单
* IMGIGIR 要货申请单
* Customers 往来单位
* Materials 物料档案
* BillsOfLading 销售交货单
* SalesAgreements 销售协议
* ARSKD GS7收款单
* ARYSD GS7应收单
* SalesInvoices 销售发票
*/
var time = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
switch (ywid)
{
case "CJRK":
classsetcode = "IMGM"; //库存单据
break;
case "YZDD":
classsetcode = "SalesOrder"; //销售订单
break;
case "YZTD":
classsetcode = "BillsOfLading"; //销售交货单
break;
case "YZFP":
classsetcode = " SalesInvoices"; //销售发票
break;
case "YZSK":
classsetcode = " ARSKD"; //GS7收款单
break;
case "YZYS":
classsetcode = " ARYSD"; //GS7应收单
break;
case "YZSFK":
classsetcode = " RPBills"; //收付款单
break;
}
var UrlS = Url + "/cwbase/api/ToDataAPI.ashx";
parms = "token=9999999999999999999&time=" + time + "&classsetcode=" + classsetcode + "&format=JSON¶m=" + reparm + "&configid=&appid=" + appid + "&usercode=" + usercode + "&logindate=&comid=";
ret = GetJson(UrlS, parms, encode);
DataSet seter = null;
seter = Json2DataSet(ret);
if (((seter != null) && (seter.Tables.Count > 0)) && (seter.Tables[0].Rows.Count >= 1))
{
for (int i = 0; i < seter.Tables[0].Rows.Count; i++)
{
string strok = Convert.ToString(seter.Tables[0].Rows[i]["State"]).Trim();
if (strok == "0")
{
throw new Exception("错误！" + Convert.ToString(seter.Tables[0].Rows[i]["FailReason"]).Trim());
}
Dictionary <string, object> dict = new Dictionary <string, object>();
dict.Add("p_QueryCode", ywid);
dict.Add("p_GSDWBH", model.DWBH);
dict.Add("p_PKID", Convert.ToString(seter.Tables[0].Rows[i]["PKID"]).Trim());
dict.Add("p_BillID", Convert.ToString(seter.Tables[0].Rows[i]["BillID"]).Trim());
dict.Add("p_BillCode", Convert.ToString(seter.Tables[0].Rows[i]["BillCode"]).Trim());
Service.ProcHelper.ExecProc(dict, "Sp_Drp_YZInterFaceAF", db, transaction);
}
}
return("ok");
}
