/// <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 InvokeBatchAudit(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.Audit(formId, "{\"CreateOrgId\":\"0\",\"Numbers\":[" + FormatFNumber(numbers) + "],\"Ids\":\"\"}");
}
if (pkIds != null && pkIds.Count() > 0)
{
ret = client.Audit(formId, "{\"CreateOrgId\":\"0\",\"Numbers\":[],\"Ids\":\"" + FormatFNumber(pkIds) + "\"}");
}
if (!string.IsNullOrEmpty(ret))
{
response = Response(ctx, dataType, SynOperationType.AUDIT, ret);
}
}
return(response);
}
public override string transform()
{
string result = "审核操作结果：";
K3CloudApiClient client = getOperateClient();
result += client.Audit(formId, targetJson);
return(result);
}
public string Audit(string formid, string data)
{
string ret = "";
if (_isLogin)
{
ret = _client.Audit(formid, data);
}
if (_mode != 0)
{
return(JsonToXml(ret));
}
return(ret);
}
//审核
public bool audit(K3CloudApiClient client, out string msg)
{
bool flag = false;
string result = client.Audit(FormId, auditStr);
JObject jo = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(result);
if (Convert.ToString(jo["Result"]["ResponseStatus"]["IsSuccess"]) == "True")
{
msg = Convert.ToString(jo["Result"]["ResponseStatus"]["SuccessMessages"]);
flag = true;
}
else
{
msg = Convert.ToString(jo["Result"]["ResponseStatus"]["Errors"]);
}
return(flag);
}
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);
//}
}
