/// <summary>
/// 销售
/// </summary>
/// <param name="order"></param>
/// <returns></returns>
private bool InsertLSXHD(QT_GoodsInfo order)
{
bool result = false;
string KHDM = order.store_id.ToString();
string sql2 = "select top 1 KHDM,QDDM,CKDM,ZK,JGSD from kehu where khdm='" + KHDM + "'";
DataTable dataTable = BusinessDbUtil.GetDataTable(sql2);
string CKDM = dataTable.Rows[0]["CKDM"].ToString();
string text = dataTable.Rows[0]["JGSD"].ToString();
string QDDM = dataTable.Rows[0]["QDDM"].ToString();
string SL = order.amount.ToString();
var DJBH = InvoicesManage.GetNewDJBH("LSXHD", QDDM, CKDM, "");
string arg = "SELECT djbh,ydjh,qddm,dm1,dm2,dm2_1,rq,sl,je,bz,zdr,rq_4,shr,sh,shrq,ygdm,byzd1,ll,byzd12,je_1,isonline FROM LSXHD";
DataTable table = BusinessDbUtil.GetDataTable(string.Format("{0} WHERE djbh='{1}'", arg, order.store_id));
table.TableName = "LSXHD";
table.PrimaryKey = new DataColumn[]
{
table.Columns["djbh"]
};
//取商品信息 包括价格
string sql = string.Format(@"IF EXISTS (select 1 from TMDZB inner join sg_gatherings on TMDZB.SPDM = sg_gatherings.vstyle
and TMDZB.gg1dm=sg_gatherings.vcolor and TMDZB.gg2dm =sg_gatherings.vsize
where TMDZB.SPDM ='{0}' and TMDZB.SPTM='{1}' and sg_gatherings.vmbillid='{2}' )
BEGIN
select TMDZB.SPDM,TMDZB.GG1DM,TMDZB.GG2DM,sg_gatherings.frealprice as BZSJ from TMDZB inner join sg_gatherings on TMDZB.SPDM = sg_gatherings.vstyle
and TMDZB.gg1dm=sg_gatherings.vcolor and TMDZB.gg2dm =sg_gatherings.vsize
where TMDZB.SPDM ='{0}' and TMDZB.SPTM='{1}' and sg_gatherings.vmbillid='{2}'
END
ELSE
BEGIN
select distinct TMDZB.SPDM,TMDZB.GG1DM,TMDZB.GG2DM,SHANGPIN.BZSJ from
TMDZB inner join SHANGPIN on TMDZB.SPDM=SHANGPIN.SPDM
where TMDZB.SPDM='{0}' and TMDZB.SPTM='{1}'
END" , order.item_id, order.sku_id, order.order_id);
DataTable dt_SP = InvoicesManage.ExecuteQuery(sql);
LogUtil.WriteInfo(this, "查询商品价格信息", "查询价格sql" + sql + "数据结果:" + JsonParser.ToJson(dt_SP));
BusinessDbUtil.DoAction(delegate(DirectDbManger dbManager)
{
try
{
if (table.Rows.Count < 1)
{
if (ValidDJUtil.IsExistKHDM(this, order.order_id, order.store_id))
{
string columns = SqlUtil.GetColumns(table);
DataRow dataRow = table.NewRow();
dataRow["djbh"] = DJBH;
dataRow["ydjh"] = order.order_id;
dataRow["qddm"] = QDDM;
dataRow["dm1"] = order.store_id;
dataRow["dm2"] = CKDM;
dataRow["dm2_1"] = "000";
dataRow["rq"] = DateTime.Now.ToShortDateString();
dataRow["bz"] = "蜻蜓平台同步";
dataRow["sl"] = SL;
//商品价格信息需要取自单据创建的时候小票的价格信息
dataRow["je"] = Convert.ToDecimal(dt_SP.Rows[0]["BZSJ"]) * Convert.ToDecimal(order.amount);
dataRow["zdr"] = "QT";
dataRow["rq_4"] = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
dataRow["ygdm"] = "000";
dataRow["byzd1"] = ValidDJUtil.GetJGXD(this, KHDM, "JGSD");
dataRow["ll"] = "1";
dataRow["byzd12"] = "1";
dataRow["isonline"] = "1";
dataRow["je_1"] = Convert.ToDecimal(dt_SP.Rows[0]["BZSJ"]) * Convert.ToDecimal(order.amount);
table.Rows.Add(dataRow);
string text2 = SqlUtil.ConvertInsert(table, columns, dataRow);
DataTable dataTable2 = BusinessDbUtil.GetDataTable(string.Format("SELECT djbh,mibh,spdm,gg1dm,gg2dm,ckj,dj,sl,zk,bzje,je FROM LSXHDMX WHERE 1=0", new object[0]));
dataTable2.TableName = "LSXHDMX";
dataTable2.PrimaryKey = new DataColumn[]
{
dataTable2.Columns["djbh"],
dataTable2.Columns["mibh"]
};
bool flag = true;
string columns2 = SqlUtil.GetColumns(dataTable2);
DataRow dataRow3 = dataTable2.NewRow();
dataRow3["djbh"] = DJBH;
dataRow3["mibh"] = 0;
dataRow3["spdm"] = order.item_id;
dataRow3["gg1dm"] = dt_SP.Rows[0]["GG1DM"];
dataRow3["gg2dm"] = dt_SP.Rows[0]["GG2DM"];
dataRow3["dj"] = Convert.ToDecimal(dt_SP.Rows[0]["BZSJ"]);
dataRow3["ckj"] = Convert.ToDecimal(dt_SP.Rows[0]["BZSJ"]);
dataRow3["sl"] = order.amount;
dataRow3["zk"] = "1";
dataRow3["je"] = Convert.ToDecimal(dt_SP.Rows[0]["BZSJ"]) * Convert.ToDecimal(order.amount);
dataRow3["bzje"] = Convert.ToDecimal(dt_SP.Rows[0]["BZSJ"]) * Convert.ToDecimal(order.amount);
dataTable2.Rows.Add(dataRow3);
if (flag)
{
DataTable dataTable3 = BusinessDbUtil.GetDataTable(string.Format("SELECT DJBH,mibh,JSFS,JE FROM LSXHDJS WHERE 1=0", new object[0]));
dataTable3.TableName = "LSXHDJS";
dataTable3.PrimaryKey = new DataColumn[]
{
dataTable3.Columns["DJBH"],
dataTable3.Columns["mibh"]
};
DataRow dataRow4 = dataTable3.NewRow();
dataRow4["DJBH"] = DJBH;
dataRow4["mibh"] = 1;
dataRow4["JSFS"] = "999";
dataRow4["JE"] = Convert.ToDecimal(dt_SP.Rows[0]["BZSJ"]) * Convert.ToDecimal(order.amount);
dataTable3.Rows.Add(dataRow4);
IEnumerable <string> enumerable = SqlUtil.Convert(dataTable2);
IEnumerable <string> enumerable2 = SqlUtil.Convert(dataTable3);
bool flag2 = false;
try
{
sql = dbManager.ExecuteBatchQuery(out flag2, text2, enumerable, enumerable2);
InvoicesManage.UpdateBillPrice(DJBH, "LSXHD");
DataTable procedureParameter = dbManager.GetProcedureParameter("P_LSXHDFLAGPROCESS");
dbManager.SetProcedureParameter(procedureParameter, "DJBH", DJBH);
dbManager.SetProcedureParameter(procedureParameter, "USER", "QT");
dbManager.SetProcedureParameter(procedureParameter, "Flag", "1");
dbManager.SetProcedureParameter(procedureParameter, "OpDate", DateTime.Now.ToShortDateString());
DataTable dataTable4 = dbManager.ExecProcedure("P_LSXHDFLAGPROCESS", procedureParameter);
DataTable procedureParameter2 = dbManager.GetProcedureParameter("P_UPDATEPTKC_1");
dbManager.SetProcedureParameter(procedureParameter2, "ckdm", CKDM);
dbManager.SetProcedureParameter(procedureParameter2, "kwdm", "000");
dbManager.SetProcedureParameter(procedureParameter2, "tblName", "LSXHDMP");
dbManager.SetProcedureParameter(procedureParameter2, "djbh", DJBH);
dbManager.SetProcedureParameter(procedureParameter2, "intSlLx", -1);
DataTable dataTable5 = dbManager.ExecProcedure("P_UPDATEPTKC_1", procedureParameter2);
//更新小票日结状态
var lsxhCounts = "select sum(lsxhdmx.sl) as sl from lsxhdmx left join lsxhd on lsxhd.djbh = lsxhdmx.djbh where lsxhd.ydjh='" + order.order_id + "'";
DataTable lsxhCounts_Table = BusinessDbUtil.GetDataTable(lsxhCounts);
var sg_Counts = "select sum(fquantity) as sl from sg_gatherings where vmbillid='" + order.order_id + "'";
DataTable sg_Counts_Table = BusinessDbUtil.GetDataTable(lsxhCounts);
if (sg_Counts_Table != null && sg_Counts_Table.Rows.Count > 0 && lsxhCounts_Table.Rows[0]["sl"] == sg_Counts_Table.Rows[0]["sl"])
{
//小票明细数量和
BusinessDbUtil.GetDataTable("update sg_gathering set btotal= '1' where vmbillid ='" + order.order_id + "'");
}
if (flag2 && dataTable4 != null && dataTable4.Rows.Count > 0 && dataTable5 != null && dataTable5.Rows.Count > 0)
{
LogUtil.WriteInfo(this, "", "单据保存成功,对应单据编号为:" + DJBH);
result = true;
}
else
{
LogUtil.WriteInfo(this, "", string.Concat(new object[]
{
"单据保存失败,对应sql语句为:",
text2,
enumerable,
enumerable2
}));
}
}
catch (System.Exception ex)
{
LogUtil.WriteError(this, "", "单据保存成功,对应单据编号为:" + order.order_id);
}
}
}
}
else
{
LogUtil.WriteInfo(this, "", "单据已存在,对应单据编号为:" + order.order_id);
}
}
catch (Exception ex)
{
LogUtil.WriteError(this, sql, ex, "");
result = false;
}
});
this.UpdatesetAmountChangedState(order);
return(result);
}
/// <summary>
/// 采购退货
/// </summary>
/// <param name="qT_GoodsInfo2"></param>
private void InsertSPTHD(QT_GoodsInfo qT_GoodsInfo2)
{
string text2 = "SPTHD";
string empty = string.Empty;
Dictionary <string, DataTable> dictionary = new Dictionary <string, DataTable>();
Dictionary <string, DataTable> dictionary2 = new Dictionary <string, DataTable>();
List <Dictionary <string, DataTable> > list = new List <Dictionary <string, DataTable> >();
List <YanShouInfo> list2 = new List <YanShouInfo>();
string sql = "select top 1 KHDM,QDDM,CKDM,ZK,JGSD from kehu where khdm ='" + qT_GoodsInfo2.store_id + "'";
DataTable dataTable = BusinessDbUtil.GetDataTable(sql);
string zPSD = dataTable.Rows[0]["KHDM"].ToString();
string dM = dataTable.Rows[0]["CKDM"].ToString();
string text3 = dataTable.Rows[0]["JGSD"].ToString();
string qDDM = dataTable.Rows[0]["QDDM"].ToString();
Purchase purchase = new Purchase();
purchase.QDDM = qDDM;
//获取供货商代码
string sql3 = string.Format(@"select top 1 GHSDM from GONGHUOSHANG where GHSMC in (select top 1 shop_name from storeskulist
where store_id='{0}' and item_id='{1}' and sku_id='{2}')", zPSD, qT_GoodsInfo2.item_id, qT_GoodsInfo2.sku_id);
string dM2 = BusinessDbUtil.ExecuteScalar(sql3).ToString();
purchase.DM1 = dM2;
//添加虚拟总仓
purchase.DM2 = "QT_XNZC";
purchase.DM2_1 = "000";
purchase.LXDJ = "";
//直配的流程
purchase.DM4 = "ZP";
purchase.QYDM = "000";
purchase.BYZD1 = "0";
purchase.FPLX = "3";
purchase.YGDM = "000";
purchase.BYZD3 = "";
purchase.BYZD12 = "1";
purchase.YGDM = "000";
purchase.isonline = "1";
//他们那边的消息是拆分的
purchase.DJBH = InvoicesManage.GetNewDJBH(text2, purchase.QDDM, purchase.DM1, qT_GoodsInfo2.order_id);
purchase.ZPSD = zPSD;
string dJBH = purchase.DJBH;
purchase.SHR = "QT";
purchase.ZDR = "QT";
purchase.BZ = "蜻蜓平台同步";
purchase.RQ = DateTime.Now.ToString("yyyy-MM-dd");
purchase.YDJH = qT_GoodsInfo2.order_id;
YanShouInfo infoYS = new YanShouInfo();
infoYS.DJBH = purchase.DJBH;
infoYS.TableName = text2;
infoYS.User = "******";
infoYS.Procedure = string.Format("P_API_Oper_{0}_SH", text2); //验收
infoYS.BYZD3 = "";
list2.Add(infoYS);
dictionary = DataTableBusiness.SetBusinessDataTable <Purchase>(purchase, text2, "Purchase", text2);
dictionary2 = DataTableBusiness.SetEntryOrderDetail_QT_1(purchase.DJBH, text2, qT_GoodsInfo2, purchase.DM1);
if (dictionary.Count > 0 && dictionary2.Count > 0)
{
list.Add(dictionary);
list.Add(dictionary2);
}
if (list.Count > 0)
{
try
{
bool flag2 = DataTableBusiness.SavaBusinessData_SqlParameter(list, list2);
if (flag2)
{
sql = "update SPTHD set SPTHD.JE = (select SUM(JE) from SPTHDMX where SPTHDMX.DJBH='" + dJBH + "'),SPTHD.SL = (select SUM(SL) from SPTHDMX where SPTHDMX.DJBH='" + dJBH + "') where SPTHD.DJBH='" + dJBH + "'";
BusinessDbUtil.ExecuteNonQuery(sql);
}
this.UpdatesetAmountChangedState(qT_GoodsInfo2);
LogUtil.WriteInfo(this, "success", "SPTHD 创建成功DJBH" + dJBH);
// 生成商店退货单
Dictionary <string, DataTable> dic = new Dictionary <string, DataTable>();
Dictionary <string, DataTable> dicMX = new Dictionary <string, DataTable>();
List <YanShouInfo> ListNameInfoFACHU = new List <YanShouInfo>();
List <YanShouInfo> ListNameInfoYANSHOU = new List <YanShouInfo>();
List <Dictionary <string, DataTable> > BusinessList = new List <Dictionary <string, DataTable> >();
var DJBH = string.Empty;
var NewTableName = string.Empty;
shopinfo ShopInfo = new shopinfo();
ShopInfo.YDJH = dJBH;
ShopInfo.DM1 = qT_GoodsInfo2.store_id;
//添加虚拟总仓
ShopInfo.DM2 = "QT_XNZC";
ShopInfo.RQ = DateTime.Now.ToString("yyyy-MM-dd");
//ShopInfo.DM5 = orderInfo.brandID;
ShopInfo.DM4 = "ZP";
ShopInfo.DM2_1 = "000";
ShopInfo.ZDR = "QT";
ShopInfo.SL = qT_GoodsInfo2.amount.ToString();
ShopInfo.JE = "0";
ShopInfo.BZ = "蜻蜓平台同步";
bool exists = false;
if (!exists)
{
dic = DataTableBusiness.SetBusinessDataTable <shopinfo>(ShopInfo, "SDTHD", "shopinfo", "SDTHD", out DJBH);
ShopInfo.DJBH = DJBH;
dicMX = DataTableBusiness.SetEntryOrderDetail_QT_1(ShopInfo.DJBH, "SDTHD", qT_GoodsInfo2, ShopInfo.DM1);
if (dic.Count > 0 && dicMX.Count > 0)
{
BusinessList.Add(dic);
BusinessList.Add(dicMX);
}
infoYS = new YanShouInfo();
var infoFC = new YanShouInfo();
infoYS = InvoicesManage.GetYsInfo(DJBH, "SDTHD", "P_API_Oper_SDTHD_SH", "QT");
infoFC = InvoicesManage.GetYsInfo(DJBH, "SDTHD", "P_API_Oper_SDTHD_YS", "QT");
ListNameInfoYANSHOU.Add(infoFC);
ListNameInfoYANSHOU.Add(infoYS);
try
{
var resultList = DataTableBusiness.SavaBusinessData_SqlParameter(BusinessList, ListNameInfoYANSHOU);
if (resultList)
{
LogUtil.WriteInfo(this, "商店退货单保存成功", "DJBH:" + DJBH);
sql = "update SDTHD set SDTHD.JE = (select SUM(JE) from SDTHDMX where SDTHDMX.DJBH='" + DJBH + "'),SDTHD.SL = (select SUM(SL) from SDTHDMX where SDTHDMX.DJBH='" + DJBH + "') where SDTHD.DJBH='" + DJBH + "'";
BusinessDbUtil.ExecuteNonQuery(sql);
}
}
catch (System.Exception ex)
{
LogUtil.WriteError(this, "直配流程商店退货单保存失败", "DJBH:" + DJBH + "message:" + ex.Message);
}
}
else
{
//result = JsonHelper.SuccessXmlMsg("failure", "-1", string.Format("{0}保存单据失败,商店退货单据重复！", orderInfo.orderId));
LogUtil.WriteError(this, "直配流程商店退货单保存失败", "");
}
}
catch (Exception ex)
{
LogUtil.WriteError(this, "failure", string.Format("InsertSPTHD 保存单据失败，请检查系统日志！ {0} + BusinessList : {1}", qT_GoodsInfo2.order_id, JsonParser.ToJson(list)));
}
}
else
{
LogUtil.WriteError(this, "failure", string.Format("保存单据失败,无保存数据,请检查系统日志！", new object[0]));
}
}