using System;
|
using System.Collections.Generic;
|
using System.Text;
|
using System.Data;
|
|
namespace DAL
|
{
|
public class ClsSc_ICMOBillStatus_Tmp : DBUtility.ClsXt_BaseBill
|
{
|
//Éú²ú״̬ÁÙʱ±í
|
public Model.ClsSc_ICMOBillStatus_Tmp omodel = new Model.ClsSc_ICMOBillStatus_Tmp();
|
|
public ClsSc_ICMOBillStatus_Tmp()
|
{
|
base.MvarItemKeySub = "";
|
base.MvarItemKeySub2 = "";
|
base.MvarItemKeySub3 = "";
|
base.MvarItemKeySub4 = "";
|
base.MvarItemKey = "Sc_ICMOBillStatus_Tmp";
|
base.MvarReportTitle="Éú²ú״̬ÁÙʱ±í";
|
base.BillType = "3722";
|
}
|
|
#region ¹Ì¶¨´úÂë
|
|
~ClsSc_ICMOBillStatus_Tmp()
|
{
|
}
|
|
#endregion ×Ô¶¨Òå·½·¨
|
//Ð޸ĵ¥¾Ý
|
public override bool ModifyBill(Int64 lngBillKey, ref string sReturn)
|
{
|
try
|
{
|
//
|
oCn.BeginTran();
|
//¸üÐÂÖ÷±í
|
oCn.RunProc("UpDate Sc_ICMOBillStatus_Tmp set " +
|
" HYear=" + omodel.HYear.ToString() +
|
",HPeriod=" + omodel.HPeriod.ToString() +
|
",HBillType='" + omodel.HBillType + "'" +
|
",HDate='" + omodel.HDate.ToShortDateString() + "'" +
|
",HICMOInterID=" + omodel.HICMOInterID.ToString() +
|
",HICMOBillNo='" + omodel.HICMOBillNo + "'" +
|
",HSplitNO='" + omodel.HSplitNO + "'" +
|
",HICMOStatus=" + omodel.HICMOStatus.ToString() +
|
",HMaterID=" + omodel.HMaterID.ToString() +
|
",HMaterNumber='" + omodel.HMaterNumber + "'" +
|
",HUnitID=" + omodel.HUnitID.ToString() +
|
",HUnitNumber='" + omodel.HUnitNumber + "'" +
|
",HSourceID=" + omodel.HSourceID.ToString() +
|
",HSourceNumber='" + omodel.HSourceNumber + "'" +
|
",HPlanQty=" + omodel.HPlanQty.ToString() +
|
",HSplitPlanQty=" + omodel.HSplitPlanQty.ToString() +
|
",HSplitRelationQty=" + omodel.HSplitRelationQty.ToString() +
|
",HDatePlanQty=" + omodel.HDatePlanQty.ToString() +
|
",HUnitFinishQty=" + omodel.HUnitFinishQty.ToString() +
|
",HDateFinishQty=" + omodel.HDateFinishQty.ToString() +
|
",HBadQty=" + omodel.HBadQty.ToString() +
|
",HUnitBadQty=" + omodel.HUnitBadQty.ToString() +
|
",HWasterQty=" + omodel.HWasterQty.ToString() +
|
",HSumTimes=" + omodel.HSumTimes.ToString() +
|
",HFinishFlag=" + DBUtility.ClsPub.BoolToString(omodel.HFinishFlag) +
|
",HCurWorkFlag=" + DBUtility.ClsPub.BoolToString(omodel.HCurWorkFlag) +
|
",HCurQualityFlag=" + DBUtility.ClsPub.BoolToString(omodel.HCurQualityFlag) +
|
",HBeginDate='" + omodel.HBeginDate.ToShortDateString() + "'" +
|
",HEndDate='" + omodel.HEndDate.ToShortDateString() + "'" +
|
",HRemark='" + omodel.HRemark + "'" +
|
",HSourceInterID=" + omodel.HSourceInterID.ToString() +
|
",HSourceEntryID=" + omodel.HSourceEntryID.ToString() +
|
",HSourceBillNo='" + omodel.HSourceBillNo + "'" +
|
",HSourceBillType='" + omodel.HSourceBillType + "'" +
|
",HRelationInterID=" + omodel.HRelationInterID.ToString() +
|
" where HInterID=" + lngBillKey.ToString());
|
//ɾ³ý¹ØÁª
|
DeleteRelation(ref sReturn, lngBillKey);
|
|
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.HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo);
|
//ÈôMAINDIÖظ´ÔòÖØлñÈ¡
|
oCn.BeginTran();
|
//Ö÷±í
|
oCn.RunProc("Insert Into Sc_ICMOBillStatus_Tmp " +
|
"(HYear,HPeriod,HBillType,HDate,HICMOInterID" +
|
",HICMOBillNo,HSplitNO,HICMOStatus,HMaterID,HMaterNumber" +
|
",HUnitID,HUnitNumber,HSourceID,HSourceNumber,HPlanQty" +
|
",HSplitPlanQty,HSplitRelationQty,HDatePlanQty,HUnitFinishQty,HDateFinishQty" +
|
",HBadQty,HUnitBadQty,HWasterQty,HSumTimes,HFinishFlag" +
|
",HCurWorkFlag,HCurQualityFlag,HBeginDate,HEndDate,HRemark" +
|
",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationInterID" +
|
") " +
|
" values(" + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HBillType + "','" + omodel.HDate.ToShortDateString() + "'," + omodel.HICMOInterID.ToString() +
|
",'" + omodel.HICMOBillNo + "','" + omodel.HSplitNO + "'," + omodel.HICMOStatus.ToString() + "," + omodel.HMaterID.ToString() + ",'" + omodel.HMaterNumber + "'" +
|
"," + omodel.HUnitID.ToString() + ",'" + omodel.HUnitNumber + "'," + omodel.HSourceID.ToString() + ",'" + omodel.HSourceNumber + "'," + omodel.HPlanQty.ToString() +
|
"," + omodel.HSplitPlanQty.ToString() + "," + omodel.HSplitRelationQty.ToString() + "," + omodel.HDatePlanQty.ToString() + "," + omodel.HUnitFinishQty.ToString() + "," + omodel.HDateFinishQty.ToString() +
|
"," + omodel.HBadQty.ToString() + "," + omodel.HUnitBadQty.ToString() + "," + omodel.HWasterQty.ToString() + "," + omodel.HSumTimes.ToString() + "," + DBUtility.ClsPub.BoolToString(omodel.HFinishFlag) +
|
"," + DBUtility.ClsPub.BoolToString(omodel.HCurWorkFlag) + "," + DBUtility.ClsPub.BoolToString(omodel.HCurQualityFlag) + ",'" + omodel.HBeginDate.ToShortDateString() + "','" + omodel.HEndDate.ToShortDateString() + "','" + omodel.HRemark + "'" +
|
"," + omodel.HSourceInterID.ToString() + "," + omodel.HSourceEntryID.ToString() + ",'" + omodel.HSourceBillNo + "','" + omodel.HSourceBillType + "'," + omodel.HRelationInterID.ToString() +
|
") ");
|
|
sReturn = "ÐÂÔöµ¥¾Ý³É¹¦£¡";
|
oCn.Commit();
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
oCn.RollBack();
|
throw (e);
|
}
|
}
|
//ÏÔʾµ¥¾Ý
|
public override bool ShowBill(Int64 lngBillKey, ref string sReturn)
|
{
|
try
|
{
|
//²éѯÖ÷±í
|
DataSet Ds ;
|
Ds = oCn.RunProcReturn("Select * from Sc_ICMOBillStatus_Tmp Where HInterID=" + lngBillKey.ToString(), "Sc_ICMOBillStatus_Tmp");
|
if(Ds.Tables[0].Rows.Count==0)
|
{
|
sReturn = "µ¥¾ÝδÕÒµ½£¡";
|
return false;
|
}
|
//¸³Öµ
|
omodel.HYear = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HYear"]);
|
omodel.HPeriod = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HPeriod"]);
|
omodel.HBillType = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBillType"]);
|
omodel.HDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["HDate"]);
|
omodel.HICMOInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HICMOInterID"]);
|
omodel.HICMOBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HICMOBillNo"]);
|
omodel.HSplitNO = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HSplitNO"]);
|
omodel.HICMOStatus = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HICMOStatus"]);
|
omodel.HMaterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HMaterID"]);
|
omodel.HMaterNumber = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HMaterNumber"]);
|
omodel.HUnitID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HUnitID"]);
|
omodel.HUnitNumber = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HUnitNumber"]);
|
omodel.HSourceID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HSourceID"]);
|
omodel.HSourceNumber = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HSourceNumber"]);
|
omodel.HPlanQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HPlanQty"]);
|
omodel.HSplitPlanQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HSplitPlanQty"]);
|
omodel.HSplitRelationQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HSplitRelationQty"]);
|
omodel.HDatePlanQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HDatePlanQty"]);
|
omodel.HUnitFinishQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HUnitFinishQty"]);
|
omodel.HDateFinishQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HDateFinishQty"]);
|
omodel.HBadQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HBadQty"]);
|
omodel.HUnitBadQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HUnitBadQty"]);
|
omodel.HWasterQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HWasterQty"]);
|
omodel.HSumTimes = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HSumTimes"]);
|
omodel.HFinishFlag = DBUtility.ClsPub.isBool(Ds.Tables[0].Rows[0]["HFinishFlag"]);
|
omodel.HCurWorkFlag = DBUtility.ClsPub.isBool(Ds.Tables[0].Rows[0]["HCurWorkFlag"]);
|
omodel.HCurQualityFlag = DBUtility.ClsPub.isBool(Ds.Tables[0].Rows[0]["HCurQualityFlag"]);
|
omodel.HBeginDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["HBeginDate"]);
|
omodel.HEndDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["HEndDate"]);
|
omodel.HRemark = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRemark"]);
|
omodel.HSourceInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HSourceInterID"]);
|
omodel.HSourceEntryID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HSourceEntryID"]);
|
omodel.HSourceBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HSourceBillNo"]);
|
omodel.HSourceBillType = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HSourceBillType"]);
|
omodel.HRelationInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HRelationInterID"]);
|
//
|
|
|
sReturn = "ÏÔʾµ¥¾Ý³É¹¦£¡";
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
throw (e);
|
}
|
}
|
|
//ÅжÏÊÇ·ñ¿ª¹¤
|
public bool IsStarted(long HInterID,long HEntryID, ref string sReturn)
|
{
|
try
|
{
|
DataSet DS;
|
DS = oCn.RunProcReturn("select HBeginDate from Sc_ICMOBillStatus_Tmp where HInterID=" + HInterID.ToString() + " ", "Sc_ICMOBillStatus_Tmp");
|
if (DS.Tables[0].Rows.Count == 0)
|
{
|
sReturn = "µ¥¾ÝδÕÒµ½£¡";
|
return false;
|
}
|
if (DBUtility.ClsPub.isDate(DS.Tables[0].Rows[0]["HBeginDate"]) > DBUtility.ClsPub.isDate("1900-01-01"))
|
{
|
sReturn = "ÒÑ¿ª¹¤£¡";
|
return true;
|
}
|
else
|
{
|
sReturn = "먦¹¤£¡";
|
return false;
|
}
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
throw (e);
|
}
|
}
|
|
//UPDATEÉú²ú״̬±í ÉèÖÿªÊ¼Ê±¼ä¡¢µ±Ç°Éú²ú±ê¼Ç¡¢ÈÎÎñµ¥×´Ì¬1£©
|
public bool Fun_SetStart(long HInterID, long HEntryID,long HSourceID, ref string sReturn)
|
{
|
try
|
{
|
//
|
oCn.BeginTran();
|
//¸üб¾Éú²ú×ÊÔ´È«²¿ ²»Êǵ±Ç°±ê¼Ç
|
oCn.RunProc("UpDate Sc_ICMOBillStatus_Tmp set " +
|
"HCurWorkFlag=0" +
|
" where HSourceID=" + HSourceID.ToString() + " ");
|
//¸üÐÂ
|
oCn.RunProc("UpDate Sc_ICMOBillStatus_Tmp set " +
|
"HICMOStatus=1" +
|
",HCurWorkFlag=1" +
|
",HBeginDate='" + DBUtility.ClsPub.GetServerDate(-1) + "'" +
|
" where HInterID=" + HInterID.ToString() + " ");
|
//
|
sReturn = "Ð޸ĵ¥¾Ý³É¹¦£¡";
|
oCn.Commit();
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
oCn.RollBack();
|
throw (e);
|
}
|
}
|
|
|
//ÅжÏÊÇ·ñÍ깤
|
public bool IsEnded(long HInterID, long HEntryID, ref string sReturn)
|
{
|
try
|
{
|
DataSet DS;
|
DS = oCn.RunProcReturn("select HEndDate from Sc_ICMOBillStatus_Tmp where HInterID=" + HInterID.ToString() + " ", "Sc_ICMOBillStatus_Tmp");
|
if (DS.Tables[0].Rows.Count == 0)
|
{
|
sReturn = "µ¥¾ÝδÕÒµ½£¡";
|
return false;
|
}
|
if (DBUtility.ClsPub.isDate(DS.Tables[0].Rows[0]["HEndDate"]) > DBUtility.ClsPub.isDate("1900-01-01"))
|
{
|
sReturn = "ÒÑÍ깤£¡";
|
return true;
|
}
|
else
|
{
|
sReturn = "δÍ깤£¡";
|
return false;
|
}
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
throw (e);
|
}
|
}
|
|
//UPDATEÉú²ú״̬±í ÉèÖÿªÊ¼Ê±¼ä¡¢µ±Ç°Éú²ú±ê¼Ç¡¢Í깤±ê¼Ç1¡¢ÈÎÎñµ¥×´Ì¬3£©
|
public bool Fun_SetEnd(long HInterID, long HEntryID, ref string sReturn)
|
{
|
try
|
{
|
//
|
oCn.BeginTran();
|
//¸üÐÂÖ÷±í
|
oCn.RunProc("UpDate Sc_ICMOBillStatus_Tmp set " +
|
"HICMOStatus=3" +
|
",HCurWorkFlag=0" +
|
",HFinishFlag=1" +
|
",HEndDate='" + DBUtility.ClsPub.GetServerDate(-1) + "'" +
|
" where HInterID=" + HInterID.ToString() + " ");
|
//
|
sReturn = "Ð޸ĵ¥¾Ý³É¹¦£¡";
|
oCn.Commit();
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
oCn.RollBack();
|
throw (e);
|
}
|
}
|
|
}
|
|
}
|
