using System; using System.Collections.Generic; using System.Text; using System.Data; using SQLHelper; namespace BLL { class ClsGy_OpenTmp_View:IDisposable { private string mvarReportTitle; public string MvarReportTitle { get { return mvarReportTitle; } set { mvarReportTitle = value; } } public string WherePart; public string ClsName; // ClsCN oCN = new ClsCN(); public ClsGy_OpenTmp_Model oModel; public ClsGy_OpenTmp_View() { mvarReportTitle = "打印模板设置"; ClsName = "打印模板"; } // public void Dispose() { GC.SuppressFinalize(this); } // //返回项目信息 public bool GetInfoByID(long sItemID) { DataSet DS ; try { DS = oCN.RunProcReturn("Select * from Gy_OpenTmp Where HItemID='" + sItemID + "'", "Gy_OpenTmp", ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) return false; else { oModel = new ClsGy_OpenTmp_Model(); oModel.HItemID = Convert.ToInt64(DS.Tables[0].Rows[0]["HItemID"]); oModel.HNumber = DS.Tables[0].Rows[0]["HNumber"].ToString().Trim(); oModel.HName = DS.Tables[0].Rows[0]["HName"].ToString().Trim(); oModel.HModel = DS.Tables[0].Rows[0]["HModel"].ToString().Trim(); return true; } } catch (Exception e) { return false; } } //根据代码返回项目信息 public bool GetInfoByNumber(string sNumber) { DataSet DS; try { DS = oCN.RunProcReturn("Select * from Gy_OpenTmp Where HNumber='" + sNumber + "'", "Gy_OpenTmp", ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) return false; else { oModel = new ClsGy_OpenTmp_Model(); oModel.HItemID = Convert.ToInt64(DS.Tables[0].Rows[0]["HItemID"]); oModel.HNumber = DS.Tables[0].Rows[0]["HNumber"].ToString().Trim(); oModel.HName = DS.Tables[0].Rows[0]["HName"].ToString().Trim(); oModel.HModel = DS.Tables[0].Rows[0]["HModel"].ToString().Trim(); return true; } } catch (Exception e) { return false; } } } }