using System;
|
using System.Collections.Generic;
|
using System.Text;
|
using System.Data;
|
using System.Windows.Forms;
|
|
namespace DAL
|
{
|
public class ClsK3_SeOrderBill_CheckExtend_Ctl : DBUtility.ClsXt_BaseBill
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
public ClsK3_SeOrderBill_CheckExtend_Model omodel = new ClsK3_SeOrderBill_CheckExtend_Model();
|
|
public ClsK3_SeOrderBill_CheckExtend_Ctl()
|
{
|
base.MvarItemKeySub = "";
|
base.MvarItemKeySub2 = "";
|
base.MvarItemKeySub3 = "";
|
base.MvarItemKeySub4 = "";
|
base.MvarItemKey = "K3_SeOrderBill_CheckExtend";
|
base.MvarReportTitle = "销售订单评审";
|
base.BillType = "";
|
base.HBillSubType = "";
|
|
}
|
|
//修改单据
|
public override bool ModifyBill(Int64 lngBillKey, ref string sReturn)
|
{
|
return true;
|
//try
|
//{
|
// //
|
// oCn.BeginTran();
|
// //更新主表
|
// oCn.RunProc("UpDate Kf_ICStockBillMain set " +
|
// " HBillNo='" + omodel.HBillNo + "'" + //固定赋值===============
|
// ",HDate='" + omodel.HDate + "'" +
|
// ",HYear='" + omodel.HYear.ToString() + "'" +
|
// ",HPeriod='" + omodel.HPeriod.ToString() + "'" +
|
// ",HRemark='" + omodel.HRemark + "'" +
|
// ",HUpDater='" + DBUtility.ClsPub.CurUserName + "'" +
|
// ",HUpDateDate=getdate()" +
|
// //========================================
|
// ",HSupID=" + omodel.HSupID.ToString() +
|
// ",HWHID=" + omodel.HWHID.ToString() +
|
// ",HSCWHID=" + omodel.HSCWHID.ToString() +
|
// ",HManagerID=" + omodel.HMangerID.ToString() +
|
// ",HSecManagerID=" + omodel.HSecManagerID.ToString() +
|
// ",HKeeperID=" + omodel.HKeeperID.ToString() +
|
// ",HDeptID=" + omodel.HDeptID.ToString() +
|
// ",HExplanation='" + omodel.HExplanation + "'" +
|
// ",HInnerBillNo='" + omodel.HInnerBillNo + "'" +
|
// ",HRedBlueFlag=" + DBUtility.ClsPub.BoolToString(omodel.HRedBlueFlag) +
|
// " where HInterID=" + lngBillKey.ToString());
|
// //删除关联
|
// DeleteRelation(ref sReturn, lngBillKey);
|
// //删除子表
|
// DeleteBillSub(lngBillKey);
|
// //插入子表
|
// omodel.HInterID = lngBillKey;
|
// foreach (Model.ClsKf_EntrustInBillSub oSub in DetailColl)
|
// {
|
// oCn.RunProc("Insert into Kf_ICStockBillSub " +
|
// " (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" +
|
// ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
|
// ",HMaterID,HPropertyID,HSecUnitID,HSecUnitRate,HUnitID,HQtyMust" +
|
// ",HQty,HPrice,HMoney,HWHID,HSCWHID,HSPID" +
|
// ",HSCSPID,HSPGroupID,HBatchNo,HPOOrderInterID,HPOOrderEntryID,HPOOrderBillNo" +
|
// ",HSeOrderInterID,HSeOrderEntryID,HSeOrderBillNo" +
|
// ") values("
|
// + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate.ToShortDateString() + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" +
|
// "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() +
|
// "," + oSub.HMaterID.ToString() + "," + oSub.HPropertyID.ToString() + "," + oSub.HSecUnitID.ToString() + "," + oSub.HSecUnitRate.ToString() + "," + oSub.HUnitID.ToString() + "," + oSub.HQtyMust.ToString() +
|
// "," + oSub.HQty.ToString() + "," + oSub.HPrice.ToString() + "," + oSub.HMoney.ToString() + "," + oSub.HWHID.ToString() + "," + oSub.HSCWHID.ToString() + "," + oSub.HSPID.ToString() +
|
// "," + oSub.HSCSPID.ToString() + "," + oSub.HSPGroupID.ToString() + ",'" + oSub.HBatchNo + "'," + oSub.HPOOrderInterID.ToString() + "," + oSub.HPOOrderEntryID.ToString() + ",'" + oSub.HPOOrderBillNo + "'" +
|
// "," + oSub.HSeOrderInterID.ToString() + "," + oSub.HSeOrderEntryID.ToString() + ",'" + oSub.HSeOrderBillNo + "'" +
|
// ") ");
|
// }
|
// //
|
// //foreach (Model.ClsKf_EntrustInBillSub oSub in DetailColl)
|
// //{
|
// // Ds = oCn.RunProcReturn("exec h_p_Kf_EntrustInBill_Qty " + oSub.HICMOInterID, "");
|
// // if (Ds.Tables[0].Rows.Count == 0)
|
// // return;
|
// // if (DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBool"]) == "Y")
|
// // {
|
// // sReturn = "汇报数量超过计划数量！不允许保存";
|
// // return false;
|
// // }
|
// //}
|
// sReturn = "修改单据成功！";
|
// oCn.Commit();
|
// return true;
|
//}
|
//catch (Exception e)
|
//{
|
// sReturn = e.Message;
|
// oCn.RollBack();
|
// throw (e);
|
//}
|
}
|
//新增单据
|
public override bool AddBill(ref string sReturn)
|
{
|
try
|
{
|
//得到mainid
|
//omodel.HItemID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo);
|
//若MAINDI重复则重新获取
|
DataSet Ds;
|
oCn.BeginTran();
|
//主表
|
oCn.RunProc("Insert Into K3_SeOrderBill_CheckExtend " +
|
"(HBillNo,HInterID,HCusID,HCusNumber" +
|
",HDataChecker,HDataCheckDate,HDataCheckNote,HStatus" +
|
") " +
|
" values('" + omodel.HBillNo + "'," + omodel.HInterID.ToString() + "," + omodel.HCusID.ToString() + ",'" + omodel.HCusNumber + "'" +
|
",'" + omodel.HDataChecker + "','" + omodel.HDataCheckDate + "','" + omodel.HDataCheckNote + "'," + omodel.HStatus.ToString() +
|
") ");
|
//
|
Ds = oCn.RunProcReturn("exec h_p_GetNextChecker_Order " + omodel.HInterID.ToString(), "Gy_Czygl");
|
if (Ds.Tables[0].Rows.Count == 0)
|
{
|
sReturn = "创建审核流失败！";
|
oCn.RollBack();
|
return false;
|
}
|
if (DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0][0]) != 99)
|
{
|
sReturn = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0][1]);
|
oCn.RollBack();
|
return false;
|
}
|
sReturn = "新增单据成功！";
|
oCn.Commit();
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
oCn.RollBack();
|
throw (e);
|
}
|
}
|
//显示单据
|
public bool ShowBill(long lngBillKey, ref string sReturn)
|
{
|
try
|
{
|
//查询主表
|
DataSet Ds;
|
Ds = oCn.RunProcReturn("Select * from K3_SeOrderBill_CheckExtend Where HInterID=" + lngBillKey.ToString(), "K3_SeOrderBill_CheckExtend");
|
if (Ds.Tables[0].Rows.Count == 0)
|
{
|
sReturn = "单据未找到！";
|
return false;
|
}
|
//固定赋值===========================================
|
omodel.HItemID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HItemID"]);
|
omodel.HInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"]);
|
omodel.HBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBillNo"]);
|
omodel.HCusID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HCusID"]);
|
omodel.HCusNumber = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HCusNumber"]);
|
omodel.HBacker = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBacker"]);
|
omodel.HBackDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["HBackDate"]);
|
|
omodel.HDataChecker = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HDataChecker"]);
|
omodel.HDataCheckDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["HDataCheckDate"]).ToShortDateString();
|
omodel.HDataCheckNote = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HDataCheckNote"]);
|
omodel.HOverRateChecker = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HOverRateChecker"]);
|
omodel.HOverRateCheckDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["HOverRateCheckDate"]).ToShortDateString();
|
omodel.HOverRateCheckNote = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HOverRateCheckNote"]);
|
omodel.HProdAbilityChecker = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HProdAbilityChecker"]);
|
omodel.HProdAbilityCheckDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["HProdAbilityCheckDate"]).ToShortDateString();
|
omodel.HProdAbilityCheckNote = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HProdAbilityCheckNote"]);
|
omodel.HCostChecker = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HCostChecker"]);
|
omodel.HCostCheckDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["HCostCheckDate"]).ToShortDateString();
|
omodel.HCostCheckNote = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HCostCheckNote"]);
|
omodel.HAccAgeChecker = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HAccAgeChecker"]);
|
omodel.HAccAgeCheckDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["HAccAgeCheckDate"]).ToShortDateString();
|
omodel.HAccAgeCheckNote = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HAccAgeCheckNote"]);
|
omodel.HStatus = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HStatus"]);
|
//========================================================
|
sReturn = "显示单据成功！";
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
throw (e);
|
}
|
}
|
|
public override bool DeleteBill(long lngBillKey, ref string sReturn)
|
{
|
try
|
{
|
oCn.BeginTran();
|
//删除主表
|
oCn.RunProc("Delete From K3_SeOrderBill_CheckExtend where HItemID=" + lngBillKey.ToString());
|
sReturn = "删除单据成功！";
|
oCn.Commit();
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
oCn.RollBack();
|
throw (e);
|
}
|
}
|
|
//审核
|
public bool CheckBill(long lngBillKey, long sStatus, string sNote, ref string sReturn)
|
{
|
|
try
|
{
|
string HChecker = DBUtility.ClsPub.CurUserName;
|
string HCheckDate = DBUtility.ClsPub.GetServerDate(-1);
|
if (sStatus == 1)
|
{
|
oCn.RunProc(" Update K3_SeOrderBill_CheckExtend set HDataChecker='" + HChecker + "',HDataCheckDate='" + HCheckDate + "',HDataCheckNote='" + sNote + "' Where HInterID=" + lngBillKey.ToString());
|
}
|
else if (sStatus == 2)
|
{
|
oCn.RunProc(" Update K3_SeOrderBill_CheckExtend set HOverRateChecker='" + HChecker + "',HOverRateCheckDate='" + HCheckDate + "',HOverRateCheckNote='" + sNote + "' Where HInterID=" + lngBillKey.ToString());
|
}
|
else if (sStatus == 3)
|
{
|
oCn.RunProc(" Update K3_SeOrderBill_CheckExtend set HProdAbilityChecker='" + HChecker + "',HProdAbilityCheckDate='" + HCheckDate + "',HProdAbilityCheckNote='" + sNote + "' Where HInterID=" + lngBillKey.ToString());
|
}
|
else if (sStatus == 4)
|
{
|
oCn.RunProc(" Update K3_SeOrderBill_CheckExtend set HCostChecker='" + HChecker + "',HCostCheckDate='" + HCheckDate + "',HCostCheckNote='" + sNote + "' Where HInterID=" + lngBillKey.ToString());
|
}
|
else if (sStatus == 5)
|
{
|
oCn.RunProc(" Update K3_SeOrderBill_CheckExtend set HAccAgeChecker='" + HChecker + "',HAccAgeCheckDate='" + HCheckDate + "',HAccAgeCheckNote='" + sNote + "' Where HInterID=" + lngBillKey.ToString());
|
}
|
sReturn = "审核成功！";
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
throw (e);
|
}
|
}
|
|
//关闭
|
public bool CloseBill(long lngBillKey, ref string sReturn)
|
{
|
|
try
|
{
|
string HCloseMan = DBUtility.ClsPub.CurUserName;
|
string HCloseDate = DBUtility.ClsPub.GetServerDate(-1);
|
oCn.RunProc(" Update K3_SeOrderBill_CheckExtend set HBacker='" + HCloseMan + "',HBackDate='" + HCloseDate + "' Where HInterID=" + lngBillKey.ToString());
|
sReturn = "";
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
throw (e);
|
}
|
}
|
|
|
|
|
|
}
|
}
|
