using DBUtility;
|
using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Linq;
|
using System.Text;
|
|
namespace DAL
|
{
|
public class ClsGy_MateMould_Ctl : DBUtility.ClsGy_Base_Ctl
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
//原代码 用于 替换子项目
|
public string HOldNumber;
|
public List<Model.ClsGy_MateMould_Model> DetailColl = new List<Model.ClsGy_MateMould_Model>();
|
|
//反审核
|
public bool AbandonCheck(Int64 lngBillKey, ref string sReturn)
|
{
|
try
|
{
|
oCn.RunProc(" Update Gy_MateMouldInfo 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_MateMouldInfo set HUsed=0,HChecker='" + DBUtility.ClsPub.CurUserName + "',HCheckDate='" + DBUtility.ClsPub.GetServerDate(-1) + "' Where HItemID=" + lngBillKey.ToString());
|
//将其他 工价设置为 停用
|
oCn.RunProc(" exec h_p_Gy_MateMouldStopflag " + lngBillKey.ToString());
|
//
|
sReturn = "";
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
return false;
|
}
|
}
|
|
|
//新增
|
public override bool AddNew()
|
{
|
|
try
|
{
|
oCn.BeginTran();
|
|
|
//插入表
|
foreach (Model.ClsGy_MateMould_Model oSub in DetailColl)
|
{
|
DataSet Ds;
|
Int64 HInterID = 1;
|
Ds = oCn.RunProcReturn("select MAX(HInterID) HInterID from Gy_MateMouldInfo", "Gy_MateMouldInfo");
|
if (Ds.Tables[0].Rows.Count != 0 && ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"].ToString()) != 0)
|
{
|
HInterID = ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"].ToString());
|
HInterID += 1;
|
}
|
|
DataSet Cs;
|
Int64 HEntryID = 1;
|
Cs = oCn.RunProcReturn("select MAX(HEntryID) HEntryID from Gy_MateMouldInfo", "Gy_MateMouldInfo");
|
if (Cs.Tables[0].Rows.Count != 0 && ClsPub.isLong(Cs.Tables[0].Rows[0]["HEntryID"].ToString()) != 0)
|
{
|
HEntryID = ClsPub.isLong(Cs.Tables[0].Rows[0]["HEntryID"].ToString());
|
HEntryID += 1;
|
}
|
|
oCn.RunProc("Insert into Gy_MateMouldInfo " +
|
" (HInterID,HEntryID,HMaterID,HRelationID,HUnitID" +
|
",HBeginDate,HEndDate" +
|
",HUsed,HRemark,HMaker,HMakeDate,HType,HMouldQty,HProcID)" +
|
" values(" + HInterID + "," + HEntryID + "," + oSub.HMaterID.ToString() + "," + oSub.HRelationID.ToString() + "," + oSub.HUnitID.ToString() +
|
",'" + oSub.HBeginDate.ToShortDateString() + "','" + oSub.HEndDate.ToShortDateString() + "'," + Convert.ToString(oSub.HUsed ? 1 : 0) + ",'" + oSub.HRemark + "','" + oSub.HMaker + "','" + oSub.HMakeDate + "','" + 1 + "','" + 1 + "','" + 1 + "') ");
|
}
|
oCn.Commit();
|
return true;
|
}
|
catch (Exception e)
|
{
|
oCn.RollBack();
|
throw (e);
|
}
|
}
|
|
//修改
|
public override bool ModifyByID(Int64 sItemID)
|
{
|
try
|
{
|
oCn.BeginTran();
|
//DeleteByID(sItemID); //删除记录
|
////插入表
|
foreach (Model.ClsGy_MateMould_Model oSub in DetailColl)
|
{
|
// oCn.RunProc("Insert into Gy_MateMouldInfo " +
|
// " (HMaterID,HRelationID,HUnitID" +
|
// ",HBeginDate,HEndDate" +
|
// ",HUsed,HRemark,HMaker,HMakeDate)" +
|
// " values(" + oSub.HMaterID.ToString() + "," + oSub.HRelationID.ToString() + "," + oSub.HUnitID.ToString() +
|
// ",'" + oSub.HBeginDate.ToShortDateString() + "','" + oSub.HEndDate.ToShortDateString() + "'," + Convert.ToString(oSub.HUsed ? 1 : 0) + ",'" + oSub.HRemark + "','" + oSub.HMaker + "','" + oSub.HMakeDate + "') ");
|
oCn.RunProc("Update Gy_MateMouldInfo set " +
|
"HRemark='" + oSub.HRemark + "'" +
|
",HMaterID='" + oSub.HMaterID + "'" +
|
",HRelationID='" + oSub.HRelationID + "'" +
|
",HUnitID='" + oSub.HUnitID + "'" +
|
//",HStopflag=" + Convert.ToString(HStopflag ? 1 : 0) +
|
//",HUseFlag=" + Convert.ToString(HUseFlag ? 1 : 0) +
|
//",HMakeTime= getdate()" +
|
//",HMakeEmp='" + HMakeEmp + "'" +
|
/*",HRemark='" + HRemark + */"Where HItemID ='" + sItemID + "'", ref DBUtility.ClsPub.sExeReturnInfo);
|
}
|
//oCn.RunProc("Update Gy_MateMouldInfo set " +
|
// " HMaterID='" + oSub.HMaterID.ToString() + "'" +
|
// ",HRelationID='" + oSub.HRelationID.ToString() + "'" +
|
// ",HUnitID='" + oSub.HUnitID.ToString() + "'" +
|
// ",HTechParamID='" + HTechParamID + "'" +
|
// ",HTechParamUnitID='" + HTechParamUnitID + "'" +
|
// ",HDeptID='" + HDeptID + "'" +
|
// ",HRemark='" + oSub.HRemark + "'" +
|
// //",HStopflag=" + Convert.ToString(HStopflag ? 1 : 0) +
|
// //",HUseFlag=" + Convert.ToString(HUseFlag ? 1 : 0) +
|
// //",HMakeTime= getdate()" +
|
// //",HMakeEmp='" + HMakeEmp + "'" +
|
// /*",HRemark='" + HRemark + */"Where HItemID ='" + sItemID + "'", ref DBUtility.ClsPub.sExeReturnInfo);
|
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_MateMouldInfo Where HitemID=" + lngBillKey.ToString(), "Gy_MateMouldInfo");
|
DetailColl.Clear();//清空
|
for (int i = 0; i < DsSub.Tables[0].Rows.Count; i++)
|
{
|
Model.ClsGy_MateMould_Model oSub = new Model.ClsGy_MateMould_Model();
|
oSub.HMaterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HMaterID"]);
|
oSub.HRelationID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HRelationID"]);
|
oSub.HUnitID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HUnitID"]);
|
oSub.HBeginDate = DBUtility.ClsPub.isDate(DsSub.Tables[0].Rows[i]["HBeginDate"]);
|
oSub.HEndDate = DBUtility.ClsPub.isDate(DsSub.Tables[0].Rows[i]["HEndDate"]);
|
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.HChecker = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HChecker"]);
|
oSub.HCheckDate = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HCheckDate"]);
|
|
DetailColl.Add(oSub);
|
}
|
sReturn = "显示单据成功！";
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
return false;
|
}
|
}
|
|
//批改单据
|
//public bool BatchModifyBill(Int64 lngBillKey, double sPrice, ref string sReturn)
|
//{
|
// try
|
// {
|
// oCn.BeginTran();
|
// oCn.RunProc(" Update Gy_MateMouldInfo set HPrice=" + sPrice.ToString() + " Where HItemID=" + lngBillKey.ToString());
|
// sReturn = "修改单据成功！";
|
// oCn.Commit();
|
// return true;
|
// }
|
// catch (Exception e)
|
// {
|
// sReturn = e.Message;
|
// oCn.RollBack();
|
// return false;
|
// }
|
//}
|
|
//根据物料和工序返回工价 //b 单价为ture，定额为false
|
//public double LoadProcPrice(Int64 sMaterID, Int64 sProcID, Int64 sSourceID, bool b)
|
//{
|
// double sPrice = 0;
|
// try
|
// {
|
// //查询主表
|
// DataSet DsSub = new DataSet();
|
// DsSub = oCn.RunProcReturn("Select top 1 * from Gy_ProcPrice Where HStopflag=0 and HEndDate>=convert(varchar(10),Getdate(),120) and HChecker<>'' and HMaterID=" + sMaterID.ToString() + " and HProcID=" + sProcID.ToString() + " and HSourceID=" + sSourceID.ToString(), "Gy_ProcPrice");
|
// if (DsSub == null)
|
// {
|
// return 0;
|
// }
|
// if (b)
|
// {
|
// sPrice = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[0]["HPrice"]);
|
// }
|
// else
|
// {
|
// sPrice = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[0]["HFixPrice"]);
|
// }
|
// return sPrice;
|
// }
|
// catch (Exception e)
|
// {
|
// return 0;
|
// }
|
//}
|
|
//构造函数
|
public ClsGy_MateMould_Ctl()
|
{
|
MvarItemKey = "Gy_MateMouldInfo";
|
MvarReportTitle = "模具对应产品资料";
|
}
|
}
|
}
|
