| | |
|---|
| | | |
|---|
| | | oCN.BeginTran(); |
|---|
| | | //销售出库删除回填销售订单关联数量 |
|---|
| | | oCN.RunProc("exec h_p_Xs_UpDateRelation_SeOrderToSellOut_Delete " + HInterID); |
|---|
| | | //oCN.RunProc("exec h_p_Xs_UpDateRelation_SeOrderToSellOut_Delete " + HInterID); |
|---|
| | | |
|---|
| | | oCN.RunProc("Delete From Kf_ICStockBillMain where HInterID = " + HInterID); |
|---|
| | | oCN.RunProc("Delete From Kf_ICStockBillSub where HInterID = " + HInterID); |
|---|
| | | //oCN.RunProc("Delete From Kf_ICStockBillMain where HInterID = " + HInterID); |
|---|
| | | //oCN.RunProc("Delete From Kf_ICStockBillSub where HInterID = " + HInterID); |
|---|
| | | |
|---|
| | | string sql = "exec h_p_WMS_ICStockBillAndWMS_Delete " + BillOld.omodel.HInterID + ",'" + BillOld.omodel.HBillNo + "','1205'"; |
|---|
| | | oCn.RunProc(sql); |
|---|
| | | |
|---|
| | | oCN.Commit(); |
|---|
| | | objJsonResult.code = "1"; |
|---|
| | | objJsonResult.count = 1; |
|---|
| | | objJsonResult.Message = "删除成功！"; |
|---|
| | | objJsonResult.Message = "您已删除单据号为" + BillOld.omodel.HBillNo + "的销售出库单！"; |
|---|
| | | objJsonResult.data = null; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | |
|---|
| | | { |
|---|
| | | if (sWhere == null || sWhere.Equals("")) |
|---|
| | | { |
|---|
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_SellOutBillList order by 单据号 desc", "h_v_IF_SellOutBillList"); |
|---|
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_SellOutBillList order by 制单日期 desc,单据号 desc", "h_v_IF_SellOutBillList"); |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_SellOutBillList where 1=1 " + sWhere + " order by 单据号 desc", "h_v_IF_SellOutBillList"); |
|---|
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_SellOutBillList where 1=1 " + sWhere + " order by 制单日期 desc,单据号 desc", "h_v_IF_SellOutBillList"); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | #endregion |
|---|
