using System;
|
using System.Collections.Generic;
|
using System.Text;
|
using System.Data;
|
|
namespace DBUtility
|
{
|
public class ClsGy_Base_View:IDisposable
|
{
|
public string MvarReportTitle; //标题
|
public string MvarItemKey; //key 表名 视图名
|
public string WherePart; //查找
|
public string SQLName; //选择SQL
|
public string SQLOrder; //选择SQL
|
public string SQLWhere; //选择SQL
|
public string SQLNameForNew; //选择SQL
|
public string SQLOrderForNew; //选择SQL
|
public string SQLWhereForNew; //选择SQL
|
public string SQLNameByRelation; //选择SQL根据关联
|
public string ViewNameForWeb; //根据内码返回视图
|
public string SQLNameForDown; //选择SQL
|
public string SQLOrderForDown; //选择SQL
|
public string SQLWhereForDown; //选择SQL
|
//big
|
public string sBillView;
|
public string sBillShowItem;
|
public string sBillColName;
|
public string sBillColNumber;
|
public string sBillOrder;
|
//
|
public string SQLList;
|
//
|
Pub_Class.ClsSqlHelper oCN = new Pub_Class.ClsSqlHelper();
|
public ClsGy_Base_Model oModel = new ClsGy_Base_Model();
|
public List<ClsGy_Base_Model> oModelList = new List<ClsGy_Base_Model>();
|
|
public ClsGy_Base_View()
|
{
|
|
}
|
//
|
public void Dispose()
|
{
|
GC.SuppressFinalize(this);
|
}
|
//
|
|
|
|
//帮助
|
public virtual bool RefreshView(string sLike)
|
{
|
try
|
{//
|
Pub_Control.frmHlpInfo_View ofrm = new Pub_Control.frmHlpInfo_View();
|
//
|
string sSQL = SQLName + SQLWhere + sLike + SQLOrder;
|
//编辑ofrm
|
ofrm.sTitle = MvarReportTitle;
|
ofrm.sBill = MvarItemKey;
|
ofrm.txtFindInfo.Text = WherePart;
|
//
|
DataSet Ds;
|
Pub_Class.ClsSqlHelper oCn = new Pub_Class.ClsSqlHelper();
|
Ds = oCn.RunProcReturn(sSQL, MvarItemKey);
|
if (Ds == null || Ds.Tables[0].Rows.Count == 0)
|
{
|
return false;
|
}
|
//绑定
|
ofrm.grdShow.DataSource = Ds.Tables[0].DefaultView;
|
Ds.Dispose();
|
Ds = null;
|
ofrm.grdShow.SuspendLayout();
|
ofrm.grdShow.Columns[0].Visible = false;
|
ofrm.ShowDialog();
|
//得到对应列
|
int HItemIDCol = 0;
|
int HNumberCol = 1;
|
int HNameCol = 2;
|
//
|
if (ofrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK)
|
{
|
if (ofrm.grdShow.CurrentRow == null)
|
{
|
return false;
|
}
|
oModel = new ClsGy_Base_Model();
|
oModel.HItemID = Pub_Class.ClsPub.isLong(ofrm.grdShow.Rows[ofrm.grdShow.CurrentRow.Index].Cells[0].Value);
|
oModel.HNumber = Pub_Class.ClsPub.isStrNull(ofrm.grdShow.Rows[ofrm.grdShow.CurrentRow.Index].Cells[1].Value);
|
oModel.HName = Pub_Class.ClsPub.isStrNull(ofrm.grdShow.Rows[ofrm.grdShow.CurrentRow.Index].Cells[2].Value);
|
}
|
else
|
{
|
return false;
|
}
|
//
|
ofrm.Dispose();
|
ofrm = null;
|
//
|
return true;
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
|
|
/// <summary>
|
/// 基础资料帮助-关联物料型
|
/// </summary>
|
/// <param name="HMaterID"></param>
|
/// <returns></returns>
|
public virtual bool RefreshViewByRelation(long HMaterID)
|
{
|
try
|
{//
|
Pub_Control.frmHlpInfo_View ofrm = new Pub_Control.frmHlpInfo_View();
|
//
|
string sSQL = SQLNameByRelation + " where HMaterID=" + HMaterID.ToString() + " order by HItemID";
|
//编辑ofrm
|
ofrm.sTitle = MvarReportTitle;
|
ofrm.sBill = MvarItemKey;
|
ofrm.txtFindInfo.Text = WherePart;
|
//
|
DataSet Ds;
|
Pub_Class.ClsSqlHelper oCn = new Pub_Class.ClsSqlHelper();
|
Ds = oCn.RunProcReturn(sSQL, MvarItemKey);
|
if (Ds == null || Ds.Tables[0].Rows.Count == 0)
|
{
|
return false;
|
}
|
//绑定
|
ofrm.grdShow.DataSource = Ds.Tables[0].DefaultView;
|
Ds.Dispose();
|
Ds = null;
|
ofrm.grdShow.SuspendLayout();
|
ofrm.grdShow.Columns[0].Visible = false;
|
ofrm.ShowDialog();
|
//得到对应列
|
int HItemIDCol = 0;
|
int HNumberCol = 1;
|
int HNameCol = 2;
|
//
|
if (ofrm.grdShow.CurrentRow == null)
|
{
|
return false;
|
}
|
//
|
if (ofrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK)
|
{
|
if (ofrm.grdShow.CurrentRow == null)
|
{
|
return false;
|
}
|
oModel = new ClsGy_Base_Model();
|
oModel.HItemID = Pub_Class.ClsPub.isLong(ofrm.grdShow.Rows[ofrm.grdShow.CurrentRow.Index].Cells[0].Value);
|
oModel.HNumber = Pub_Class.ClsPub.isStrNull(ofrm.grdShow.Rows[ofrm.grdShow.CurrentRow.Index].Cells[1].Value);
|
oModel.HName = Pub_Class.ClsPub.isStrNull(ofrm.grdShow.Rows[ofrm.grdShow.CurrentRow.Index].Cells[2].Value);
|
}
|
else
|
{
|
return false;
|
}
|
//
|
ofrm.Dispose();
|
ofrm = null;
|
//
|
return true;
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
|
/// <summary>
|
/// 基础资料帮助-全部型
|
/// </summary>
|
/// <returns></returns>
|
public virtual bool RefreshView()
|
{
|
try
|
{//
|
Pub_Control.frmHlpInfo_View ofrm = new Pub_Control.frmHlpInfo_View();
|
//
|
string sSQL = SQLName + SQLWhere + SQLOrder;
|
//编辑ofrm
|
ofrm.sTitle = MvarReportTitle;
|
ofrm.sBill = MvarItemKey;
|
ofrm.txtFindInfo.Text = WherePart;
|
|
//
|
DataSet Ds;
|
Pub_Class.ClsSqlHelper oCn = new Pub_Class.ClsSqlHelper();
|
Ds = oCn.RunProcReturn(sSQL, MvarItemKey);
|
if (Ds == null || Ds.Tables[0].Rows.Count == 0)
|
{
|
return false;
|
}
|
|
//绑定
|
ofrm.grdShow.DataSource = Ds.Tables[0].DefaultView;
|
Ds.Dispose();
|
Ds = null;
|
ofrm.grdShow.SuspendLayout();
|
ofrm.grdShow.Columns[0].Visible = false;
|
ofrm.ShowDialog();
|
//得到对应列
|
int HItemIDCol = 0;
|
int HNumberCol = 1;
|
int HNameCol = 2;
|
//
|
if (ofrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK)
|
{
|
if (ofrm.grdShow.CurrentRow == null)
|
{
|
return false;
|
}
|
oModel = new ClsGy_Base_Model();
|
oModel.HItemID = Pub_Class.ClsPub.isLong(ofrm.grdShow.Rows[ofrm.grdShow.CurrentRow.Index].Cells[0].Value);
|
oModel.HNumber = Pub_Class.ClsPub.isStrNull(ofrm.grdShow.Rows[ofrm.grdShow.CurrentRow.Index].Cells[1].Value);
|
oModel.HName = Pub_Class.ClsPub.isStrNull(ofrm.grdShow.Rows[ofrm.grdShow.CurrentRow.Index].Cells[2].Value);
|
}
|
else
|
{
|
return false;
|
}
|
//
|
ofrm.Dispose();
|
ofrm = null;
|
//
|
return true;
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
|
|
/// <summary>
|
/// 基础资料帮助-过滤条件型
|
/// </summary>
|
/// <param name="sWhere"></param>
|
/// <returns></returns>
|
public virtual bool RefreshViewForNew(string sWhere )
|
{
|
try
|
{//
|
Pub_Control.frmHlpInfo_View ofrm = new Pub_Control.frmHlpInfo_View();
|
//
|
string sSQL = SQLNameForNew + SQLWhereForNew + sWhere + SQLOrderForNew;
|
//编辑ofrm
|
ofrm.sTitle = MvarReportTitle;
|
ofrm.sBill = MvarItemKey;
|
ofrm.txtFindInfo.Text = WherePart;
|
|
//
|
DataSet Ds;
|
Pub_Class.ClsSqlHelper oCn = new Pub_Class.ClsSqlHelper();
|
Ds = oCn.RunProcReturn(sSQL, MvarItemKey);
|
if (Ds == null || Ds.Tables[0].Rows.Count == 0)
|
{
|
return false;
|
}
|
|
//绑定
|
ofrm.grdShow.DataSource = Ds.Tables[0].DefaultView;
|
Ds.Dispose();
|
Ds = null;
|
ofrm.grdShow.SuspendLayout();
|
ofrm.grdShow.Columns[0].Visible = false;
|
ofrm.ShowDialog();
|
//得到对应列
|
int HItemIDCol = 0;
|
int HNumberCol = 1;
|
int HNameCol = 2;
|
//
|
if (ofrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK)
|
{
|
if (ofrm.grdShow.CurrentRow == null)
|
{
|
return false;
|
}
|
oModel = new ClsGy_Base_Model();
|
oModel.HItemID = Pub_Class.ClsPub.isLong(ofrm.grdShow.Rows[ofrm.grdShow.CurrentRow.Index].Cells[0].Value);
|
oModel.HNumber = Pub_Class.ClsPub.isStrNull(ofrm.grdShow.Rows[ofrm.grdShow.CurrentRow.Index].Cells[1].Value);
|
oModel.HName = Pub_Class.ClsPub.isStrNull(ofrm.grdShow.Rows[ofrm.grdShow.CurrentRow.Index].Cells[2].Value);
|
}
|
else
|
{
|
return false;
|
}
|
//
|
ofrm.Dispose();
|
ofrm = null;
|
//
|
return true;
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
|
|
/// <summary>
|
/// 基础资料帮助-返回多个项目型
|
/// </summary>
|
/// <returns></returns>
|
public virtual bool RefreshViewMul()
|
{
|
try
|
{//
|
Pub_Control.frmHlpInfo_View ofrm = new Pub_Control.frmHlpInfo_View();
|
//
|
string sSQL = SQLName + SQLWhere + SQLOrder;
|
//编辑ofrm
|
ofrm.sTitle = MvarReportTitle;
|
ofrm.sBill = MvarItemKey;
|
ofrm.txtFindInfo.Text = WherePart;
|
|
//
|
DataSet Ds;
|
Pub_Class.ClsSqlHelper oCn = new Pub_Class.ClsSqlHelper();
|
Ds = oCn.RunProcReturn(sSQL, MvarItemKey);
|
if (Ds == null || Ds.Tables[0].Rows.Count == 0)
|
{
|
return false;
|
}
|
|
//绑定
|
ofrm.grdShow.DataSource = Ds.Tables[0].DefaultView;
|
Ds.Dispose();
|
Ds = null;
|
ofrm.grdShow.SuspendLayout();
|
ofrm.grdShow.Columns[0].Visible = false;
|
ofrm.ShowDialog();
|
//得到对应列
|
int HItemIDCol = 0;
|
int HNumberCol = 1;
|
int HNameCol = 2;
|
//
|
oModelList.Clear();
|
if (ofrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK)
|
{
|
if (ofrm.grdShow.SelectedRows == null)
|
{
|
return false;
|
}
|
for (int i = 0; i < ofrm.grdShow.SelectedRows.Count; i++)
|
{
|
oModel = new ClsGy_Base_Model();
|
oModel.HItemID = Pub_Class.ClsPub.isLong(ofrm.grdShow.Rows[ofrm.grdShow.SelectedRows[i].Index].Cells[0].Value);
|
oModel.HNumber = Pub_Class.ClsPub.isStrNull(ofrm.grdShow.Rows[ofrm.grdShow.SelectedRows[i].Index].Cells[1].Value);
|
oModel.HName = Pub_Class.ClsPub.isStrNull(ofrm.grdShow.Rows[ofrm.grdShow.SelectedRows[i].Index].Cells[2].Value);
|
oModelList.Add(oModel);
|
}
|
}
|
else
|
{
|
return false;
|
}
|
//
|
ofrm.Dispose();
|
ofrm = null;
|
//
|
return true;
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
|
|
/// <summary>
|
/// 基础资料帮助-大数据型
|
/// </summary>
|
/// <returns></returns>
|
public virtual bool RefreshViewForBig(string sLike)
|
{
|
try
|
{//
|
Pub_Control.frmHlpInfoForBig ofrm = new Pub_Control.frmHlpInfoForBig();
|
//
|
//string sSQL = SQLName + SQLWhere + SQLOrder;
|
//编辑ofrm
|
ofrm.sTitle = MvarReportTitle;
|
ofrm.sBill = sBillView;
|
ofrm.txtFindInfo.Text = "";
|
ofrm.sOtherItem = sBillShowItem;
|
ofrm.sNameColName =sBillColName;
|
ofrm.sNumberColName = sBillColNumber;
|
ofrm.sOrderItem = sBillOrder;
|
ofrm.sLike = sLike;
|
|
//
|
DataSet Ds;
|
Pub_Class.ClsSqlHelper oCn = new Pub_Class.ClsSqlHelper();
|
//Ds = oCn.RunProcReturn(sSQL, MvarItemKey);
|
//if (Ds == null || Ds.Tables[0].Rows.Count == 0)
|
//{
|
// return false;
|
//}
|
|
//绑定
|
//ofrm.grdShow.DataSource = Ds.Tables[0].DefaultView;
|
//Ds.Dispose();
|
//Ds = null;
|
ofrm.grdShow.SuspendLayout();
|
//ofrm.grdShow.Columns[0].Visible = false;
|
ofrm.ShowDialog();
|
//得到对应列
|
int HItemIDCol = 0;
|
int HNumberCol = 1;
|
int HNameCol = 2;
|
//
|
if (ofrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK)
|
{
|
if (ofrm.grdShow.CurrentRow == null)
|
{
|
return false;
|
}
|
//for (int i = 0; i < ofrm.grdShow.SelectedRows.Count; i++)
|
//{
|
oModel = new ClsGy_Base_Model();
|
oModel.HItemID = Pub_Class.ClsPub.isLong(ofrm.grdShow.Rows[ofrm.grdShow.SelectedRows[0].Index].Cells[0].Value);
|
oModelList.Add(oModel);
|
//}
|
}
|
else
|
{
|
return false;
|
}
|
//
|
ofrm.Dispose();
|
ofrm = null;
|
//
|
return true;
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
|
|
/// <summary>
|
/// 基础资料帮助-下拉框型
|
/// </summary>
|
/// <param name="s"></param>
|
/// <param name="x"></param>
|
/// <param name="y"></param>
|
/// <returns></returns>
|
public virtual bool RefreshViewDownMenu(string s,int x,int y)
|
{
|
try
|
{//
|
Pub_Control.frmDownMenu ofrm = new Pub_Control.frmDownMenu();
|
//
|
string sSQL = SQLNameForDown + SQLWhereForDown + s + SQLOrderForDown;
|
//编辑ofrm
|
ofrm.x = x;
|
ofrm.y = y;
|
ofrm.sWhere = s;
|
ofrm.sTitle = this.MvarReportTitle;
|
|
//
|
DataSet Ds;
|
Pub_Class.ClsSqlHelper oCn = new Pub_Class.ClsSqlHelper();
|
Ds = oCn.RunProcReturn(sSQL, MvarItemKey);
|
if (Ds == null || Ds.Tables[0].Rows.Count == 0)
|
{
|
return false;
|
}
|
//绑定
|
ofrm.grdMain.DataSource = Ds.Tables[0].DefaultView;
|
Ds.Dispose();
|
Ds = null;
|
ofrm.grdMain.SuspendLayout();
|
ofrm.grdMain.Columns[0].Visible = false;
|
ofrm.ShowDialog();
|
//得到对应列
|
int HItemIDCol = 0;
|
int HNumberCol = 1;
|
int HNameCol = 2;
|
//
|
if (ofrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK)
|
{
|
if (ofrm.grdMain.CurrentRow == null)
|
{
|
return false;
|
}
|
oModel = new ClsGy_Base_Model();
|
oModel.HItemID = Pub_Class.ClsPub.isLong(ofrm.grdMain.Rows[ofrm.grdMain.CurrentRow.Index].Cells[HItemIDCol].Value);
|
oModel.HNumber = Pub_Class.ClsPub.isStrNull(ofrm.grdMain.Rows[ofrm.grdMain.CurrentRow.Index].Cells[HNumberCol].Value);
|
oModel.HName = Pub_Class.ClsPub.isStrNull(ofrm.grdMain.Rows[ofrm.grdMain.CurrentRow.Index].Cells[HNameCol].Value);
|
}
|
else
|
{
|
return false;
|
}
|
//
|
ofrm.Dispose();
|
ofrm = null;
|
//
|
return true;
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
|
/// <summary>
|
/// 根据内码返回Dataset
|
/// </summary>
|
/// <param name="sItemID"></param>
|
/// <returns></returns>
|
public virtual DataSet GetDSByID(Int64 sItemID)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCN.RunProcReturn("Select * from " + ViewNameForWeb + " Where HItemID='" + sItemID + "'", ViewNameForWeb, ref DBUtility.ClsPub.sExeReturnInfo);
|
if (DS.Tables[0].Rows.Count == 0)
|
{
|
return DS;
|
}
|
else
|
{
|
return DS;
|
}
|
}
|
catch (Exception e)
|
{
|
return null;
|
}
|
}
|
|
|
//返回项目信息
|
public virtual bool GetInfoByID(Int64 sItemID)
|
{
|
return true;
|
}
|
//根据代码返回项目信息
|
public virtual bool GetInfoByNumber(string sNumber)
|
{
|
return true;
|
}
|
//根据名称返回项目信息
|
public virtual bool GetInfoByName(string sName)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCN.RunProcReturn("Select * from " + MvarItemKey + " Where HName='" + sName + "'", MvarItemKey, ref DBUtility.ClsPub.sExeReturnInfo);
|
if (DS.Tables[0].Rows.Count == 0)
|
return false;
|
else
|
{
|
return GetInfo(DS);
|
}
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
//返回项目信息
|
public virtual bool GetInfo(DataSet DS)
|
{
|
return true;
|
}
|
|
/// <summary>
|
/// 根据sWhere 返回项目集合Dataset
|
/// </summary>
|
/// <param name="sWhere"></param>
|
/// <returns></returns>
|
public virtual DataSet GetList(string sWhere)
|
{
|
try
|
{
|
return oCN.RunProcReturn(SQLList + " " + sWhere + " Order by HNumber ", this.MvarItemKey, ref ClsPub.sExeReturnInfo);
|
}
|
catch (Exception e)
|
{
|
ClsPub.sExeReturnInfo += "返回列表失败！" + e.Message;
|
return null;
|
}
|
}
|
}
|
}
|
