/// <summary>
///
/// </summary>
/// <param name="sFBillTypeID">单据类型代码</param>
/// <param name="sFSaleOrgId">销售组织代码</param>
/// <param name="sFDate">日期</param>
/// <param name="sFStockOrgId">发货组织代码</param>
/// <param name="sFStoreomerID">客户代码</param>
/// <param name="SubHeadEntitys">表头信息</param>
/// <param name="FEntitys">表体信息</param>
/// <param name="FOutStockTraces">出货信息</param>
public SAL_OUTSTOCK(string sFBillTypeID, string sFSaleOrgId, string sFDate, string sFStockOrgId, string sFStoreomerID, SAL_OUTSTOCK__SubHeadEntity SubHeadEntitys, SAL_OUTSTOCK__FEntity[] FEntitys, SAL_OUTSTOCK__FOutStockTrace[] FOutStockTraces)
{
FDate = sFDate;
FBillTypeID = new SAL_OUTSTOCK_BOS_BillType();
FBillTypeID.FNumber = sFBillTypeID;
FSaleOrgId = new SAL_OUTSTOCK_ORG_Organizations();
FSaleOrgId.FNumber = sFSaleOrgId;
FSaleDeptID = new SAL_OUTSTOCK_BD_Department();
FCustomerID = new SAL_OUTSTOCK_BD_Customer();
FCustomerID.FNumber = sFStoreomerID;
FHeadLocationId = new SAL_OUTSTOCK_BD_CUSTCONTACTION();
FCarrierID = new SAL_OUTSTOCK_BD_Supplier();
FCorrespondOrgId = new SAL_OUTSTOCK_ORG_Organizations();
FSalesGroupID = new SAL_OUTSTOCK_BD_OperatorGroup();
FSalesManID = new SAL_OUTSTOCK_BD_Saler();
FStockOrgId = new SAL_OUTSTOCK_ORG_Organizations();
FStockOrgId.FNumber = sFStockOrgId;
FDeliveryDeptID = new SAL_OUTSTOCK_BD_Department();
FStockerGroupID = new SAL_OUTSTOCK_BD_OperatorGroup();
FStockerID = new SAL_OUTSTOCK_BD_WAREHOUSEWORKERS();
FReceiverID = new SAL_OUTSTOCK_BD_Customer();
FSettleID = new SAL_OUTSTOCK_BD_Customer();
FReceiverContactID = new SAL_OUTSTOCK_BD_StoreContact();
FPayerID = new SAL_OUTSTOCK_BD_Customer();
FOwnerIdHead = new SAL_OUTSTOCK_BOS_ItemClass();
SubHeadEntity = SubHeadEntitys;
FEntity = FEntitys;
FOutStockTrace = FOutStockTraces;
}
public void BatchSave()
{
string strSerializeJSON = "";
try
{
if (loginResult == true)
{
List <SAL_OUTSTOCK> LSO = new List <SAL_OUTSTOCK>();
StringBuilder builder = new StringBuilder();
using (SqlDataReader sdr = SqlHelper.ExecuteReader(strcon, CommandType.Text, "exec dbo.p_edb_BatchSave"))
{
while (sdr.Read())
{
string sFSettleCurrID = "PRE001";
string sFSettleOrgID = "01";
SAL_OUTSTOCK__SubHeadEntity SubHeadEntitys = new SAL_OUTSTOCK__SubHeadEntity(sFSettleCurrID, sFSettleOrgID);
SAL_OUTSTOCK__FEntity[] FEntitys = GetEntitys(sdr["FBillNo"].ToString());
List <SAL_OUTSTOCK__FOutStockTrace> lsofst = new List <SAL_OUTSTOCK__FOutStockTrace>();
SAL_OUTSTOCK__FOutStockTrace[] FOutStockTraces = lsofst.ToArray();
string sFBillTypeID = "XSCKD01_SYS";
string sFSaleOrgId = (sdr["FOrgNumber"] == null || sdr["FOrgNumber"].ToString().Trim() == "" ? "01" : sdr["FOrgNumber"].ToString());
string sFDate = sdr["FDate"].ToString();
string sFStockOrgId = "01";
string sFCustomerID = (sdr["FCustID"] == null || sdr["FCustID"].ToString() == "" || decimal.Parse(sdr["FCustID"].ToString()) == 0 ? "02.001" : sdr["FCustID"].ToString());
SAL_OUTSTOCK so = new SAL_OUTSTOCK(sFBillTypeID, sFSaleOrgId, sFDate, sFStockOrgId, sFCustomerID, SubHeadEntitys, FEntitys, FOutStockTraces);
so.FNote = "备注";
builder.Append(sdr["FBillNo"].ToString() + ",");
so.F_PAEZ_Text = sdr["FBillNo"].ToString();
so.F_PAEZ_Text2 = sdr["FCustID"].ToString();
LSO.Add(so);
}
}
if (LSO.Count > 0)
{
SAL_OUTSTOCK_BatchOBJECT m = new SAL_OUTSTOCK_BatchOBJECT(LSO.ToArray());
m.BatchCount = LSO.Count;
strSerializeJSON = JsonConvert.SerializeObject(m);
string result = client.Execute <string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.BatchSave", new object[] { "SAL_OUTSTOCK", 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());
string tids = builder.ToString();
tids = tids.Substring(0, tids.Length - 1);
SqlHelper.ExecuteNonQuery(strcon, CommandType.Text, "exec dbo.p_edb_UpdateFlag '" + tids + "'");
if (IsSuccess != true)
{
LogHelper.WriteFileLog(typeof(SAL_OUTSTOCK_DAL), tids);
LogHelper.WriteFileLog(typeof(SAL_OUTSTOCK_DAL), jsonObj["ResponseStatus"]["Errors"].ToString());
}
}
else
{
//LogHelper.WriteFileLog(typeof(SAL_OUTSTOCK_DAL), "没有符合要求数据！");
}
}
else
{
LogHelper.WriteFileLog(typeof(SAL_OUTSTOCK_DAL), "登陆到K3Cloud失败!");
}
}
catch (Exception ex)
{
LogHelper.WriteFileLog(typeof(SAL_OUTSTOCK_DAL), ex.ToString());
}
}
public void SAVE(string FBillNo)
{
try
{
if (loginResult == true)
{
SqlParameter[] Param = new SqlParameter[] { new SqlParameter("@FBillNo", FBillNo) };
using (SqlDataReader sdr = SqlHelper.ExecuteReader(strcon, CommandType.Text, "exec dbo.p_edb_GetHead @FBillNo", Param))
{
while (sdr.Read())
{
string sFSettleCurrID = "PRE001";
string sFSettleOrgID = "01";
SAL_OUTSTOCK__SubHeadEntity SubHeadEntitys = new SAL_OUTSTOCK__SubHeadEntity(sFSettleCurrID, sFSettleOrgID);
SAL_OUTSTOCK__FEntity[] FEntitys = GetEntitys(sdr["FBillNo"].ToString());
List <SAL_OUTSTOCK__FOutStockTrace> lsofst = new List <SAL_OUTSTOCK__FOutStockTrace>();
SAL_OUTSTOCK__FOutStockTrace[] FOutStockTraces = lsofst.ToArray();
string sFBillTypeID = "XSCKD01_SYS";
string sFSaleOrgId = (sdr["FOrgNumber"] == null || sdr["FOrgNumber"].ToString().Trim() == "" ? "01" : sdr["FOrgNumber"].ToString());
string sFDate = sdr["FDate"].ToString();
string sFStockOrgId = "01";
string sFCustomerID = (sdr["FCustID"] == null || sdr["FCustID"].ToString() == "" || decimal.Parse(sdr["FCustID"].ToString()) == 0 ? "02.001" : sdr["FCustID"].ToString());
SAL_OUTSTOCK so = new SAL_OUTSTOCK(sFBillTypeID, sFSaleOrgId, sFDate, sFStockOrgId, sFCustomerID, SubHeadEntitys, FEntitys, FOutStockTraces);
so.FNote = "备注";
so.F_PAEZ_Text = sdr["FBillNo"].ToString();
so.F_PAEZ_Text2 = sdr["FCustID"].ToString();
SAL_OUTSTOCK_OBJECT m = new SAL_OUTSTOCK_OBJECT(so);
m.Creator = sUser;
string strSerializeJSON = JsonConvert.SerializeObject(m);
string result = client.Execute <string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Save", new object[] { "SAL_OUTSTOCK", 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)
{
//LogHelper.WriteLog(strcon, "SAL_OUTSTOCK", "ResultJsonData", sUser, result);
SqlHelper.ExecuteNonQuery(strcon, CommandType.Text, "update tb_Trade set is_flag=1 where tid='" + sdr["FBillNo"].ToString() + "'");
}
else
{
JArray arr = (JArray)jsonObj["ResponseStatus"]["Errors"];
LogHelper.WriteLog(strcon, "SAL_OUTSTOCK", "ErrorInfo", sUser, arr.ToString());
}
}
}
}
else
{
LogHelper.WriteLog(strcon, "SAL_OUTSTOCK", "ErrorInfo", sUser, "登陆到K3Cloud失败!");
}
}
catch (Exception ex)
{
LogHelper.WriteLog(strcon, "SAL_OUTSTOCK", "ErrorInfo", sUser, ex.ToString());
}
}
