using System;
|
using System.Collections.Generic;
|
using System.Text;
|
using System.Data;
|
|
namespace DAL
|
{
|
public class ClsWeb_BarCodeBill : DBUtility.ClsXt_BaseBill
|
{
|
public Model.ClsCg_POInStockBillMain omodel = new Model.ClsCg_POInStockBillMain();
|
public SQLHelper.ClsCNSRM oCn = new SQLHelper.ClsCNSRM();
|
public string MvarItemKeySubForWeb3 = "h_v_Web_BarCodeBill_ForWeb1";
|
public string MvarItemKeySubForWeb4 = "h_v_Web_BarCodeBill_ForWeb2";
|
|
public ClsWeb_BarCodeBill()
|
{
|
base.MvarItemKeyForWeb = "h_v_SRM_POInStockBillMain_ForWeb2";
|
base.MvarItemKeySubForWeb = "h_v_SRM_POInStockBillSub_ForWeb2";
|
base.MvarItemKeySubForWeb2 = "h_v_Web_BarCodeBill_ForWeb";
|
base.MvarItemKeySub = "";
|
base.MvarItemKeySub2 = "";
|
base.MvarItemKeySub3 = "";
|
base.MvarItemKeySub4 = "";
|
base.MvarItemKey = "";
|
base.MvarReportTitle = "";
|
base.BillType = "";
|
|
|
}
|
|
#region 固定代码
|
|
~ClsWeb_BarCodeBill()
|
{
|
//DetailColl = null;
|
}
|
|
#endregion 自定义方法
|
|
|
|
public DataSet ShowBillMain(long lngBillKey, string sShowItem, ref string sReturn)
|
{
|
string str = "";
|
try
|
{
|
str = "Select " + sShowItem + " from " + this.MvarItemKeyForWeb + " Where HInterID=" + lngBillKey.ToString();
|
DataSet set = oCn.RunProcReturn("Select " + sShowItem + " from " + this.MvarItemKeyForWeb + " Where HInterID=" + lngBillKey.ToString(), this.MvarItemKeyForWeb);
|
if ((set == null) || (set.Tables[0].Rows.Count == 0))
|
{
|
sReturn = "单据头未找到！";
|
return null;
|
}
|
sReturn = "显示单据头成功！";
|
return set;
|
}
|
catch (Exception exception)
|
{
|
sReturn = exception.Message;
|
return null;
|
}
|
}
|
public DataSet ShowBillMain1(long lngBillKey, string sShowItem, ref string sReturn)
|
{
|
string str = "";
|
try
|
{
|
str = "Select " + sShowItem + " from " + this.MvarItemKeyForWeb + " Where HInterID=" + lngBillKey.ToString();
|
DataSet set = oCn.RunProcReturn("Select " + sShowItem + " from " + this.MvarItemKeyForWeb + " Where HInterID=" + lngBillKey.ToString(), this.MvarItemKeyForWeb);
|
if ((set == null) || (set.Tables[0].Rows.Count == 0))
|
{
|
sReturn = "单据头未找到！";
|
return null;
|
}
|
sReturn = "显示单据头成功！";
|
return set;
|
}
|
catch (Exception exception)
|
{
|
sReturn = exception.Message;
|
return null;
|
}
|
}
|
public DataSet ShowBillSub(long lngBillKey, string sShowItem, ref string sReturn)
|
{
|
string str = "";
|
try
|
{
|
str = "Select " + sShowItem + " from " + this.MvarItemKeySubForWeb + " Where HInterID=" + lngBillKey.ToString() + " order by HEntryID ";
|
DataSet set = oCn.RunProcReturn("Select " + sShowItem + " from " + this.MvarItemKeySubForWeb + " Where HInterID=" + lngBillKey.ToString() + " order by HEntryID ", this.MvarItemKeySubForWeb);
|
if ((set == null) || (set.Tables[0].Rows.Count == 0))
|
{
|
sReturn = "单据体未找到！";
|
return null;
|
}
|
sReturn = "显示单据体成功！";
|
return set;
|
}
|
catch (Exception exception)
|
{
|
sReturn = exception.Message + str;
|
return null;
|
}
|
}
|
public DataSet ShowBillSub1(long lngBillKey, long HEntryID, string sShowItem, ref string sReturn)
|
{
|
string str = "";
|
try
|
{
|
str = string.Concat(new object[] { "Select ", sShowItem, " from ", this.MvarItemKeySubForWeb, " Where HInterID=", lngBillKey.ToString(), " and HEntryID=", HEntryID, " order by HEntryID " });
|
DataSet set = oCn.RunProcReturn(string.Concat(new object[] { "Select ", sShowItem, " from ", this.MvarItemKeySubForWeb, " Where HInterID=", lngBillKey.ToString(), " and HEntryID=", HEntryID, " order by HEntryID " }), this.MvarItemKeySubForWeb);
|
if ((set == null) || (set.Tables[0].Rows.Count == 0))
|
{
|
sReturn = "单据体未找到！";
|
return null;
|
}
|
sReturn = "显示单据体成功！";
|
return set;
|
}
|
catch (Exception exception)
|
{
|
sReturn = exception.Message + str;
|
return null;
|
}
|
}
|
|
public DataSet ShowBillSub2(long lngBillKey, string sShowItem, ref string sReturn)
|
{
|
string str = "";
|
try
|
{
|
str = string.Concat(new object[] { "Select ", sShowItem, " from ", this.MvarItemKeySubForWeb2, " Where HInterID=", lngBillKey.ToString(), " order by HEntryID " });
|
DataSet set = oCn.RunProcReturn(string.Concat(new object[] { "Select ", sShowItem, " from ", this.MvarItemKeySubForWeb2, " Where HInterID=", lngBillKey.ToString(), " order by HEntryID " }), this.MvarItemKeySubForWeb4);
|
if ((set == null) || (set.Tables[0].Rows.Count == 0))
|
{
|
sReturn = "单据体未找到！";
|
return null;
|
}
|
sReturn = "显示单据体成功！";
|
return set;
|
}
|
catch (Exception exception)
|
{
|
sReturn = exception.Message + str;
|
return null;
|
}
|
}
|
public DataSet ShowBillSub3(long lngBillKey, long HEntryID, string sShowItem, ref string sReturn)
|
{
|
string str = "";
|
try
|
{
|
str = string.Concat(new object[] { "Select ", sShowItem, " from ", this.MvarItemKeySubForWeb2, " Where HInterID=", lngBillKey.ToString(), " and HEntryID=", HEntryID, " order by HEntryID " });
|
DataSet set = oCn.RunProcReturn(string.Concat(new object[] { "Select ", sShowItem, " from ", this.MvarItemKeySubForWeb2, " Where HInterID=", lngBillKey.ToString(), " and HEntryID=", HEntryID, " order by HEntryID " }), this.MvarItemKeySubForWeb2);
|
if ((set == null) || (set.Tables[0].Rows.Count == 0))
|
{
|
sReturn = "单据体未找到！";
|
return null;
|
}
|
sReturn = "显示单据体成功！";
|
return set;
|
}
|
catch (Exception exception)
|
{
|
sReturn = exception.Message + str;
|
return null;
|
}
|
}
|
public DataSet ShowBillSub4(long lngBillKey, string sShowItem, ref string sReturn)
|
{
|
string str = "";
|
try
|
{
|
str = string.Concat(new object[] { "Select ", sShowItem, " from ", this.MvarItemKeySubForWeb2, " Where HInterID=", lngBillKey.ToString(), " order by HEntryID " });
|
DataSet set = oCn.RunProcReturn(string.Concat(new object[] { "Select ", sShowItem, " from ", this.MvarItemKeySubForWeb2, " Where HInterID=", lngBillKey.ToString(), " order by HEntryID " }), this.MvarItemKeySubForWeb2);
|
if ((set == null) || (set.Tables[0].Rows.Count == 0))
|
{
|
sReturn = "单据体未找到！";
|
return null;
|
}
|
sReturn = "显示单据体成功！";
|
return set;
|
}
|
catch (Exception exception)
|
{
|
sReturn = exception.Message + str;
|
return null;
|
}
|
}
|
public DataSet ShowBillSub5(long lngBillKey, string sShowItem, ref string sReturn)
|
{
|
string str = "";
|
try
|
{
|
str = string.Concat(new object[] { "Select ", sShowItem, " from ", this.MvarItemKeySubForWeb3, " Where HInterID=", lngBillKey.ToString(), " order by HEntryID " });
|
DataSet set = oCn.RunProcReturn(string.Concat(new object[] { "Select ", sShowItem, " from ", this.MvarItemKeySubForWeb3, " Where HInterID=", lngBillKey.ToString(), " order by HEntryID " }), this.MvarItemKeySubForWeb3);
|
if ((set == null) || (set.Tables[0].Rows.Count == 0))
|
{
|
sReturn = "单据体未找到！";
|
return null;
|
}
|
sReturn = "显示单据体成功！";
|
return set;
|
}
|
catch (Exception exception)
|
{
|
sReturn = exception.Message + str;
|
return null;
|
}
|
}
|
public DataSet ShowBillSub6(long lngBillKey, string sShowItem, ref string sReturn)
|
{
|
string str = "";
|
try
|
{
|
str = string.Concat(new object[] { "Select ", sShowItem, " from ", this.MvarItemKeySubForWeb4, " Where HInterID=", lngBillKey.ToString(), " order by HEntryID " });
|
DataSet set = oCn.RunProcReturn(string.Concat(new object[] { "Select ", sShowItem, " from ", this.MvarItemKeySubForWeb4, " Where HInterID=", lngBillKey.ToString(), " order by HEntryID " }), this.MvarItemKeySubForWeb4);
|
if ((set == null) || (set.Tables[0].Rows.Count == 0))
|
{
|
sReturn = "单据体未找到！";
|
return null;
|
}
|
sReturn = "显示单据体成功！";
|
return set;
|
}
|
catch (Exception exception)
|
{
|
sReturn = exception.Message + str;
|
return null;
|
}
|
}
|
|
//生成条码
|
public bool SaveBarCode(Int64 HMaterID, Int64 HUnitID, Int64 HSupID, Int64 HQty, Int64 HMinQty, Int64 HSourceInterID, Int64 HSourceEntryID, string HSourceBillNo, string HSourceBillType, string HMTONO, Int64 HQty2)
|
{
|
oCn.RunProc("exec h_p_Web_BarCodeBill " + HMaterID + "," + HUnitID + "," + HSupID + "," + HQty + "," + HMinQty + "," + HSourceInterID + "," + HSourceEntryID + ",'" + HSourceBillNo + "','" + HSourceBillType + "','" + HMTONO+"'," + HQty2);
|
return true;
|
}
|
//检查是否已经生成条码
|
public bool CheckBarCode(Int64 HSourceInterID, Int64 HSourceEntryID)
|
{
|
|
DataSet Ds;
|
Ds = oCn.RunProcReturn("select * from Gy_BarCodeBill where HSourceInterID=" + HSourceInterID + " and HSourceEntryID=" + HSourceEntryID, "Gy_BarCodeBill");
|
if (Ds == null)
|
{
|
return false;
|
}
|
if (Ds.Tables[0].Rows.Count == 0)
|
{
|
return true;
|
}
|
else
|
{
|
return false;
|
}
|
}
|
|
}
|
}
|
