using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Linq;
|
using System.Text;
|
|
namespace DAL
|
{
|
public class ClsGy_StdWorkTimes_Ctl : DBUtility.ClsGy_Base_Ctl
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
//原代码 用于 替换子项目
|
public string HOldNumber;
|
public Model.ClsGy_StdWorkTimes_Model omodel = new Model.ClsGy_StdWorkTimes_Model();
|
public List<Model.ClsGy_StdWorkTimes_Model> DetailColl = new List<Model.ClsGy_StdWorkTimes_Model>();
|
|
//反审核
|
public bool AbandonCheck(Int64 lngBillKey, ref string sReturn)
|
{
|
try
|
{
|
oCn.RunProc(" Update Gy_StdWorkTimes set HChecker='',HCheckDate=null Where HItemID=" + lngBillKey.ToString());
|
sReturn = "";
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
return false;
|
}
|
}
|
|
//审核
|
public bool CheckBill(Int64 lngBillKey, ref string sReturn)
|
{
|
|
try
|
{
|
oCn.RunProc(" Update Gy_StdWorkTimes set HStopflag=0,HChecker='" + DBUtility.ClsPub.CurUserName + "',HCheckDate='" + DBUtility.ClsPub.GetServerDate(-1) + "' Where HItemID=" + lngBillKey.ToString());
|
//将其他 工价设置为 停用
|
//oCn.RunProc(" exec h_p_Gy_ProcPriceStopflag " + lngBillKey.ToString());
|
//
|
sReturn = "";
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
return false;
|
}
|
}
|
|
|
//新增
|
public override bool AddNew()
|
{
|
|
try
|
{
|
oCn.BeginTran();
|
//插入子表
|
foreach (Model.ClsGy_StdWorkTimes_Model oSub in DetailColl)
|
{
|
oCn.RunProc("Insert into Gy_StdWorkTimes " +
|
" (HMaterID,HProcID,HStdWorkTimes,HUpperlimit,HLowerlimit" +
|
",HStopflag,HMaker,HMakeDate,HRemark,HUSEORGID,HStdPiece,HStdPric)" +
|
" values(" + oSub.HMaterID.ToString() + "," + oSub.HProcID.ToString() + "," + oSub.HStdWorkTimes.ToString() +
|
"," + oSub.HUpperlimit.ToString() + "," + oSub.HLowerlimit.ToString() + "," + Convert.ToString(oSub.HStopflag ? 1 : 0) +
|
",'" + oSub.HMaker + "','" + oSub.HMakeDate + "','" + oSub.HRemark + "'," + oSub.HUSEORGID+","+ oSub.HStdPiece.ToString()+","+ oSub.HStdPric.ToString() + ")");
|
}
|
oCn.Commit();
|
return true;
|
}
|
catch (Exception e)
|
{
|
oCn.RollBack();
|
throw (e);
|
}
|
}
|
|
//修改
|
public override bool ModifyByID(Int64 sItemID)
|
{
|
try
|
{
|
oCn.BeginTran();
|
|
//插入表
|
foreach (Model.ClsGy_StdWorkTimes_Model oSub in DetailColl)
|
{
|
string sql = string.Format(@"Update Gy_StdWorkTimes set" +
|
" HMaterID=" + oSub.HMaterID.ToString() +
|
",HProcID=" + oSub.HProcID.ToString() +
|
",HStdWorkTimes=" + oSub.HStdWorkTimes.ToString() +
|
",HUpperlimit=" + oSub.HUpperlimit.ToString() +
|
",HLowerlimit=" + oSub.HLowerlimit.ToString() +
|
",HMaker='" + oSub.HMaker + "'" +
|
",HMakeDate='" + oSub.HMakeDate + "'" +
|
",HRemark='" + oSub.HRemark.ToString() + "'" +
|
",HUSEORGID=" + oSub.HUSEORGID +
|
" where HItemID=" + sItemID);
|
oCn.RunProc(sql);
|
}
|
oCn.Commit();
|
return true;
|
}
|
catch (Exception e)
|
{
|
oCn.RollBack();
|
throw (e);
|
}
|
}
|
|
//显示单据
|
public bool ShowBill(Int64 lngBillKey, ref string sReturn)
|
{
|
try
|
{
|
//查询主表
|
DataSet DsSub = new DataSet();
|
DsSub = oCn.RunProcReturn("Select * from Gy_StdWorkTimes Where HitemID=" + lngBillKey.ToString(), "Gy_StdWorkTimes");
|
DetailColl.Clear();//清空
|
for (int i = 0; i < DsSub.Tables[0].Rows.Count; i++)
|
{
|
Model.ClsGy_StdWorkTimes_Model oSub = new Model.ClsGy_StdWorkTimes_Model();
|
oSub.HMaterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HMaterID"]);
|
oSub.HProcID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HProcID"]);
|
oSub.HStdWorkTimes = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HStdWorkTimes"]);
|
oSub.HUpperlimit = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HUpperlimit"]);
|
oSub.HLowerlimit = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HLowerlimit"]);
|
oSub.HRemark = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HRemark"]);
|
oSub.HMaker = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HMaker"]);
|
oSub.HMakeDate = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HMakeDate"]);
|
oSub.HStopflag = ((DsSub.Tables[0].Rows[i]["HStopflag"].ToString() == "1")?true:false);
|
oSub.HUSEORGID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HUSEORGID"]);
|
|
DetailColl.Add(oSub);
|
}
|
sReturn = "显示单据成功！";
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
return false;
|
}
|
}
|
|
//根据物料ID、工序ID 删除 标准工时
|
public bool DeleteByMaterIDAndHProcID(Int64 HMaterID, Int64 HProcID)
|
{
|
try
|
{
|
oCn.RunProc("Delete from Gy_StdWorkTimes where HMaterID=" + HMaterID.ToString() + " and HProcID=" + HProcID.ToString());
|
return true;
|
}
|
catch (Exception e)
|
{
|
return false;
|
}
|
}
|
|
public ClsGy_StdWorkTimes_Ctl()
|
{
|
MvarItemKey = "Gy_StdWorkTimes";
|
MvarReportTitle = "标准工时资料";
|
}
|
}
|
}
|
