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()); } }
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 SAL_OUTSTOCK_OBJECT(SAL_OUTSTOCK sSAL_OUTSTOCK) { Model = sSAL_OUTSTOCK; }