/// <summary> /// 单据批量删除 /// </summary> /// <param name="ctx"></param> /// <param name="dataType"></param> /// <param name="formId"></param> /// <param name="numbers"></param> /// <param name="pkIds"></param> /// <returns></returns> public static HttpResponseResult InvokeBatchDelete(Context ctx, SynchroDataType dataType, string formId, IEnumerable <string> numbers = null, IEnumerable <int> pkIds = null) { HttpResponseResult response = default(HttpResponseResult); string ret = default(string); K3CloudApiClient client = null; DataBaseConst.K3CloudContext = ctx; client = new K3CloudApiClient(DataBaseConst.CurrentK3CloudURL); // 登陆成功 if (Login(ctx, client)) { if (numbers != null && numbers.Count() > 0) { ret = client.Delete(formId, "{\"CreateOrgId\":\"0\",\"Numbers\":[" + FormatFNumber(numbers) + "],\"Ids\":\"\"}"); } if (pkIds != null && pkIds.Count() > 0) { ret = client.Delete(formId, "{\"CreateOrgId\":\"0\",\"Numbers\":[],\"Ids\":\"" + FormatFNumber(pkIds) + "\"}"); } if (!string.IsNullOrEmpty(ret)) { response = Response(ctx, dataType, SynOperationType.DELETE, ret); } } return(response); }
public override string transform() { string result = "删除操作结果:"; K3CloudApiClient client = getOperateClient(); result += client.Delete(formId, targetJson); return(result); }
public string Delete(string formid, string data) { string ret = ""; if (_isLogin) { ret = _client.Delete(formid, data); } if (_mode != 0) { return(JsonToXml(ret)); } return(ret); }
private void Save(string billno, string saleorgid, string salerid, string settlecurrnumber, string auserid, string custnumber, decimal alldiscount) { bool PD = true; string Errors = String.Empty; if (LogIn() == 1) { //var a = "{\"IsDeleteEntry\":\"true\",\"IsVerifyBaseDataField\":\"false\",\"IsEntryBatchFill\":\"true\",\"ValidateFlag\":\"true\",\"NumberSearch\":\"true\",\"Model\":{\"FID\":0,\"FBillNo\":\"" + billno + "\",\"FBillDate\":\"" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "\",\"FFinanceOrgId\":{\"FNumber\":\"" + saleorgid + "\"},\"FSettleCurrId\":{\"FNUMBER\":\"" + settlecurrnumber + "\"},\"FDeptId\":{\"FNUMBER\":\"\"},\"FAppUserId\":{\"FNUMBER\":\"\"},\"FCreatorId\":{\"FUserID\":\"" + auserid + "\"},\"FCreateDate\":\"" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "\",\"FModifierId\":{\"FUserID\":\"" + auserid + "\"},\"FModifyDate\":\"" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "\",\"FApproverId\":{\"FUserID\":\"" + auserid + "\"},\"FApproveDate\":\"" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "\",\"FBaseSettleCurrID\":{\"FNUMBER\":\"0\"},\"FRateTypeID\":{\"FNUMBER\":\"0\"},\"FExchangeRate\":0,\"FBillSource\":0,\"FAccountID\":{\"FNUMBER\":\"\"},\"FIsSettlement\":\"false\",\"FIsExceptRpt\":\"false\",\"FCloserId\":{\"FUserID\":\"0\"},\"FCloseDate\":\"\",\"FEntity\":[{\"FEntryID\":0,\"FRPObjectTypeID\":\"BD_Customer\",\"FRPObjectID\":{\"FNumber\":\"" + custnumber + "\"},\"FOrderCustomerId\":{\"FNUMBER\":\"" + custnumber + "\"},\"FIsGroupRebate\":\"false\",\"FRPLocalAmount\":" + alldiscount + ",\"FRPAmount\":" + alldiscount + ",\"FGroupNumber\":0,\"FRPCycleID\":{\"FNUMBER\":\"\"},\"FAssistPropertyID\":{\"FASSISTPROPERTYID__FF100001\":{\"FNumber\":\"\"}},\"FRPBaseQty\":0}]}}"; alldiscount = -alldiscount; var ViewResult = client.View("RPM_RPStatements", "{\"CreateOrgId\":0,\"Number\":\"" + billno + "\",\"Id\":\"\"}"); JObject ViResult = JObject.Parse(ViewResult); JObject viresult = ViResult["Result"]["ResponseStatus"] as JObject; if (viresult["IsSuccess"].ToString() == "True") { throw new KDBusinessException("", "返利结算单据编码已存在,保存失败,终止操作执行!"); } else { var SaveResult = client.Save("RPM_RPStatements", "{\"IsDeleteEntry\":\"true\",\"IsVerifyBaseDataField\":\"false\",\"IsEntryBatchFill\":\"true\",\"ValidateFlag\":\"true\",\"NumberSearch\":\"true\",\"Model\":{\"FID\":0,\"FBillNo\":\"" + billno + "\",\"FBillDate\":\"" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "\",\"FFinanceOrgId\":{\"FNumber\":\"" + saleorgid + "\"},\"FSettleCurrId\":{\"FNUMBER\":\"" + settlecurrnumber + "\"},\"FDeptId\":{\"FNUMBER\":\"\"},\"FAppUserId\":{\"FNUMBER\":\"\"},\"FCreatorId\":{\"FUserID\":\"" + auserid + "\"},\"FCreateDate\":\"" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "\",\"FModifierId\":{\"FUserID\":\"" + auserid + "\"},\"FModifyDate\":\"" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "\",\"FApproverId\":{\"FUserID\":\"" + auserid + "\"},\"FApproveDate\":\"" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "\",\"FBaseSettleCurrID\":{\"FNUMBER\":\"0\"},\"FRateTypeID\":{\"FNUMBER\":\"0\"},\"FExchangeRate\":0,\"FBillSource\":0,\"FAccountID\":{\"FNUMBER\":\"\"},\"FIsSettlement\":\"false\",\"FIsExceptRpt\":\"false\",\"FCloserId\":{\"FUserID\":\"0\"},\"FCloseDate\":\"\",\"FEntity\":[{\"FEntryID\":0,\"FRPObjectTypeID\":\"BD_Customer\",\"FRPObjectID\":{\"FNumber\":\"" + custnumber + "\"},\"FOrderCustomerId\":{\"FNUMBER\":\"" + custnumber + "\"},\"FIsGroupRebate\":\"false\",\"FRPLocalAmount\":" + alldiscount + ",\"FRPAmount\":" + alldiscount + ",\"FGroupNumber\":0,\"FRPCycleID\":{\"FNUMBER\":\"\"},\"FAssistPropertyID\":{\"FASSISTPROPERTYID__FF100001\":{\"FNumber\":\"\"}},\"FRPBaseQty\":0}]}}"); JObject SResult = JObject.Parse(SaveResult); JObject sresult = SResult["Result"]["ResponseStatus"] as JObject; if (sresult["IsSuccess"].ToString() == "True") { var SubmitResult = client.Submit("RPM_RPStatements", "{\"CreateOrgId\":0,\"Numbers\":[\"" + billno + "\"],\"Ids\":\"\",\"SelectedPostId\":0,\"NetworkCtrl\":\"\"}"); JObject SuResult = JObject.Parse(SubmitResult); JObject suresult = SuResult["Result"]["ResponseStatus"] as JObject; if (suresult["IsSuccess"].ToString() == "True") { var AuditResult = client.Audit("RPM_RPStatements", "{\"CreateOrgId\":0,\"Numbers\":[\"" + billno + "\"],\"Ids\":\"\",\"SelectedPostId\":0,\"NetworkCtrl\":\"\"}"); JObject AuResult = JObject.Parse(AuditResult); JObject auresult = AuResult["Result"]["ResponseStatus"] as JObject; if (auresult["IsSuccess"].ToString() == "True") { } else { PD = false; Errors = suresult["Errors"].ToString(); } } else { PD = false; Errors = suresult["Errors"].ToString(); } } else { Errors = sresult["Errors"].ToString(); throw new KDBusinessException("", "保存失败,终止操作执行!" + Errors + ""); } if (!PD) { var DeleteResult = client.Delete("RPM_RPStatements", "{\"CreateOrgId\":0,\"Numbers\":[\"" + billno + "\"],\"Ids\":\"\",\"NetworkCtrl\":\"\"}"); JObject DeResult = JObject.Parse(DeleteResult); JObject deresult = DeResult["Result"]["ResponseStatus"] as JObject; if (deresult["IsSuccess"].ToString() == "True") { } throw new KDBusinessException("", "保存失败,终止操作执行!" + Errors + ""); } } } }
public override void EndOperationTransaction(EndOperationTransactionArgs e) { string billno = string.Empty; List <string> sqlArray = new List <string>(); foreach (DynamicObject entity in e.DataEntitys) { if (entity != null) { //单据头 billno = Convert.ToString(entity["BillNo"]); if (billno != "") { if (LogIn() == 1) { var ViewResult = client.View("RPM_RPStatements", "{\"CreateOrgId\":0,\"Number\":\"" + billno + "\",\"Id\":\"\"}"); JObject ViResult = JObject.Parse(ViewResult); JObject viresult = ViResult["Result"]["ResponseStatus"] as JObject; if (viresult["IsSuccess"].ToString() == "True") { var UnAuditResult = client.UnAudit("RPM_RPStatements", "{\"CreateOrgId\":0,\"Numbers\":[\"" + billno + "\"],\"Ids\":\"\",\"NetworkCtrl\":\"\"}"); JObject UnResult = JObject.Parse(UnAuditResult); JObject unresult = UnResult["Result"]["ResponseStatus"] as JObject; if (unresult["IsSuccess"].ToString() == "True") { var DeleteResult = client.Delete("RPM_RPStatements", "{\"CreateOrgId\":0,\"Numbers\":[\"" + billno + "\"],\"Ids\":\"\",\"NetworkCtrl\":\"\"}"); JObject DeResult = JObject.Parse(DeleteResult); JObject deresult = DeResult["Result"]["ResponseStatus"] as JObject; if (deresult["IsSuccess"].ToString() == "True") { } else { var SubmitResult = client.Submit("RPM_RPStatements", "{\"CreateOrgId\":0,\"Numbers\":[\"" + billno + "\"],\"Ids\":\"\",\"SelectedPostId\":0,\"NetworkCtrl\":\"\"}"); var AuditResult = client.Audit("RPM_RPStatements", "{\"CreateOrgId\":0,\"Numbers\":[\"" + billno + "\"],\"Ids\":\"\",\"SelectedPostId\":0,\"NetworkCtrl\":\"\"}"); throw new KDBusinessException("", "反审核失败,终止操作执行!" + deresult["Errors"].ToString() + ""); } } else { throw new KDBusinessException("", "反审核失败,终止操作执行!" + unresult["Errors"].ToString() + ""); } } } //获取FID //string ssql = string.Format(@"/*dialect*/ select FID from T_RPM_RPSTATEMENT where FBILLNO='" + billno + "'"); //DataSet dsX = Kingdee.BOS.ServiceHelper.DBServiceHelper.ExecuteDataSet(this.Context, ssql); //if (dsX == null || dsX.Tables[0].Rows.Count == 0) // return; //int fid = int.Parse(dsX.Tables[0].Rows[0]["FID"].ToString()); //string sql = string.Format(@"/*dialect*/ DELETE FROM T_RPM_RPSTATEMENT WHERE FID = {0}", fid); //sqlArray.Add(sql); //string sqll = string.Format(@" DELETE FROM T_RPM_RPSTATEMENTENTRY where FID={0}" // , fid); //sqlArray.Add(sqll); } } } //if (sqlArray.Count > 0) //{ // DBUtils.ExecuteBatch(this.Context, sqlArray, 100); //} }