/// <summary>
/// 设置单据导入状态
/// </summary>
void SetDocumentImportStatus(string statusName, DataSources.EnumImportStaus importStaus, List <SysSQLString> listSql, string order_id, string order_type)
{
DataTable dt = DBHelper.GetTable("", "tb_balance_documents", "documents_id,documents_name", string.Format("order_id='{0}'", order_id), "", "");
if (dt == null || dt.Rows.Count == 0)
{
return;
}
Preposition pre = new Preposition();
foreach (DataRow dr in dt.Rows)
{
pre.AddID(dr["documents_id"], dr["documents_name"]);
}
listSql.AddRange(pre.GetSql(statusName, importStaus));
}
/// <summary>
/// 设置单据导入状态
/// </summary>
void SetDocumentImportStatus(string statusName, DataSources.EnumImportStaus importStaus, List <SysSQLString> listSql, string order_id, string order_type)
{
DataTable dt = DBHelper.GetTable("", "tb_verificationn_documents", "order_id", string.Format("account_verification_id='{0}'", order_id), "", "");
if (dt == null || dt.Rows.Count == 0)
{
return;
}
string ids = string.Empty;
foreach (DataRow dr in dt.Rows)
{
ids += string.Format("'{0}',", dr["order_id"]);
}
ids = ids.TrimEnd(',');
string strImportStatus = ((int)importStaus).ToString();
DataSources.EnumAccountVerification enumAccount = (DataSources.EnumAccountVerification)Convert.ToInt32(order_type);
switch (enumAccount)
{
case DataSources.EnumAccountVerification.YuShouToYingShou: //预收冲应收
case DataSources.EnumAccountVerification.YingShouToYingShou: //应收转应收
listSql.Add(Financial.GetSaleBilling(statusName, strImportStatus, ids));
listSql.Add(Financial.GetMaintainSettlement(statusName, strImportStatus, ids));
listSql.Add(Financial.GetMaintainThree(statusName, strImportStatus, ids));
break;
//case DataSources.EnumAccountVerification.YuShouToYuShou://预收转预收
// ImportYuShou(txtcCustName2, lblCustName2);
//break;
case DataSources.EnumAccountVerification.YingShouToYingFu: //应收冲应付
case DataSources.EnumAccountVerification.YingFuToYingShou: //应付冲应收
listSql.Add(Financial.GetSaleBilling(statusName, strImportStatus, ids));
listSql.Add(Financial.GetMaintainSettlement(statusName, strImportStatus, ids));
listSql.Add(Financial.GetMaintainThree(statusName, strImportStatus, ids));
listSql.Add(Financial.GetPurchaseBilling(statusName, strImportStatus, ids));
break;
case DataSources.EnumAccountVerification.YuFuToYingFu: //预付冲应付
case DataSources.EnumAccountVerification.YingFuToYingFu: //应付转应付
listSql.Add(Financial.GetPurchaseBilling(statusName, strImportStatus, ids));
break;
//case DataSources.EnumAccountVerification.YuFuToYuFu://预付冲预付
// ImportYuFu(txtcCustName2, lblCustName2);
//break;
}
}
/// <summary>
/// 设置单据导入状态
/// </summary>
void SetDocumentImportStatus(string statusName, DataSources.EnumImportStaus importStaus, List <SysSQLString> listSql, string order_id, string order_type)
{
DataTable dt = DBHelper.GetTable("", "tb_balance_documents", "documents_id", string.Format("order_id='{0}'", order_id), "", "");
if (dt == null || dt.Rows.Count == 0)
{
return;
}
string ids = string.Empty;
foreach (DataRow dr in dt.Rows)
{
ids += string.Format("'{0}',", dr["documents_id"]);
}
ids = ids.TrimEnd(',');
string strImportStatus = ((int)importStaus).ToString();
if (orderType == DataSources.EnumOrderType.RECEIVABLE)
{
DataSources.EnumReceivableType type = (DataSources.EnumReceivableType)Convert.ToInt32(order_type);
if (type == DataSources.EnumReceivableType.RECEIVABLE)
{
listSql.Add(Financial.GetSaleBilling(statusName, strImportStatus, ids));
listSql.Add(Financial.GetMaintainSettlement(statusName, strImportStatus, ids));
listSql.Add(Financial.GetMaintainThree(statusName, strImportStatus, ids));
}
else
{
listSql.Add(Financial.GetSaleOrder(statusName, strImportStatus, ids));
}
}
else
{
DataSources.EnumPaymentType type = (DataSources.EnumPaymentType)Convert.ToInt32(order_type);
if (type == DataSources.EnumPaymentType.PAYMENT)
{
listSql.Add(Financial.GetPurchaseBilling(statusName, strImportStatus, ids));
}
else
{
listSql.Add(Financial.GetPurchaseOrder(statusName, strImportStatus, ids));
}
}
}
internal List <SysSQLString> GetSql(string statusName, DataSources.EnumImportStaus importStaus)
{
string strImportStatus = ((int)importStaus).ToString();
List <SysSQLString> listSql = new List <SysSQLString>();
if (dicIDs.Count == 0)
{
return(listSql);
}
foreach (string key in dicIDs.Keys)
{
SysSQLString sql = new SysSQLString();
sql.cmdType = CommandType.Text;
sql.Param = new Dictionary <string, string>();
switch (dicIDs[key].ToString())
{
case "销售开单":
sql.sqlString = string.Format("update tb_parts_sale_billing set {0}='{1}' where sale_billing_id='{2}';", statusName, strImportStatus, key);
break;
case "维修结算单":
sql.sqlString = string.Format("update tb_maintain_settlement_info set {0}='{1}' where settlement_id='{2}';", statusName, strImportStatus, key);
break;
case "三包结算单":
sql.sqlString = string.Format("update tb_maintain_three_guaranty_settlement set {0}='{1}' where st_id='{2}';", statusName, strImportStatus, key);
break;
case "销售订单":
sql.sqlString = string.Format("update tb_parts_sale_order set {0}='{1}' where sale_order_id='{2}';", statusName, strImportStatus, key);
break;
case "采购开单":
sql.sqlString = string.Format("update tb_parts_purchase_billing set {0}='{1}' where purchase_billing_id='{2}';", statusName, strImportStatus, key);
break;
case "采购订单":
sql.sqlString = string.Format("update tb_parts_purchase_order set {0}='{1}' where order_id='{2}';", statusName, strImportStatus, key);
break;
}
listSql.Add(sql);
}
return(listSql);
}
