/// <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()); } }