public void SAVE(string FBillNo)
{
try
{
if (loginResult == true)
{
string strSQL = "select distinct top 100 t.FBillNo,t.FDate,t.FAlipay_ID,t1.FCustID,t1.FOrgID,t1.FStockNumber from tb_StockBillin t " +
"inner join (select b.FNUMBER FOrgID,d.FNUMBER FCustID,shop_id,case " +
"when e.FNAME like '%聚美%' then '7' " +
"when e.FNAME like '%JVC%' then '23' " +
"when e.FNAME like '%京东%' then '25' " +
"when e.FNAME like '%唯品会%' then 'CK031' " +
"else '1' " +
"end as FStockNumber from tb_shopSet01 a " +
"inner join T_ORG_ORGANIZATIONS b on a.SaleOrg_id = b.FORGID " +
"inner join T_ORG_ORGANIZATIONS_L c on a.SaleOrg_id = c.FORGID " +
"inner join T_BD_CUSTOMER d on a.Cust_id = d.FCUSTID " +
"inner join T_BD_CUSTOMER_L e on a.Cust_id = e.FCUSTID ) t1 on t1.shop_id = t.FCustName " +
"Where t.FQty> 0 and t.FFlag = 0 AND t.FBillNo ='" + FBillNo + "'";
using (SqlDataReader sdr = SqlHelper.ExecuteReader(strcon, CommandType.Text, strSQL))
{
while (sdr.Read())
{
string sFSettleCurrID = "PRE001";
string sFSettleOrgID = "01";
SAL_RETURNSTOCK__SubHeadEntity SubHeadEntitys = new SAL_RETURNSTOCK__SubHeadEntity(sFSettleCurrID, sFSettleOrgID);
SAL_RETURNSTOCK__FEntity[] FEntitys = GetEntitys(sdr["FBillNo"].ToString(), sdr["FDate"].ToString(), sdr["FStockNumber"].ToString());
string sFBillTypeID = "XSTHD01_SYS";
string sFSaleOrgId = (sdr["FOrgID"] == null || sdr["FOrgID"].ToString().Trim() == "" ? "01" : sdr["FOrgID"].ToString());
string sFDate = sdr["FDate"].ToString();
string sFStockOrgId = "01";
string sFCustomerID = sdr["FCustID"].ToString();
SAL_RETURNSTOCK sr = new SAL_RETURNSTOCK(sFBillTypeID, sFSaleOrgId, sFDate, sFCustomerID, sFStockOrgId, SubHeadEntitys, FEntitys);
sr.F_PAEZ_Text = sdr["FBillNo"].ToString();
sr.F_PAEZ_Text2 = sdr["FAlipay_ID"].ToString();;
sr.F_PAEZ_REMARKS = "导入订单";
SAL_RETURNSTOCK_OBJECT m = new SAL_RETURNSTOCK_OBJECT(sr);
m.Creator = sUser;
string strSerializeJSON = JsonConvert.SerializeObject(m);
LogHelper.WriteLog(strcon, "SAL_RETURNSTOCK_DAL", "ErrorInfo", sUser, strSerializeJSON);
string result = client.Execute <string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Save", new object[] { "SAL_RETURNSTOCK", strSerializeJSON });
JObject jo = new JObject();
jo = (Newtonsoft.Json.Linq.JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(result);
string sResult = jo["Result"].ToString();
JObject jsonObj = JObject.Parse(sResult);
Boolean IsSuccess = Convert.ToBoolean(jsonObj["ResponseStatus"]["IsSuccess"].ToString());
if (IsSuccess == true)
{
SqlHelper.ExecuteNonQuery(strcon, CommandType.Text, "update tb_Stockbill set FFlag=1 where FBillNo='" + sdr["FBillNo"].ToString() + "'");
LogHelper.WriteLog(strcon, "SAL_RETURNSTOCK_DAL", "ErrorInfo", sUser, "生成销售出库单成功:" + jsonObj["Number"].ToString());
}
else
{
LogHelper.WriteLog(strcon, "SAL_RETURNSTOCK_DAL", "ErrorInfo", sUser, "生成失败,错误代码:" + result);
}
}
}
LogHelper.WriteLog(strcon, "SAL_RETURNSTOCK_DAL", "ErrorInfo", sUser, "生成销售退货单成功！");
}
}
catch (Exception ex)
{
LogHelper.WriteLog(strcon, "SAL_RETURNSTOCK_DAL", "ErrorInfo", sUser, ex.ToString());
}
}
public void BatchSave()
{
string strSerializeJSON = "";
try
{
if (loginResult == true)
{
List <SAL_RETURNSTOCK> LSR = new List <SAL_RETURNSTOCK>();
string strSQL = "select distinct top 100 t.FBillNo,t.FDate,t.FAlipay_ID,t1.FCustID,t1.FOrgID,t1.FStockNumber from tb_StockBillin t " +
"inner join (select b.FNUMBER FOrgID, d.FNUMBER FCustID, shop_id,case " +
"when e.FNAME like '%聚美%' then '7' " +
"when e.FNAME like '%JVC%' then '23' " +
"when e.FNAME like '%京东%' then '25' " +
"when e.FNAME like '%唯品会%' then 'CK031' " +
"else '1' " +
"end as FStockNumber from tb_shopSet01 a " +
"inner join T_ORG_ORGANIZATIONS b on a.SaleOrg_id = b.FORGID " +
"inner join T_ORG_ORGANIZATIONS_L c on a.SaleOrg_id = c.FORGID " +
"inner join T_BD_CUSTOMER d on a.Cust_id = d.FCUSTID " +
"inner join T_BD_CUSTOMER_L e on a.Cust_id = e.FCUSTID ) t1 on t1.shop_id = t.FCustName " +
"where t.FQty > 0 and t.FFlag = 0 order by t.FDate";
using (SqlDataReader sdr = SqlHelper.ExecuteReader(strcon, CommandType.Text, strSQL))
{
while (sdr.Read())
{
string sFSettleCurrID = "PRE001";
string sFSettleOrgID = "01";
SAL_RETURNSTOCK__SubHeadEntity SubHeadEntitys = new SAL_RETURNSTOCK__SubHeadEntity(sFSettleCurrID, sFSettleOrgID);
SAL_RETURNSTOCK__FEntity[] FEntitys = GetEntitys(sdr["FBillNo"].ToString(), sdr["FDate"].ToString(), sdr["FStockNumber"].ToString());
string sFBillTypeID = "XSTHD01_SYS";
string sFSaleOrgId = (sdr["FOrgID"] == null || sdr["FOrgID"].ToString().Trim() == "" ? "01" : sdr["FOrgID"].ToString());
string sFDate = sdr["FDate"].ToString();
string sFStockOrgId = "01";
string sFCustomerID = sdr["FCustID"].ToString();
SAL_RETURNSTOCK sr = new SAL_RETURNSTOCK(sFBillTypeID, sFSaleOrgId, sFDate, sFCustomerID, sFStockOrgId, SubHeadEntitys, FEntitys);
sr.F_PAEZ_Text = sdr["FBillNo"].ToString();
sr.F_PAEZ_Text2 = sdr["FAlipay_ID"].ToString();;
sr.F_PAEZ_REMARKS = "导入订单";
LSR.Add(sr);
}
}
if (LSR.Count > 0)
{
SAL_RETURNSTOCK_BatchOBJECT m = new SAL_RETURNSTOCK_BatchOBJECT(LSR.ToArray());
m.BatchCount = LSR.Count;
strSerializeJSON = JsonConvert.SerializeObject(m);
LogHelper.WriteLog(strcon, "SAL_RETURNSTOCK_DAL", "PostJsonData", sUser, strSerializeJSON);
string result = client.Execute <string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.BatchSave", new object[] { "SAL_RETURNSTOCK", strSerializeJSON });
JObject jo = new JObject();
jo = (JObject)JsonConvert.DeserializeObject(result);
string sResult = jo["Result"].ToString();
JObject jsonObj = JObject.Parse(sResult);
Boolean IsSuccess = Convert.ToBoolean(jsonObj["ResponseStatus"]["IsSuccess"].ToString());
SqlHelper.ExecuteNonQuery(strcon, CommandType.Text, "update t1 set t1.FFlag=1 from dbo.T_SAL_RETURNSTOCK t inner join tb_StockBillin t1 on t.F_PAEZ_Text = t1.FBillNo where t1.FFlag = 0");
if (IsSuccess == true)
{
LogHelper.WriteLog(strcon, "SAL_RETURNSTOCK_DAL", "ResultJsonData", sUser, result);
}
else
{
LogHelper.WriteLog(strcon, "SAL_RETURNSTOCK_DAL", "ErrorInfo", sUser, result);
LogHelper.WriteFileLog(typeof(SAL_RETURNSTOCK_DAL), result);
}
}
else
{
LogHelper.WriteLog(strcon, "SAL_RETURNSTOCK_DAL", "ErrorInfo", sUser, "没有符合要求数据！");
}
}
else
{
LogHelper.WriteLog(strcon, "SAL_RETURNSTOCK_DAL", "ErrorInfo", sUser, "登陆到K3Cloud失败!");
}
}
catch (Exception ex)
{
LogHelper.WriteFileLog(typeof(SAL_RETURNSTOCK_DAL), ex.ToString());
}
}
/// <summary>
/// 退货订单对象
/// </summary>
/// <param name="sSal_RETURNSTOCK">退货订单</param>
public SAL_RETURNSTOCK_OBJECT(SAL_RETURNSTOCK sSal_RETURNSTOCK)
{
Model = sSal_RETURNSTOCK;
}