using System; using System.Collections.Generic; using System.Text; using System.Data; namespace DAL { public class ClsK3_icmo_View:DBUtility.ClsGy_Base_View { // public Model.ClsK3_icmo_Model omodel = new Model.ClsK3_icmo_Model(); SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); public ClsK3_icmo_View() { base.MvarReportTitle = "任务单设置"; base.MvarItemKey = "h_v_K3_icmo"; base.SQLName = "Select HItemID,HNumber 任务单号,hname from h_v_K3_icmo "; base.SQLWhere = " where HStopflag=0 "; base.SQLOrder = " Order by HNumber "; base.SQLList = "Select * from " + MvarItemKey + " "; //下拉SQL base.SQLNameForDown = " Select top 30 HItemID,HNumber 任务单号,HName 产品名称 from h_v_K3_icmo "; base.SQLOrderForDown = " Order by HNumber "; base.SQLWhereForDown = " where HStopflag=0 "; } // public void Dispose() { GC.SuppressFinalize(this); } // //返回项目信息 public override bool GetInfoByID(Int64 sItemID) { DataSet DS ; try { DS = oCn.RunProcReturn("Select * from " + MvarItemKey + " Where HItemID='" + sItemID + "'", MvarItemKey, ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) return false; else { return GetInfo(DS); } } catch (Exception e) { throw (e); } } //根据代码返回项目信息 public override bool GetInfoByNumber(string sNumber) { DataSet DS; try { DS = oCn.RunProcReturn("Select * from " + MvarItemKey + " Where HNumber='" + sNumber + "'", MvarItemKey, ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) return false; else { return GetInfo(DS); } } catch (Exception e) { throw (e); } } //返回项目信息 public override bool GetInfo(DataSet DS) { try { omodel = new Model.ClsK3_icmo_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.HWorkShopLev = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HWorkShopLev"]); //omodel.HProcID = Convert.ToInt64(DS.Tables[0].Rows[0]["HProcID"]); omodel.HStopflag =DBUtility.ClsPub.isBool(DS.Tables[0].Rows[0]["HStopflag"]); //omodel.HRemark = DS.Tables[0].Rows[0]["HRemark"].ToString().Trim(); return true; } catch (Exception e) { throw (e); } } } }