using System;
|
using System.Collections.Generic;
|
using System.Text;
|
using System.Data;
|
using System.Windows.Forms;
|
|
namespace DAL
|
{
|
public class ClsXs_SeSampleBill_Extend_Ctl : DBUtility.ClsXt_BaseBill
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
public ClsXs_SeSampleBill_Extend_Model omodel = new ClsXs_SeSampleBill_Extend_Model();
|
|
public ClsXs_SeSampleBill_Extend_Ctl()
|
{
|
base.MvarItemKeySub = "";
|
base.MvarItemKeySub2 = "";
|
base.MvarItemKeySub3 = "";
|
base.MvarItemKeySub4 = "";
|
base.MvarItemKey = "Xs_SeSampleBill_Extend";
|
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 Xs_SeSampleBill_Extend " +
|
"(HBillNo,HCusNumber,HSelType,HReceiveStatus" +
|
",HRequester,HRequesterDate,HRequesterNote,HStatus" +
|
") " +
|
" values('" + omodel.HBillNo + "','" + omodel.HCusNumber + "','" + omodel.HSelType + "','" + omodel.HReceiveStatus + "'" +
|
",'" + omodel.HRequester + "','" + omodel.HRequesterDate + "','" + omodel.HRequesterNote + "'," + omodel.HStatus.ToString() +
|
") ");
|
//
|
Ds = oCn.RunProcReturn("exec h_p_GetNextChecker_SeSample '" + omodel.HBillNo + "'", "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(string lngBillKey, ref string sReturn)
|
{
|
try
|
{
|
//查询主表
|
DataSet Ds;
|
Ds = oCn.RunProcReturn("Select * from Xs_SeSampleBill_Extend Where HBillNo='" + lngBillKey + "' and isnull(HBacker,'')=''", "Xs_SeSampleBill_Extend");
|
if (Ds.Tables[0].Rows.Count == 0)
|
{
|
sReturn = "单据未找到！";
|
return false;
|
}
|
//固定赋值===========================================
|
omodel.HItemID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HItemID"]);
|
omodel.HBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBillNo"]);
|
//omodel.HInnerBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HInnerBillNo"]);
|
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.HSelType = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HSelType"]);
|
omodel.HReceiveMoney = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HReceiveMoney"]);
|
omodel.HReceiveStatus = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HReceiveStatus"]);
|
omodel.HRequester = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRequester"]);
|
omodel.HRequesterDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["HRequesterDate"]).ToShortDateString();
|
omodel.HRequesterNote = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRequesterNote"]);
|
|
omodel.HManager = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HManager"]);
|
omodel.HManagerDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["HManagerDate"]).ToShortDateString();
|
omodel.HManagerNote = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HManagerNote"]);
|
|
omodel.HAccManager = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HAccManager"]);
|
omodel.HAccManagerDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["HAccManagerDate"]).ToShortDateString();
|
omodel.HAccManagerNote = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HAccManagerNote"]);
|
omodel.HLstManager = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HLstManager"]);
|
omodel.HLstManagerDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["HLstManagerDate"]).ToShortDateString();
|
omodel.HLstManagerNote = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HLstManagerNote"]);
|
|
omodel.HProdMan = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HProdMan"]);
|
omodel.HProdManDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["HProdManDate"]).ToShortDateString();
|
omodel.HProdManNote = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HProdManNote"]);
|
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 Xs_SeSampleBill_Extend where HItemID=" + lngBillKey.ToString());
|
sReturn = "删除单据成功！";
|
oCn.Commit();
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
oCn.RollBack();
|
throw (e);
|
}
|
}
|
|
//审核
|
public bool CheckBill(string lngBillKey, double sMoney, string sHCheckItem, string sNote, ref string sReturn)
|
{
|
|
try
|
{
|
DataSet DsA;
|
DataSet Ds;
|
string HChecker = DBUtility.ClsPub.CurUserName;
|
Ds = oCn.RunProcReturn("exec h_p_Xs_SeSampleBill_Extend_Check '" + lngBillKey + "'," + sMoney.ToString() + ",'" + sHCheckItem + "','" + sNote + "','" + HChecker + "'", "Gy_Czygl");
|
if (Ds.Tables[0].Rows.Count == 0)
|
{
|
sReturn = "审核失败！";
|
return false;
|
}
|
sReturn = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0][0]);
|
//
|
DsA = oCn.RunProcReturn("exec h_p_GetNextChecker_SeSample '" + lngBillKey + "'", "Gy_Czygl");
|
if (DsA.Tables[0].Rows.Count == 0 || DsA == null)
|
{
|
sReturn = "创建审核流失败！";
|
return false;
|
}
|
if (DBUtility.ClsPub.isLong(DsA.Tables[0].Rows[0][0]) != 99)
|
{
|
sReturn = DBUtility.ClsPub.isStrNull(DsA.Tables[0].Rows[0][1]);
|
return false;
|
}
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
throw (e);
|
}
|
}
|
|
//关闭
|
public bool CloseBill(string lngBillKey, ref string sReturn)
|
{
|
|
try
|
{
|
string HCloseMan = DBUtility.ClsPub.CurUserName;
|
string HCloseDate = DBUtility.ClsPub.GetServerDate(-1);
|
oCn.RunProc(" Update Xs_SeSampleBill_Extend set HBacker='" + HCloseMan + "',HBackDate='" + HCloseDate + "' Where HBillNo='" + lngBillKey + "'");
|
//oCn.RunProc(" Delete Xs_SeSampleBill_Extend Where HBillNo='" + lngBillKey + "'");
|
DBUtility.ClsPub.Add_Log("", "退回产品需求单:"+lngBillKey, DBUtility.ClsPub.CurUserName);
|
sReturn = "";
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
throw (e);
|
}
|
}
|
|
|
|
|
|
}
|
}
|
