/// <summary> /// 获取指定的SD_CTrans对象(即:一条记录 /// </summary> public SD_CTrans GetByKey(decimal sDT_ID) { SD_CTrans sD_CTrans = new SD_CTrans(); string sql = "SELECT SDT_ID,SDT_PCode,SDT_Code,SDT_DName,SDT_DCode,SDT_Owner,SDT_Distance,SDT_RoadCode,SDT_CheckValue,SDT_Unit,SDT_Bak,Stat,CreateDate,UpdateDate,DeleteDate,SDT_CarNo,SDT_StartTime,SDT_EndTime,SDT_Pop,SDT_Lng,SDT_Lat FROM SD_CTrans WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND SDT_ID=@SDT_ID "; idb.AddParameter("@SDT_ID", sDT_ID); SqlDataReader dr = null; try { dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { if (dr["SDT_ID"] != DBNull.Value) { sD_CTrans.SDT_ID = Convert.ToDecimal(dr["SDT_ID"]); } if (dr["SDT_PCode"] != DBNull.Value) { sD_CTrans.SDT_PCode = Convert.ToString(dr["SDT_PCode"]); } if (dr["SDT_Code"] != DBNull.Value) { sD_CTrans.SDT_Code = Convert.ToString(dr["SDT_Code"]); } if (dr["SDT_DName"] != DBNull.Value) { sD_CTrans.SDT_DName = Convert.ToString(dr["SDT_DName"]); } if (dr["SDT_DCode"] != DBNull.Value) { sD_CTrans.SDT_DCode = Convert.ToString(dr["SDT_DCode"]); } if (dr["SDT_Owner"] != DBNull.Value) { sD_CTrans.SDT_Owner = Convert.ToString(dr["SDT_Owner"]); } if (dr["SDT_Distance"] != DBNull.Value) { sD_CTrans.SDT_Distance = Convert.ToString(dr["SDT_Distance"]); } if (dr["SDT_RoadCode"] != DBNull.Value) { sD_CTrans.SDT_RoadCode = Convert.ToString(dr["SDT_RoadCode"]); } if (dr["SDT_CheckValue"] != DBNull.Value) { sD_CTrans.SDT_CheckValue = Convert.ToDecimal(dr["SDT_CheckValue"]); } if (dr["SDT_Unit"] != DBNull.Value) { sD_CTrans.SDT_Unit = Convert.ToString(dr["SDT_Unit"]); } if (dr["SDT_Bak"] != DBNull.Value) { sD_CTrans.SDT_Bak = Convert.ToString(dr["SDT_Bak"]); } if (dr["Stat"] != DBNull.Value) { sD_CTrans.Stat = Convert.ToInt32(dr["Stat"]); } if (dr["CreateDate"] != DBNull.Value) { sD_CTrans.CreateDate = Convert.ToDateTime(dr["CreateDate"]); } if (dr["UpdateDate"] != DBNull.Value) { sD_CTrans.UpdateDate = Convert.ToDateTime(dr["UpdateDate"]); } if (dr["DeleteDate"] != DBNull.Value) { sD_CTrans.DeleteDate = Convert.ToDateTime(dr["DeleteDate"]); } if (dr["SDT_CarNo"] != DBNull.Value) { sD_CTrans.SDT_CarNo = Convert.ToString(dr["SDT_CarNo"]); } if (dr["SDT_StartTime"] != DBNull.Value) { sD_CTrans.SDT_StartTime = Convert.ToDateTime(dr["SDT_StartTime"]); } if (dr["SDT_EndTime"] != DBNull.Value) { sD_CTrans.SDT_EndTime = Convert.ToDateTime(dr["SDT_EndTime"]); } if (dr["SDT_Pop"] != DBNull.Value) { sD_CTrans.SDT_Pop = Convert.ToDecimal(dr["SDT_Pop"]); } if (dr["SDT_Lng"] != DBNull.Value) { sD_CTrans.SDT_Lng = Convert.ToDecimal(dr["SDT_Lng"]); } if (dr["SDT_Lat"] != DBNull.Value) { sD_CTrans.SDT_Lat = Convert.ToDecimal(dr["SDT_Lat"]); } } }catch (System.Exception ex) { throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return(sD_CTrans); }
/// <summary> /// 获取指定的外联单位管理 Outreach_Info对象(即:一条记录 /// </summary> public Outreach_Info GetByKey(decimal oI_ID) { Outreach_Info outreach_Info = new Outreach_Info(); string sql = "SELECT OI_ID,OI_Code,OI_Name,OI_Address,OI_Telephone,OI_CompanyType,OI_iType,OI_MainContactor,OI_ContactPhone,OI_Contactor,Ol_Attachment,OI_Remark,OI_Company,OI_Dept,Stat,CreateDate,UpdateDate,DeleteDate FROM Outreach_Info WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND OI_ID=@OI_ID "; idb.AddParameter("@OI_ID", oI_ID); SqlDataReader dr = null; try { dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { if (dr["OI_ID"] != DBNull.Value) { outreach_Info.OI_ID = Convert.ToDecimal(dr["OI_ID"]); } if (dr["OI_Code"] != DBNull.Value) { outreach_Info.OI_Code = Convert.ToString(dr["OI_Code"]); } if (dr["OI_Name"] != DBNull.Value) { outreach_Info.OI_Name = Convert.ToString(dr["OI_Name"]); } if (dr["OI_Address"] != DBNull.Value) { outreach_Info.OI_Address = Convert.ToString(dr["OI_Address"]); } if (dr["OI_Telephone"] != DBNull.Value) { outreach_Info.OI_Telephone = Convert.ToString(dr["OI_Telephone"]); } if (dr["OI_CompanyType"] != DBNull.Value) { outreach_Info.OI_CompanyType = Convert.ToString(dr["OI_CompanyType"]); } if (dr["OI_iType"] != DBNull.Value) { outreach_Info.OI_iType = Convert.ToString(dr["OI_iType"]); } if (dr["OI_MainContactor"] != DBNull.Value) { outreach_Info.OI_MainContactor = Convert.ToString(dr["OI_MainContactor"]); } if (dr["OI_ContactPhone"] != DBNull.Value) { outreach_Info.OI_ContactPhone = Convert.ToString(dr["OI_ContactPhone"]); } if (dr["OI_Contactor"] != DBNull.Value) { outreach_Info.OI_Contactor = Convert.ToString(dr["OI_Contactor"]); } if (dr["Ol_Attachment"] != DBNull.Value) { outreach_Info.Ol_Attachment = Convert.ToString(dr["Ol_Attachment"]); } if (dr["OI_Remark"] != DBNull.Value) { outreach_Info.OI_Remark = Convert.ToString(dr["OI_Remark"]); } if (dr["OI_Company"] != DBNull.Value) { outreach_Info.OI_Company = Convert.ToString(dr["OI_Company"]); } if (dr["OI_Dept"] != DBNull.Value) { outreach_Info.OI_Dept = Convert.ToString(dr["OI_Dept"]); } if (dr["Stat"] != DBNull.Value) { outreach_Info.Stat = Convert.ToInt32(dr["Stat"]); } if (dr["CreateDate"] != DBNull.Value) { outreach_Info.CreateDate = Convert.ToDateTime(dr["CreateDate"]); } if (dr["UpdateDate"] != DBNull.Value) { outreach_Info.UpdateDate = Convert.ToDateTime(dr["UpdateDate"]); } if (dr["DeleteDate"] != DBNull.Value) { outreach_Info.DeleteDate = Convert.ToDateTime(dr["DeleteDate"]); } } }catch (System.Exception ex) { throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return(outreach_Info); }
/// <summary> /// 获取指定的公司物料类别 WH_MaterialType对象(即:一条记录 /// </summary> public WH_MaterialType GetByKey(decimal mT_ID) { WH_MaterialType wH_MaterialType = new WH_MaterialType(); string sql = "SELECT MT_ID,MT_Code,MT_TCode,MT_TName,MT_Company,MT_CompanyCode,MT_Dept,MT_DeptCode,Stat,MT_Status,CreateDate,UpdateDate,DeleteDate,MT_Itype,MT_Type,MT_Employee,MT_EmployeeName,MT_TPCode,MT_Order FROM WH_MaterialType WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND MT_ID=@MT_ID "; idb.AddParameter("@MT_ID", mT_ID); SqlDataReader dr = null; try { dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { if (dr["MT_ID"] != DBNull.Value) { wH_MaterialType.MT_ID = Convert.ToDecimal(dr["MT_ID"]); } if (dr["MT_Code"] != DBNull.Value) { wH_MaterialType.MT_Code = Convert.ToString(dr["MT_Code"]); } if (dr["MT_TCode"] != DBNull.Value) { wH_MaterialType.MT_TCode = Convert.ToString(dr["MT_TCode"]); } if (dr["MT_TName"] != DBNull.Value) { wH_MaterialType.MT_TName = Convert.ToString(dr["MT_TName"]); } if (dr["MT_Company"] != DBNull.Value) { wH_MaterialType.MT_Company = Convert.ToString(dr["MT_Company"]); } if (dr["MT_CompanyCode"] != DBNull.Value) { wH_MaterialType.MT_CompanyCode = Convert.ToString(dr["MT_CompanyCode"]); } if (dr["MT_Dept"] != DBNull.Value) { wH_MaterialType.MT_Dept = Convert.ToString(dr["MT_Dept"]); } if (dr["MT_DeptCode"] != DBNull.Value) { wH_MaterialType.MT_DeptCode = Convert.ToString(dr["MT_DeptCode"]); } if (dr["Stat"] != DBNull.Value) { wH_MaterialType.Stat = Convert.ToInt32(dr["Stat"]); } if (dr["MT_Status"] != DBNull.Value) { wH_MaterialType.MT_Status = Convert.ToString(dr["MT_Status"]); } if (dr["CreateDate"] != DBNull.Value) { wH_MaterialType.CreateDate = Convert.ToDateTime(dr["CreateDate"]); } if (dr["UpdateDate"] != DBNull.Value) { wH_MaterialType.UpdateDate = Convert.ToDateTime(dr["UpdateDate"]); } if (dr["DeleteDate"] != DBNull.Value) { wH_MaterialType.DeleteDate = Convert.ToDateTime(dr["DeleteDate"]); } if (dr["MT_Itype"] != DBNull.Value) { wH_MaterialType.MT_Itype = Convert.ToString(dr["MT_Itype"]); } if (dr["MT_Type"] != DBNull.Value) { wH_MaterialType.MT_Type = Convert.ToString(dr["MT_Type"]); } if (dr["MT_Employee"] != DBNull.Value) { wH_MaterialType.MT_Employee = Convert.ToString(dr["MT_Employee"]); } if (dr["MT_EmployeeName"] != DBNull.Value) { wH_MaterialType.MT_EmployeeName = Convert.ToString(dr["MT_EmployeeName"]); } if (dr["MT_TPCode"] != DBNull.Value) { wH_MaterialType.MT_TPCode = Convert.ToString(dr["MT_TPCode"]); } if (dr["MT_Order"] != DBNull.Value) { wH_MaterialType.MT_Order = Convert.ToInt32(dr["MT_Order"]); } } }catch (System.Exception ex) { throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return(wH_MaterialType); }
/// <summary> /// 获取指定的审核模板配置表 Verify_TemplateConfig对象(即:一条记录 /// </summary> public Verify_TemplateConfig GetByKey(decimal vT_ID) { Verify_TemplateConfig verify_TemplateConfig = new Verify_TemplateConfig(); string sql = "SELECT VT_ID,VT_Template_Code,VT_Key,VT_VerifyNode_Code,VT_VerifyNode_Name,Flag,VT_VerifyNode_Order,VT_VerifyNode_Back,VT_VerifyNode_BackName,VT_Remark,Stat,VT_AcSum,VT_AcNodeName,VT_AcNodeCode FROM Verify_TemplateConfig WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND VT_ID=@VT_ID "; idb.AddParameter("@VT_ID", vT_ID); SqlDataReader dr = null; try { dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { if (dr["VT_ID"] != DBNull.Value) { verify_TemplateConfig.VT_ID = Convert.ToDecimal(dr["VT_ID"]); } if (dr["VT_Template_Code"] != DBNull.Value) { verify_TemplateConfig.VT_Template_Code = Convert.ToString(dr["VT_Template_Code"]); } if (dr["VT_Key"] != DBNull.Value) { verify_TemplateConfig.VT_Key = Convert.ToString(dr["VT_Key"]); } if (dr["VT_VerifyNode_Code"] != DBNull.Value) { verify_TemplateConfig.VT_VerifyNode_Code = Convert.ToString(dr["VT_VerifyNode_Code"]); } if (dr["VT_VerifyNode_Name"] != DBNull.Value) { verify_TemplateConfig.VT_VerifyNode_Name = Convert.ToString(dr["VT_VerifyNode_Name"]); } if (dr["Flag"] != DBNull.Value) { verify_TemplateConfig.Flag = Convert.ToInt32(dr["Flag"]); } if (dr["VT_VerifyNode_Order"] != DBNull.Value) { verify_TemplateConfig.VT_VerifyNode_Order = Convert.ToInt32(dr["VT_VerifyNode_Order"]); } if (dr["VT_VerifyNode_Back"] != DBNull.Value) { verify_TemplateConfig.VT_VerifyNode_Back = Convert.ToString(dr["VT_VerifyNode_Back"]); } if (dr["VT_VerifyNode_BackName"] != DBNull.Value) { verify_TemplateConfig.VT_VerifyNode_BackName = Convert.ToString(dr["VT_VerifyNode_BackName"]); } if (dr["VT_Remark"] != DBNull.Value) { verify_TemplateConfig.VT_Remark = Convert.ToString(dr["VT_Remark"]); } if (dr["Stat"] != DBNull.Value) { verify_TemplateConfig.Stat = Convert.ToInt32(dr["Stat"]); } if (dr["VT_AcSum"] != DBNull.Value) { verify_TemplateConfig.VT_AcSum = Convert.ToDecimal(dr["VT_AcSum"]); } if (dr["VT_AcNodeName"] != DBNull.Value) { verify_TemplateConfig.VT_AcNodeName = Convert.ToString(dr["VT_AcNodeName"]); } if (dr["VT_AcNodeCode"] != DBNull.Value) { verify_TemplateConfig.VT_AcNodeCode = Convert.ToString(dr["VT_AcNodeCode"]); } } }catch (System.Exception ex) { throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return(verify_TemplateConfig); }
/// <summary> /// 获取指定的PC_WError对象(即:一条记录 /// </summary> public PC_WError GetByKey(decimal pCWE_ID) { PC_WError pC_WError = new PC_WError(); string sql = "SELECT PCWE_ID,PCWE_Code,PCWE_Module,PCWE_WHCode,PCWE_WHName,PCWE_MCode,PCWE_MName,PCWE_Unit,PCWE_Num,PCWE_Operator,PCWE_OpDate,PCWE_Bak,Stat,CreateDate,UpdateDate,DeleteDate FROM PC_WError WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND PCWE_ID=@PCWE_ID "; idb.AddParameter("@PCWE_ID", pCWE_ID); SqlDataReader dr = null; try { dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { if (dr["PCWE_ID"] != DBNull.Value) { pC_WError.PCWE_ID = Convert.ToDecimal(dr["PCWE_ID"]); } if (dr["PCWE_Code"] != DBNull.Value) { pC_WError.PCWE_Code = Convert.ToString(dr["PCWE_Code"]); } if (dr["PCWE_Module"] != DBNull.Value) { pC_WError.PCWE_Module = Convert.ToString(dr["PCWE_Module"]); } if (dr["PCWE_WHCode"] != DBNull.Value) { pC_WError.PCWE_WHCode = Convert.ToString(dr["PCWE_WHCode"]); } if (dr["PCWE_WHName"] != DBNull.Value) { pC_WError.PCWE_WHName = Convert.ToString(dr["PCWE_WHName"]); } if (dr["PCWE_MCode"] != DBNull.Value) { pC_WError.PCWE_MCode = Convert.ToString(dr["PCWE_MCode"]); } if (dr["PCWE_MName"] != DBNull.Value) { pC_WError.PCWE_MName = Convert.ToString(dr["PCWE_MName"]); } if (dr["PCWE_Unit"] != DBNull.Value) { pC_WError.PCWE_Unit = Convert.ToString(dr["PCWE_Unit"]); } if (dr["PCWE_Num"] != DBNull.Value) { pC_WError.PCWE_Num = Convert.ToDecimal(dr["PCWE_Num"]); } if (dr["PCWE_Operator"] != DBNull.Value) { pC_WError.PCWE_Operator = Convert.ToString(dr["PCWE_Operator"]); } if (dr["PCWE_OpDate"] != DBNull.Value) { pC_WError.PCWE_OpDate = Convert.ToDateTime(dr["PCWE_OpDate"]); } if (dr["PCWE_Bak"] != DBNull.Value) { pC_WError.PCWE_Bak = Convert.ToString(dr["PCWE_Bak"]); } if (dr["Stat"] != DBNull.Value) { pC_WError.Stat = Convert.ToInt32(dr["Stat"]); } if (dr["CreateDate"] != DBNull.Value) { pC_WError.CreateDate = Convert.ToDateTime(dr["CreateDate"]); } if (dr["UpdateDate"] != DBNull.Value) { pC_WError.UpdateDate = Convert.ToDateTime(dr["UpdateDate"]); } if (dr["DeleteDate"] != DBNull.Value) { pC_WError.DeleteDate = Convert.ToDateTime(dr["DeleteDate"]); } } }catch (System.Exception ex) { throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return(pC_WError); }
/// <summary> /// 获取指定的Assets_Apply对象(即:一条记录 /// </summary> public Assets_Apply GetByKey(decimal assetsApply_ID) { Assets_Apply assets_Apply = new Assets_Apply(); string sql = "SELECT AssetsApply_ID,AssetsApply_Code,AssetsApply_AppPerson,AssetsApply_AppDept,AssetsApply_AppName,AssetsApply_Parameter,AssetsApply_Description,AssetsApply_AppCount,AssetsApply_Type,AssetsApply_AppType,AssetsApply_Date,AssetsApply_AudistStat,AssetsApply_Stat,AssetsApply_Remark,Stat FROM Assets_Apply WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND AssetsApply_ID=@AssetsApply_ID "; idb.AddParameter("@AssetsApply_ID", assetsApply_ID); SqlDataReader dr = null; try { dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { if (dr["AssetsApply_ID"] != DBNull.Value) { assets_Apply.AssetsApply_ID = Convert.ToDecimal(dr["AssetsApply_ID"]); } if (dr["AssetsApply_Code"] != DBNull.Value) { assets_Apply.AssetsApply_Code = Convert.ToString(dr["AssetsApply_Code"]); } if (dr["AssetsApply_AppPerson"] != DBNull.Value) { assets_Apply.AssetsApply_AppPerson = Convert.ToString(dr["AssetsApply_AppPerson"]); } if (dr["AssetsApply_AppDept"] != DBNull.Value) { assets_Apply.AssetsApply_AppDept = Convert.ToString(dr["AssetsApply_AppDept"]); } if (dr["AssetsApply_AppName"] != DBNull.Value) { assets_Apply.AssetsApply_AppName = Convert.ToString(dr["AssetsApply_AppName"]); } if (dr["AssetsApply_Parameter"] != DBNull.Value) { assets_Apply.AssetsApply_Parameter = Convert.ToString(dr["AssetsApply_Parameter"]); } if (dr["AssetsApply_Description"] != DBNull.Value) { assets_Apply.AssetsApply_Description = Convert.ToString(dr["AssetsApply_Description"]); } if (dr["AssetsApply_AppCount"] != DBNull.Value) { assets_Apply.AssetsApply_AppCount = Convert.ToInt32(dr["AssetsApply_AppCount"]); } if (dr["AssetsApply_Type"] != DBNull.Value) { assets_Apply.AssetsApply_Type = Convert.ToString(dr["AssetsApply_Type"]); } if (dr["AssetsApply_AppType"] != DBNull.Value) { assets_Apply.AssetsApply_AppType = Convert.ToString(dr["AssetsApply_AppType"]); } if (dr["AssetsApply_Date"] != DBNull.Value) { assets_Apply.AssetsApply_Date = Convert.ToDateTime(dr["AssetsApply_Date"]); } if (dr["AssetsApply_AudistStat"] != DBNull.Value) { assets_Apply.AssetsApply_AudistStat = Convert.ToString(dr["AssetsApply_AudistStat"]); } if (dr["AssetsApply_Stat"] != DBNull.Value) { assets_Apply.AssetsApply_Stat = Convert.ToString(dr["AssetsApply_Stat"]); } if (dr["AssetsApply_Remark"] != DBNull.Value) { assets_Apply.AssetsApply_Remark = Convert.ToString(dr["AssetsApply_Remark"]); } if (dr["Stat"] != DBNull.Value) { assets_Apply.Stat = Convert.ToInt32(dr["Stat"]); } } }catch (System.Exception ex) { throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return(assets_Apply); }
/// <summary> /// 获取指定的车辆事件表 PCT_Event对象(即:一条记录 /// </summary> public PCT_Event GetByKey(decimal pCTE_ID) { PCT_Event pCT_Event = new PCT_Event(); string sql = "SELECT PCTE_ID,PCTE_Code,PCTE_CCode,PCTE_CNo,PCTE_Description,PCTE_BeginDate,PCTE_EndDate,PCTE_EventType,PCTE_DCode,PCTE_Join,PCTE_Cost,PCTE_Before,PCTE_After,PCTE_Address,Stat,CreateDate,UpdateDate,DeleteDate,PCTE_iType,PCTE_TCode,PCTE_Udef2,PCTE_Udef3,PCTE_Udef4,PCTE_Udef5 FROM PCT_Event WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND PCTE_ID=@PCTE_ID "; idb.AddParameter("@PCTE_ID", pCTE_ID); SqlDataReader dr = null; try { dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { if (dr["PCTE_ID"] != DBNull.Value) { pCT_Event.PCTE_ID = Convert.ToDecimal(dr["PCTE_ID"]); } if (dr["PCTE_Code"] != DBNull.Value) { pCT_Event.PCTE_Code = Convert.ToString(dr["PCTE_Code"]); } if (dr["PCTE_CCode"] != DBNull.Value) { pCT_Event.PCTE_CCode = Convert.ToString(dr["PCTE_CCode"]); } if (dr["PCTE_CNo"] != DBNull.Value) { pCT_Event.PCTE_CNo = Convert.ToString(dr["PCTE_CNo"]); } if (dr["PCTE_Description"] != DBNull.Value) { pCT_Event.PCTE_Description = Convert.ToString(dr["PCTE_Description"]); } if (dr["PCTE_BeginDate"] != DBNull.Value) { pCT_Event.PCTE_BeginDate = Convert.ToDateTime(dr["PCTE_BeginDate"]); } if (dr["PCTE_EndDate"] != DBNull.Value) { pCT_Event.PCTE_EndDate = Convert.ToDateTime(dr["PCTE_EndDate"]); } if (dr["PCTE_EventType"] != DBNull.Value) { pCT_Event.PCTE_EventType = Convert.ToString(dr["PCTE_EventType"]); } if (dr["PCTE_DCode"] != DBNull.Value) { pCT_Event.PCTE_DCode = Convert.ToString(dr["PCTE_DCode"]); } if (dr["PCTE_Join"] != DBNull.Value) { pCT_Event.PCTE_Join = Convert.ToString(dr["PCTE_Join"]); } if (dr["PCTE_Cost"] != DBNull.Value) { pCT_Event.PCTE_Cost = Convert.ToDecimal(dr["PCTE_Cost"]); } if (dr["PCTE_Before"] != DBNull.Value) { pCT_Event.PCTE_Before = Convert.ToSingle(dr["PCTE_Before"]); } if (dr["PCTE_After"] != DBNull.Value) { pCT_Event.PCTE_After = Convert.ToSingle(dr["PCTE_After"]); } if (dr["PCTE_Address"] != DBNull.Value) { pCT_Event.PCTE_Address = Convert.ToString(dr["PCTE_Address"]); } if (dr["Stat"] != DBNull.Value) { pCT_Event.Stat = Convert.ToInt32(dr["Stat"]); } if (dr["CreateDate"] != DBNull.Value) { pCT_Event.CreateDate = Convert.ToDateTime(dr["CreateDate"]); } if (dr["UpdateDate"] != DBNull.Value) { pCT_Event.UpdateDate = Convert.ToDateTime(dr["UpdateDate"]); } if (dr["DeleteDate"] != DBNull.Value) { pCT_Event.DeleteDate = Convert.ToDateTime(dr["DeleteDate"]); } if (dr["PCTE_iType"] != DBNull.Value) { pCT_Event.PCTE_iType = Convert.ToString(dr["PCTE_iType"]); } if (dr["PCTE_TCode"] != DBNull.Value) { pCT_Event.PCTE_TCode = Convert.ToString(dr["PCTE_TCode"]); } if (dr["PCTE_Udef2"] != DBNull.Value) { pCT_Event.PCTE_Udef2 = Convert.ToString(dr["PCTE_Udef2"]); } if (dr["PCTE_Udef3"] != DBNull.Value) { pCT_Event.PCTE_Udef3 = Convert.ToString(dr["PCTE_Udef3"]); } if (dr["PCTE_Udef4"] != DBNull.Value) { pCT_Event.PCTE_Udef4 = Convert.ToString(dr["PCTE_Udef4"]); } if (dr["PCTE_Udef5"] != DBNull.Value) { pCT_Event.PCTE_Udef5 = Convert.ToString(dr["PCTE_Udef5"]); } } }catch (System.Exception ex) { throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return(pCT_Event); }
/// <summary> /// 获取指定的计量信息 Measure_Details对象(即:一条记录 /// </summary> public Measure_Details GetByKey(decimal measure_ID) { Measure_Details measure_Details = new Measure_Details(); string sql = "SELECT Measure_ID,Measure_Code,Measure_LoadometerCode,Measure_ItemName,Measure_Item,Measure_Result,Measure_Remark,Stat,CreateDate,UpdateDate,DeleteDate FROM Measure_Details WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND Measure_ID=@Measure_ID "; idb.AddParameter("@Measure_ID", measure_ID); SqlDataReader dr = null; try { dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { if (dr["Measure_ID"] != DBNull.Value) { measure_Details.Measure_ID = Convert.ToDecimal(dr["Measure_ID"]); } if (dr["Measure_Code"] != DBNull.Value) { measure_Details.Measure_Code = Convert.ToString(dr["Measure_Code"]); } if (dr["Measure_LoadometerCode"] != DBNull.Value) { measure_Details.Measure_LoadometerCode = Convert.ToString(dr["Measure_LoadometerCode"]); } if (dr["Measure_ItemName"] != DBNull.Value) { measure_Details.Measure_ItemName = Convert.ToString(dr["Measure_ItemName"]); } if (dr["Measure_Item"] != DBNull.Value) { measure_Details.Measure_Item = Convert.ToString(dr["Measure_Item"]); } if (dr["Measure_Result"] != DBNull.Value) { measure_Details.Measure_Result = Convert.ToSingle(dr["Measure_Result"]); } if (dr["Measure_Remark"] != DBNull.Value) { measure_Details.Measure_Remark = Convert.ToString(dr["Measure_Remark"]); } if (dr["Stat"] != DBNull.Value) { measure_Details.Stat = Convert.ToInt32(dr["Stat"]); } if (dr["CreateDate"] != DBNull.Value) { measure_Details.CreateDate = Convert.ToDateTime(dr["CreateDate"]); } if (dr["UpdateDate"] != DBNull.Value) { measure_Details.UpdateDate = Convert.ToDateTime(dr["UpdateDate"]); } if (dr["DeleteDate"] != DBNull.Value) { measure_Details.DeleteDate = Convert.ToDateTime(dr["DeleteDate"]); } } }catch (System.Exception ex) { throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return(measure_Details); }
/// <summary> /// 获取指定的Sys_Map对象(即:一条记录 /// </summary> public Sys_Map GetByKey(decimal map_ID) { Sys_Map sys_Map = new Sys_Map(); string sql = "SELECT Map_ID,Map_Module,Map_Source,Map_Object,Map_Object1,Map_Object2,Map_Type,Map_UDEF1,Map_UDEF2,Map_UDEF3,Map_UDEF4,Map_UDEF5,Stat FROM Sys_Map WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND Map_ID=@Map_ID "; idb.AddParameter("@Map_ID", map_ID); SqlDataReader dr = null; try { dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { if (dr["Map_ID"] != DBNull.Value) { sys_Map.Map_ID = Convert.ToDecimal(dr["Map_ID"]); } if (dr["Map_Module"] != DBNull.Value) { sys_Map.Map_Module = Convert.ToString(dr["Map_Module"]); } if (dr["Map_Source"] != DBNull.Value) { sys_Map.Map_Source = Convert.ToString(dr["Map_Source"]); } if (dr["Map_Object"] != DBNull.Value) { sys_Map.Map_Object = Convert.ToString(dr["Map_Object"]); } if (dr["Map_Object1"] != DBNull.Value) { sys_Map.Map_Object1 = Convert.ToString(dr["Map_Object1"]); } if (dr["Map_Object2"] != DBNull.Value) { sys_Map.Map_Object2 = Convert.ToString(dr["Map_Object2"]); } if (dr["Map_Type"] != DBNull.Value) { sys_Map.Map_Type = Convert.ToString(dr["Map_Type"]); } if (dr["Map_UDEF1"] != DBNull.Value) { sys_Map.Map_UDEF1 = Convert.ToString(dr["Map_UDEF1"]); } if (dr["Map_UDEF2"] != DBNull.Value) { sys_Map.Map_UDEF2 = Convert.ToString(dr["Map_UDEF2"]); } if (dr["Map_UDEF3"] != DBNull.Value) { sys_Map.Map_UDEF3 = Convert.ToString(dr["Map_UDEF3"]); } if (dr["Map_UDEF4"] != DBNull.Value) { sys_Map.Map_UDEF4 = Convert.ToString(dr["Map_UDEF4"]); } if (dr["Map_UDEF5"] != DBNull.Value) { sys_Map.Map_UDEF5 = Convert.ToString(dr["Map_UDEF5"]); } if (dr["Stat"] != DBNull.Value) { sys_Map.Stat = Convert.ToInt32(dr["Stat"]); } } }catch (System.Exception ex) { throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return(sys_Map); }
/// <summary> /// 获取指定的TC_SJComp对象(即:一条记录 /// </summary> public TC_SJComp GetByKey(decimal tCJ_ID) { TC_SJComp tC_SJComp = new TC_SJComp(); string sql = "SELECT TCJ_ID,TCJ_Code,TCJ_Name,TCJ_PLine,TCJ_Stat,Stat,CreateDate,UpdateDate,DeleteDate,TCJ_Udef1,TCJ_Udef2,TCJ_Udef3,TCJ_Udef4,TCJ_Udef5 FROM TC_SJComp WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND TCJ_ID=@TCJ_ID "; idb.AddParameter("@TCJ_ID", tCJ_ID); SqlDataReader dr = null; try { dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { if (dr["TCJ_ID"] != DBNull.Value) { tC_SJComp.TCJ_ID = Convert.ToDecimal(dr["TCJ_ID"]); } if (dr["TCJ_Code"] != DBNull.Value) { tC_SJComp.TCJ_Code = Convert.ToString(dr["TCJ_Code"]); } if (dr["TCJ_Name"] != DBNull.Value) { tC_SJComp.TCJ_Name = Convert.ToString(dr["TCJ_Name"]); } if (dr["TCJ_PLine"] != DBNull.Value) { tC_SJComp.TCJ_PLine = Convert.ToString(dr["TCJ_PLine"]); } if (dr["TCJ_Stat"] != DBNull.Value) { tC_SJComp.TCJ_Stat = Convert.ToString(dr["TCJ_Stat"]); } if (dr["Stat"] != DBNull.Value) { tC_SJComp.Stat = Convert.ToInt32(dr["Stat"]); } if (dr["CreateDate"] != DBNull.Value) { tC_SJComp.CreateDate = Convert.ToDateTime(dr["CreateDate"]); } if (dr["UpdateDate"] != DBNull.Value) { tC_SJComp.UpdateDate = Convert.ToDateTime(dr["UpdateDate"]); } if (dr["DeleteDate"] != DBNull.Value) { tC_SJComp.DeleteDate = Convert.ToDateTime(dr["DeleteDate"]); } if (dr["TCJ_Udef1"] != DBNull.Value) { tC_SJComp.TCJ_Udef1 = Convert.ToString(dr["TCJ_Udef1"]); } if (dr["TCJ_Udef2"] != DBNull.Value) { tC_SJComp.TCJ_Udef2 = Convert.ToString(dr["TCJ_Udef2"]); } if (dr["TCJ_Udef3"] != DBNull.Value) { tC_SJComp.TCJ_Udef3 = Convert.ToString(dr["TCJ_Udef3"]); } if (dr["TCJ_Udef4"] != DBNull.Value) { tC_SJComp.TCJ_Udef4 = Convert.ToString(dr["TCJ_Udef4"]); } if (dr["TCJ_Udef5"] != DBNull.Value) { tC_SJComp.TCJ_Udef5 = Convert.ToString(dr["TCJ_Udef5"]); } } }catch (System.Exception ex) { throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return(tC_SJComp); }
/// <summary> /// 获取指定的设备检修记录 Equ_MRecords对象(即:一条记录 /// </summary> public Equ_MRecords GetByKey(decimal mR_ID) { Equ_MRecords equ_MRecords = new Equ_MRecords(); string sql = "SELECT MR_ID,MR_ECode,MR_EName,MR_Start,MR_End,MR_FType,MR_Content,MR_MStuff,VerifyStuff,VerifyDate,MR_Bak,Creator,CreateTime,Stat,MR_MPCode,MR_Type FROM Equ_MRecords WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND MR_ID=@MR_ID "; idb.AddParameter("@MR_ID", mR_ID); SqlDataReader dr = null; try { dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { if (dr["MR_ID"] != DBNull.Value) { equ_MRecords.MR_ID = Convert.ToDecimal(dr["MR_ID"]); } if (dr["MR_ECode"] != DBNull.Value) { equ_MRecords.MR_ECode = Convert.ToString(dr["MR_ECode"]); } if (dr["MR_EName"] != DBNull.Value) { equ_MRecords.MR_EName = Convert.ToString(dr["MR_EName"]); } if (dr["MR_Start"] != DBNull.Value) { equ_MRecords.MR_Start = Convert.ToDateTime(dr["MR_Start"]); } if (dr["MR_End"] != DBNull.Value) { equ_MRecords.MR_End = Convert.ToDateTime(dr["MR_End"]); } if (dr["MR_FType"] != DBNull.Value) { equ_MRecords.MR_FType = Convert.ToString(dr["MR_FType"]); } if (dr["MR_Content"] != DBNull.Value) { equ_MRecords.MR_Content = Convert.ToString(dr["MR_Content"]); } if (dr["MR_MStuff"] != DBNull.Value) { equ_MRecords.MR_MStuff = Convert.ToString(dr["MR_MStuff"]); } if (dr["VerifyStuff"] != DBNull.Value) { equ_MRecords.VerifyStuff = Convert.ToString(dr["VerifyStuff"]); } if (dr["VerifyDate"] != DBNull.Value) { equ_MRecords.VerifyDate = Convert.ToDateTime(dr["VerifyDate"]); } if (dr["MR_Bak"] != DBNull.Value) { equ_MRecords.MR_Bak = Convert.ToString(dr["MR_Bak"]); } if (dr["Creator"] != DBNull.Value) { equ_MRecords.Creator = Convert.ToString(dr["Creator"]); } if (dr["CreateTime"] != DBNull.Value) { equ_MRecords.CreateTime = Convert.ToDateTime(dr["CreateTime"]); } if (dr["Stat"] != DBNull.Value) { equ_MRecords.Stat = Convert.ToInt32(dr["Stat"]); } if (dr["MR_MPCode"] != DBNull.Value) { equ_MRecords.MR_MPCode = Convert.ToString(dr["MR_MPCode"]); } if (dr["MR_Type"] != DBNull.Value) { equ_MRecords.MR_Type = Convert.ToString(dr["MR_Type"]); } } }catch (System.Exception ex) { throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return(equ_MRecords); }
/// <summary> /// 获取指定的Sys_Config_Toolbar对象(即:一条记录 /// </summary> public Sys_Config_Toolbar GetByKey(decimal cT_ID) { Sys_Config_Toolbar sys_Config_Toolbar = new Sys_Config_Toolbar(); string sql = "SELECT CT_ID,CT_Module,CT_Field,CT_Name,CT_Order,CT_Type,CT_DictKey,CT_JS,CT_Default,CT_Show,CT_Attr,CT_Class,CT_Event,CT_Udef1,CT_Udef2,Stat FROM Sys_Config_Toolbar WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND CT_ID=@CT_ID "; idb.AddParameter("@CT_ID", cT_ID); SqlDataReader dr = null; try { dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { if (dr["CT_ID"] != DBNull.Value) { sys_Config_Toolbar.CT_ID = Convert.ToDecimal(dr["CT_ID"]); } if (dr["CT_Module"] != DBNull.Value) { sys_Config_Toolbar.CT_Module = Convert.ToString(dr["CT_Module"]); } if (dr["CT_Field"] != DBNull.Value) { sys_Config_Toolbar.CT_Field = Convert.ToString(dr["CT_Field"]); } if (dr["CT_Name"] != DBNull.Value) { sys_Config_Toolbar.CT_Name = Convert.ToString(dr["CT_Name"]); } if (dr["CT_Order"] != DBNull.Value) { sys_Config_Toolbar.CT_Order = Convert.ToInt32(dr["CT_Order"]); } if (dr["CT_Type"] != DBNull.Value) { sys_Config_Toolbar.CT_Type = Convert.ToString(dr["CT_Type"]); } if (dr["CT_DictKey"] != DBNull.Value) { sys_Config_Toolbar.CT_DictKey = Convert.ToString(dr["CT_DictKey"]); } if (dr["CT_JS"] != DBNull.Value) { sys_Config_Toolbar.CT_JS = Convert.ToString(dr["CT_JS"]); } if (dr["CT_Default"] != DBNull.Value) { sys_Config_Toolbar.CT_Default = Convert.ToString(dr["CT_Default"]); } if (dr["CT_Show"] != DBNull.Value) { sys_Config_Toolbar.CT_Show = Convert.ToString(dr["CT_Show"]); } if (dr["CT_Attr"] != DBNull.Value) { sys_Config_Toolbar.CT_Attr = Convert.ToString(dr["CT_Attr"]); } if (dr["CT_Class"] != DBNull.Value) { sys_Config_Toolbar.CT_Class = Convert.ToString(dr["CT_Class"]); } if (dr["CT_Event"] != DBNull.Value) { sys_Config_Toolbar.CT_Event = Convert.ToString(dr["CT_Event"]); } if (dr["CT_Udef1"] != DBNull.Value) { sys_Config_Toolbar.CT_Udef1 = Convert.ToString(dr["CT_Udef1"]); } if (dr["CT_Udef2"] != DBNull.Value) { sys_Config_Toolbar.CT_Udef2 = Convert.ToString(dr["CT_Udef2"]); } if (dr["Stat"] != DBNull.Value) { sys_Config_Toolbar.Stat = Convert.ToInt32(dr["Stat"]); } } }catch (System.Exception ex) { throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return(sys_Config_Toolbar); }
/// <summary> /// 获取指定的租赁房屋使用明细 House_Usage对象(即:一条记录 /// </summary> public House_Usage GetByKey(decimal hUsage_ID) { House_Usage house_Usage = new House_Usage(); string sql = "SELECT HUsage_ID,HUsage_Code,HUsage_HRentalCode,HUsage_User,HUsage_Type,HUsage_BeginDate,HUsage_EndDate,HUsage_Company,HUsage_Dept,HUsage_Remark,Stat,CreateDate,UpdateDate,DeleteDate FROM House_Usage WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND HUsage_ID=@HUsage_ID "; idb.AddParameter("@HUsage_ID", hUsage_ID); SqlDataReader dr = null; try { dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { if (dr["HUsage_ID"] != DBNull.Value) { house_Usage.HUsage_ID = Convert.ToDecimal(dr["HUsage_ID"]); } if (dr["HUsage_Code"] != DBNull.Value) { house_Usage.HUsage_Code = Convert.ToString(dr["HUsage_Code"]); } if (dr["HUsage_HRentalCode"] != DBNull.Value) { house_Usage.HUsage_HRentalCode = Convert.ToString(dr["HUsage_HRentalCode"]); } if (dr["HUsage_User"] != DBNull.Value) { house_Usage.HUsage_User = Convert.ToString(dr["HUsage_User"]); } if (dr["HUsage_Type"] != DBNull.Value) { house_Usage.HUsage_Type = Convert.ToString(dr["HUsage_Type"]); } if (dr["HUsage_BeginDate"] != DBNull.Value) { house_Usage.HUsage_BeginDate = Convert.ToDateTime(dr["HUsage_BeginDate"]); } if (dr["HUsage_EndDate"] != DBNull.Value) { house_Usage.HUsage_EndDate = Convert.ToDateTime(dr["HUsage_EndDate"]); } if (dr["HUsage_Company"] != DBNull.Value) { house_Usage.HUsage_Company = Convert.ToString(dr["HUsage_Company"]); } if (dr["HUsage_Dept"] != DBNull.Value) { house_Usage.HUsage_Dept = Convert.ToString(dr["HUsage_Dept"]); } if (dr["HUsage_Remark"] != DBNull.Value) { house_Usage.HUsage_Remark = Convert.ToString(dr["HUsage_Remark"]); } if (dr["Stat"] != DBNull.Value) { house_Usage.Stat = Convert.ToInt32(dr["Stat"]); } if (dr["CreateDate"] != DBNull.Value) { house_Usage.CreateDate = Convert.ToDateTime(dr["CreateDate"]); } if (dr["UpdateDate"] != DBNull.Value) { house_Usage.UpdateDate = Convert.ToDateTime(dr["UpdateDate"]); } if (dr["DeleteDate"] != DBNull.Value) { house_Usage.DeleteDate = Convert.ToDateTime(dr["DeleteDate"]); } } }catch (System.Exception ex) { throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return(house_Usage); }
/// <summary> /// 获取指定的图表配置细表 ChartDetail对象(即:一条记录 /// </summary> public ChartDetail GetByKey(decimal cD_ID) { ChartDetail chartDetail = new ChartDetail(); string sql = "SELECT CD_ID,CD_Module,CD_Areas,CD_ChartType,CD_DataSource,CD_Parmas,CD_BorderWidth,CD_BorderColor,CD_BorderDashStyle,CD_IsValueShownAsLabel,CD_LegendText,CD_MarkerSize,CD_MarkerColor,CD_MarkerStyle,Stat FROM ChartDetail WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND CD_ID=@CD_ID "; idb.AddParameter("@CD_ID", cD_ID); SqlDataReader dr = null; try { dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { if (dr["CD_ID"] != DBNull.Value) { chartDetail.CD_ID = Convert.ToDecimal(dr["CD_ID"]); } if (dr["CD_Module"] != DBNull.Value) { chartDetail.CD_Module = Convert.ToString(dr["CD_Module"]); } if (dr["CD_Areas"] != DBNull.Value) { chartDetail.CD_Areas = Convert.ToString(dr["CD_Areas"]); } if (dr["CD_ChartType"] != DBNull.Value) { chartDetail.CD_ChartType = Convert.ToString(dr["CD_ChartType"]); } if (dr["CD_DataSource"] != DBNull.Value) { chartDetail.CD_DataSource = Convert.ToString(dr["CD_DataSource"]); } if (dr["CD_Parmas"] != DBNull.Value) { chartDetail.CD_Parmas = Convert.ToString(dr["CD_Parmas"]); } if (dr["CD_BorderWidth"] != DBNull.Value) { chartDetail.CD_BorderWidth = Convert.ToDecimal(dr["CD_BorderWidth"]); } if (dr["CD_BorderColor"] != DBNull.Value) { chartDetail.CD_BorderColor = Convert.ToString(dr["CD_BorderColor"]); } if (dr["CD_BorderDashStyle"] != DBNull.Value) { chartDetail.CD_BorderDashStyle = Convert.ToString(dr["CD_BorderDashStyle"]); } if (dr["CD_IsValueShownAsLabel"] != DBNull.Value) { chartDetail.CD_IsValueShownAsLabel = Convert.ToBoolean(dr["CD_IsValueShownAsLabel"]); } if (dr["CD_LegendText"] != DBNull.Value) { chartDetail.CD_LegendText = Convert.ToString(dr["CD_LegendText"]); } if (dr["CD_MarkerSize"] != DBNull.Value) { chartDetail.CD_MarkerSize = Convert.ToDecimal(dr["CD_MarkerSize"]); } if (dr["CD_MarkerColor"] != DBNull.Value) { chartDetail.CD_MarkerColor = Convert.ToString(dr["CD_MarkerColor"]); } if (dr["CD_MarkerStyle"] != DBNull.Value) { chartDetail.CD_MarkerStyle = Convert.ToString(dr["CD_MarkerStyle"]); } if (dr["Stat"] != DBNull.Value) { chartDetail.Stat = Convert.ToInt32(dr["Stat"]); } } }catch (System.Exception ex) { throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return(chartDetail); }
/// <summary> /// 获取指定的Bse_Station对象(即:一条记录 /// </summary> public Bse_Station GetByKey(decimal sN_ID) { Bse_Station bse_Station = new Bse_Station(); string sql = "SELECT SN_ID,SN_Code,SN_Name,SN_AreaCode,SN_AreaName,SN_Mark,SN_Number,SN_Bak,SN_Interval,Stat,CreateTime,UpdateTime,DeleteTime FROM Bse_Station WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND SN_ID=@SN_ID "; idb.AddParameter("@SN_ID", sN_ID); SqlDataReader dr = null; try { dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { if (dr["SN_ID"] != DBNull.Value) { bse_Station.SN_ID = Convert.ToDecimal(dr["SN_ID"]); } if (dr["SN_Code"] != DBNull.Value) { bse_Station.SN_Code = Convert.ToString(dr["SN_Code"]); } if (dr["SN_Name"] != DBNull.Value) { bse_Station.SN_Name = Convert.ToString(dr["SN_Name"]); } if (dr["SN_AreaCode"] != DBNull.Value) { bse_Station.SN_AreaCode = Convert.ToString(dr["SN_AreaCode"]); } if (dr["SN_AreaName"] != DBNull.Value) { bse_Station.SN_AreaName = Convert.ToString(dr["SN_AreaName"]); } if (dr["SN_Mark"] != DBNull.Value) { bse_Station.SN_Mark = Convert.ToString(dr["SN_Mark"]); } if (dr["SN_Number"] != DBNull.Value) { bse_Station.SN_Number = Convert.ToString(dr["SN_Number"]); } if (dr["SN_Bak"] != DBNull.Value) { bse_Station.SN_Bak = Convert.ToString(dr["SN_Bak"]); } if (dr["SN_Interval"] != DBNull.Value) { bse_Station.SN_Interval = Convert.ToSingle(dr["SN_Interval"]); } if (dr["Stat"] != DBNull.Value) { bse_Station.Stat = Convert.ToInt32(dr["Stat"]); } if (dr["CreateTime"] != DBNull.Value) { bse_Station.CreateTime = Convert.ToDateTime(dr["CreateTime"]); } if (dr["UpdateTime"] != DBNull.Value) { bse_Station.UpdateTime = Convert.ToDateTime(dr["UpdateTime"]); } if (dr["DeleteTime"] != DBNull.Value) { bse_Station.DeleteTime = Convert.ToDateTime(dr["DeleteTime"]); } } }catch (System.Exception ex) { throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return(bse_Station); }
/// <summary> /// 获取指定的考勤信息 HR_TimeSheet对象(即:一条记录 /// </summary> public HR_TimeSheet GetByKey(decimal tS_ID) { HR_TimeSheet hR_TimeSheet = new HR_TimeSheet(); string sql = "SELECT TS_ID,TS_Code,TS_StuffName,TS_StuffCode,TS_Type,TS_TypeName,TS_Start,TS_End,TS_Total,TS_Matter,Creator,CreateTime,VerifyStat,VerifyDate,VerifyStuff,VerifyNext,Stat,CreateDate,UpdateDate,DeleteDate FROM HR_TimeSheet WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND TS_ID=@TS_ID "; idb.AddParameter("@TS_ID", tS_ID); SqlDataReader dr = null; try { dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { if (dr["TS_ID"] != DBNull.Value) { hR_TimeSheet.TS_ID = Convert.ToDecimal(dr["TS_ID"]); } if (dr["TS_Code"] != DBNull.Value) { hR_TimeSheet.TS_Code = Convert.ToString(dr["TS_Code"]); } if (dr["TS_StuffName"] != DBNull.Value) { hR_TimeSheet.TS_StuffName = Convert.ToString(dr["TS_StuffName"]); } if (dr["TS_StuffCode"] != DBNull.Value) { hR_TimeSheet.TS_StuffCode = Convert.ToString(dr["TS_StuffCode"]); } if (dr["TS_Type"] != DBNull.Value) { hR_TimeSheet.TS_Type = Convert.ToString(dr["TS_Type"]); } if (dr["TS_TypeName"] != DBNull.Value) { hR_TimeSheet.TS_TypeName = Convert.ToString(dr["TS_TypeName"]); } if (dr["TS_Start"] != DBNull.Value) { hR_TimeSheet.TS_Start = Convert.ToDateTime(dr["TS_Start"]); } if (dr["TS_End"] != DBNull.Value) { hR_TimeSheet.TS_End = Convert.ToDateTime(dr["TS_End"]); } if (dr["TS_Total"] != DBNull.Value) { hR_TimeSheet.TS_Total = Convert.ToInt64(dr["TS_Total"]); } if (dr["TS_Matter"] != DBNull.Value) { hR_TimeSheet.TS_Matter = Convert.ToString(dr["TS_Matter"]); } if (dr["Creator"] != DBNull.Value) { hR_TimeSheet.Creator = Convert.ToString(dr["Creator"]); } if (dr["CreateTime"] != DBNull.Value) { hR_TimeSheet.CreateTime = Convert.ToDateTime(dr["CreateTime"]); } if (dr["VerifyStat"] != DBNull.Value) { hR_TimeSheet.VerifyStat = Convert.ToString(dr["VerifyStat"]); } if (dr["VerifyDate"] != DBNull.Value) { hR_TimeSheet.VerifyDate = Convert.ToDateTime(dr["VerifyDate"]); } if (dr["VerifyStuff"] != DBNull.Value) { hR_TimeSheet.VerifyStuff = Convert.ToString(dr["VerifyStuff"]); } if (dr["VerifyNext"] != DBNull.Value) { hR_TimeSheet.VerifyNext = Convert.ToString(dr["VerifyNext"]); } if (dr["Stat"] != DBNull.Value) { hR_TimeSheet.Stat = Convert.ToInt32(dr["Stat"]); } if (dr["CreateDate"] != DBNull.Value) { hR_TimeSheet.CreateDate = Convert.ToDateTime(dr["CreateDate"]); } if (dr["UpdateDate"] != DBNull.Value) { hR_TimeSheet.UpdateDate = Convert.ToDateTime(dr["UpdateDate"]); } if (dr["DeleteDate"] != DBNull.Value) { hR_TimeSheet.DeleteDate = Convert.ToDateTime(dr["DeleteDate"]); } } }catch (System.Exception ex) { throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return(hR_TimeSheet); }
/// <summary> /// 获取指定的GPSRecord对象(即:一条记录 /// </summary> public GPSRecord GetByKey(decimal record_ID) { GPSRecord gPSRecord = new GPSRecord(); string sql = "SELECT Record_ID,License_Plate,Terminal_ID,PlateColor,DataType,GPSTime,Longitude,Latitude,GPSFlag,Speed,Direction,Comm_Type,MDTStatus,MDTAlarm,Data_Length,DataContend,Stat,CreateTime FROM GPSRecord WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND Record_ID=@Record_ID "; idb.AddParameter("@Record_ID", record_ID); SqlDataReader dr = null; try { dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { if (dr["Record_ID"] != DBNull.Value) { gPSRecord.Record_ID = Convert.ToDecimal(dr["Record_ID"]); } if (dr["License_Plate"] != DBNull.Value) { gPSRecord.License_Plate = Convert.ToString(dr["License_Plate"]); } if (dr["Terminal_ID"] != DBNull.Value) { gPSRecord.Terminal_ID = Convert.ToString(dr["Terminal_ID"]); } if (dr["PlateColor"] != DBNull.Value) { gPSRecord.PlateColor = Convert.ToInt32(dr["PlateColor"]); } if (dr["DataType"] != DBNull.Value) { gPSRecord.DataType = Convert.ToInt32(dr["DataType"]); } if (dr["GPSTime"] != DBNull.Value) { gPSRecord.GPSTime = Convert.ToDateTime(dr["GPSTime"]); } if (dr["Longitude"] != DBNull.Value) { gPSRecord.Longitude = Convert.ToDecimal(dr["Longitude"]); } if (dr["Latitude"] != DBNull.Value) { gPSRecord.Latitude = Convert.ToDecimal(dr["Latitude"]); } if (dr["GPSFlag"] != DBNull.Value) { gPSRecord.GPSFlag = Convert.ToInt32(dr["GPSFlag"]); } if (dr["Speed"] != DBNull.Value) { gPSRecord.Speed = Convert.ToInt32(dr["Speed"]); } if (dr["Direction"] != DBNull.Value) { gPSRecord.Direction = Convert.ToInt32(dr["Direction"]); } if (dr["Comm_Type"] != DBNull.Value) { gPSRecord.Comm_Type = Convert.ToInt32(dr["Comm_Type"]); } if (dr["MDTStatus"] != DBNull.Value) { gPSRecord.MDTStatus = Convert.ToInt32(dr["MDTStatus"]); } if (dr["MDTAlarm"] != DBNull.Value) { gPSRecord.MDTAlarm = Convert.ToInt32(dr["MDTAlarm"]); } if (dr["Data_Length"] != DBNull.Value) { gPSRecord.Data_Length = Convert.ToInt32(dr["Data_Length"]); } if (dr["DataContend"] != DBNull.Value) { gPSRecord.DataContend = Convert.ToString(dr["DataContend"]); } if (dr["Stat"] != DBNull.Value) { gPSRecord.Stat = Convert.ToInt32(dr["Stat"]); } if (dr["CreateTime"] != DBNull.Value) { gPSRecord.CreateTime = Convert.ToDateTime(dr["CreateTime"]); } } }catch (System.Exception ex) { throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return(gPSRecord); }
/// <summary> /// 获取指定的纯净水空桶管理 EmptyPureWater_Manage对象(即:一条记录 /// </summary> public EmptyPureWater_Manage GetByKey(decimal ePW_ID) { EmptyPureWater_Manage emptyPureWater_Manage = new EmptyPureWater_Manage(); string sql = "SELECT EPW_ID,EPW_Code,EPW_Duty,EPW_EmptyPosition,EPW_Count,EPW_Remark,Stat,CreateDate,UpdateDate,DeleteDate,EPW_Company,EPW_Dept FROM EmptyPureWater_Manage WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND EPW_ID=@EPW_ID "; idb.AddParameter("@EPW_ID", ePW_ID); SqlDataReader dr = null; try { dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { if (dr["EPW_ID"] != DBNull.Value) { emptyPureWater_Manage.EPW_ID = Convert.ToDecimal(dr["EPW_ID"]); } if (dr["EPW_Code"] != DBNull.Value) { emptyPureWater_Manage.EPW_Code = Convert.ToString(dr["EPW_Code"]); } if (dr["EPW_Duty"] != DBNull.Value) { emptyPureWater_Manage.EPW_Duty = Convert.ToString(dr["EPW_Duty"]); } if (dr["EPW_EmptyPosition"] != DBNull.Value) { emptyPureWater_Manage.EPW_EmptyPosition = Convert.ToString(dr["EPW_EmptyPosition"]); } if (dr["EPW_Count"] != DBNull.Value) { emptyPureWater_Manage.EPW_Count = Convert.ToInt32(dr["EPW_Count"]); } if (dr["EPW_Remark"] != DBNull.Value) { emptyPureWater_Manage.EPW_Remark = Convert.ToString(dr["EPW_Remark"]); } if (dr["Stat"] != DBNull.Value) { emptyPureWater_Manage.Stat = Convert.ToInt32(dr["Stat"]); } if (dr["CreateDate"] != DBNull.Value) { emptyPureWater_Manage.CreateDate = Convert.ToDateTime(dr["CreateDate"]); } if (dr["UpdateDate"] != DBNull.Value) { emptyPureWater_Manage.UpdateDate = Convert.ToDateTime(dr["UpdateDate"]); } if (dr["DeleteDate"] != DBNull.Value) { emptyPureWater_Manage.DeleteDate = Convert.ToDateTime(dr["DeleteDate"]); } if (dr["EPW_Company"] != DBNull.Value) { emptyPureWater_Manage.EPW_Company = Convert.ToString(dr["EPW_Company"]); } if (dr["EPW_Dept"] != DBNull.Value) { emptyPureWater_Manage.EPW_Dept = Convert.ToString(dr["EPW_Dept"]); } } }catch (System.Exception ex) { throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return(emptyPureWater_Manage); }
/// <summary> /// 获取指定的通用参考主表 Sys_Config_Refer对象(即:一条记录 /// </summary> public Sys_Config_Refer GetByKey(decimal r_ID) { Sys_Config_Refer sys_Config_Refer = new Sys_Config_Refer(); string sql = "SELECT R_ID,R_ModuleName,R_NameSpace,R_Title,R_Width,R_Height,Stat,R_TableName,R_FilterSql,R_SQL,R_Url FROM Sys_Config_Refer WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND R_ID=@R_ID "; idb.AddParameter("@R_ID", r_ID); SqlDataReader dr = null; try { dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { if (dr["R_ID"] != DBNull.Value) { sys_Config_Refer.R_ID = Convert.ToDecimal(dr["R_ID"]); } if (dr["R_ModuleName"] != DBNull.Value) { sys_Config_Refer.R_ModuleName = Convert.ToString(dr["R_ModuleName"]); } if (dr["R_NameSpace"] != DBNull.Value) { sys_Config_Refer.R_NameSpace = Convert.ToString(dr["R_NameSpace"]); } if (dr["R_Title"] != DBNull.Value) { sys_Config_Refer.R_Title = Convert.ToString(dr["R_Title"]); } if (dr["R_Width"] != DBNull.Value) { sys_Config_Refer.R_Width = Convert.ToInt32(dr["R_Width"]); } if (dr["R_Height"] != DBNull.Value) { sys_Config_Refer.R_Height = Convert.ToInt32(dr["R_Height"]); } if (dr["Stat"] != DBNull.Value) { sys_Config_Refer.Stat = Convert.ToInt32(dr["Stat"]); } if (dr["R_TableName"] != DBNull.Value) { sys_Config_Refer.R_TableName = Convert.ToString(dr["R_TableName"]); } if (dr["R_FilterSql"] != DBNull.Value) { sys_Config_Refer.R_FilterSql = Convert.ToString(dr["R_FilterSql"]); } if (dr["R_SQL"] != DBNull.Value) { sys_Config_Refer.R_SQL = Convert.ToString(dr["R_SQL"]); } if (dr["R_Url"] != DBNull.Value) { sys_Config_Refer.R_Url = Convert.ToString(dr["R_Url"]); } } }catch (System.Exception ex) { throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return(sys_Config_Refer); }
/// <summary> /// 获取指定的传真登记信息 Fax_Record对象(即:一条记录 /// </summary> public Fax_Record GetByKey(decimal fR_ID) { Fax_Record fax_Record = new Fax_Record(); string sql = "SELECT FR_ID,FR_Code,FR_Date,FR_Content,FR_Category,FR_Num,FR_PageNum,FR_Amount,FR_Operator,FR_OpDate,FR_OpRemark,FR_TranferCompany,FR_TranferDept,FR_TranferRemark,FR_TranferDate,FR_Company,FR_Dept,FR_Stat,Stat,CreateDate,UpdateDate,DeleteDate FROM Fax_Record WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND FR_ID=@FR_ID "; idb.AddParameter("@FR_ID", fR_ID); SqlDataReader dr = null; try { dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { if (dr["FR_ID"] != DBNull.Value) { fax_Record.FR_ID = Convert.ToDecimal(dr["FR_ID"]); } if (dr["FR_Code"] != DBNull.Value) { fax_Record.FR_Code = Convert.ToString(dr["FR_Code"]); } if (dr["FR_Date"] != DBNull.Value) { fax_Record.FR_Date = Convert.ToDateTime(dr["FR_Date"]); } if (dr["FR_Content"] != DBNull.Value) { fax_Record.FR_Content = Convert.ToString(dr["FR_Content"]); } if (dr["FR_Category"] != DBNull.Value) { fax_Record.FR_Category = Convert.ToString(dr["FR_Category"]); } if (dr["FR_Num"] != DBNull.Value) { fax_Record.FR_Num = Convert.ToInt32(dr["FR_Num"]); } if (dr["FR_PageNum"] != DBNull.Value) { fax_Record.FR_PageNum = Convert.ToInt32(dr["FR_PageNum"]); } if (dr["FR_Amount"] != DBNull.Value) { fax_Record.FR_Amount = Convert.ToDecimal(dr["FR_Amount"]); } if (dr["FR_Operator"] != DBNull.Value) { fax_Record.FR_Operator = Convert.ToString(dr["FR_Operator"]); } if (dr["FR_OpDate"] != DBNull.Value) { fax_Record.FR_OpDate = Convert.ToDateTime(dr["FR_OpDate"]); } if (dr["FR_OpRemark"] != DBNull.Value) { fax_Record.FR_OpRemark = Convert.ToString(dr["FR_OpRemark"]); } if (dr["FR_TranferCompany"] != DBNull.Value) { fax_Record.FR_TranferCompany = Convert.ToString(dr["FR_TranferCompany"]); } if (dr["FR_TranferDept"] != DBNull.Value) { fax_Record.FR_TranferDept = Convert.ToString(dr["FR_TranferDept"]); } if (dr["FR_TranferRemark"] != DBNull.Value) { fax_Record.FR_TranferRemark = Convert.ToString(dr["FR_TranferRemark"]); } if (dr["FR_TranferDate"] != DBNull.Value) { fax_Record.FR_TranferDate = Convert.ToString(dr["FR_TranferDate"]); } if (dr["FR_Company"] != DBNull.Value) { fax_Record.FR_Company = Convert.ToString(dr["FR_Company"]); } if (dr["FR_Dept"] != DBNull.Value) { fax_Record.FR_Dept = Convert.ToString(dr["FR_Dept"]); } if (dr["FR_Stat"] != DBNull.Value) { fax_Record.FR_Stat = Convert.ToString(dr["FR_Stat"]); } if (dr["Stat"] != DBNull.Value) { fax_Record.Stat = Convert.ToInt32(dr["Stat"]); } if (dr["CreateDate"] != DBNull.Value) { fax_Record.CreateDate = Convert.ToDateTime(dr["CreateDate"]); } if (dr["UpdateDate"] != DBNull.Value) { fax_Record.UpdateDate = Convert.ToDateTime(dr["UpdateDate"]); } if (dr["DeleteDate"] != DBNull.Value) { fax_Record.DeleteDate = Convert.ToDateTime(dr["DeleteDate"]); } } }catch (System.Exception ex) { throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return(fax_Record); }
/// <summary> /// 获取指定的联系人信息 Bse_Contacts对象(即:一条记录 /// </summary> public Bse_Contacts GetByKey(decimal bContact_ID) { Bse_Contacts bse_Contacts = new Bse_Contacts(); string sql = "SELECT BContact_ID,Module_Code,Record_ID,BContact_Name,BContact_Tel1,BContact_Tel2,BContact_Fax,BContact_Addr,BContact_Email,BContact_Duty,BContact_Gender,BContact_Career,BContact_Birth,BContact_From,BContact_IsDefault,CreateDate,Creator,BContact_Bak1,BContact_Bak2,Stat,BContact_Code,UpdateDate,DeleteDate FROM Bse_Contacts WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND BContact_ID=@BContact_ID "; idb.AddParameter("@BContact_ID", bContact_ID); SqlDataReader dr = null; try { dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { if (dr["BContact_ID"] != DBNull.Value) { bse_Contacts.BContact_ID = Convert.ToDecimal(dr["BContact_ID"]); } if (dr["Module_Code"] != DBNull.Value) { bse_Contacts.Module_Code = Convert.ToString(dr["Module_Code"]); } if (dr["Record_ID"] != DBNull.Value) { bse_Contacts.Record_ID = Convert.ToString(dr["Record_ID"]); } if (dr["BContact_Name"] != DBNull.Value) { bse_Contacts.BContact_Name = Convert.ToString(dr["BContact_Name"]); } if (dr["BContact_Tel1"] != DBNull.Value) { bse_Contacts.BContact_Tel1 = Convert.ToString(dr["BContact_Tel1"]); } if (dr["BContact_Tel2"] != DBNull.Value) { bse_Contacts.BContact_Tel2 = Convert.ToString(dr["BContact_Tel2"]); } if (dr["BContact_Fax"] != DBNull.Value) { bse_Contacts.BContact_Fax = Convert.ToString(dr["BContact_Fax"]); } if (dr["BContact_Addr"] != DBNull.Value) { bse_Contacts.BContact_Addr = Convert.ToString(dr["BContact_Addr"]); } if (dr["BContact_Email"] != DBNull.Value) { bse_Contacts.BContact_Email = Convert.ToString(dr["BContact_Email"]); } if (dr["BContact_Duty"] != DBNull.Value) { bse_Contacts.BContact_Duty = Convert.ToString(dr["BContact_Duty"]); } if (dr["BContact_Gender"] != DBNull.Value) { bse_Contacts.BContact_Gender = Convert.ToString(dr["BContact_Gender"]); } if (dr["BContact_Career"] != DBNull.Value) { bse_Contacts.BContact_Career = Convert.ToString(dr["BContact_Career"]); } if (dr["BContact_Birth"] != DBNull.Value) { bse_Contacts.BContact_Birth = Convert.ToDateTime(dr["BContact_Birth"]); } if (dr["BContact_From"] != DBNull.Value) { bse_Contacts.BContact_From = Convert.ToString(dr["BContact_From"]); } if (dr["BContact_IsDefault"] != DBNull.Value) { bse_Contacts.BContact_IsDefault = Convert.ToString(dr["BContact_IsDefault"]); } if (dr["CreateDate"] != DBNull.Value) { bse_Contacts.CreateDate = Convert.ToDateTime(dr["CreateDate"]); } if (dr["Creator"] != DBNull.Value) { bse_Contacts.Creator = Convert.ToString(dr["Creator"]); } if (dr["BContact_Bak1"] != DBNull.Value) { bse_Contacts.BContact_Bak1 = Convert.ToString(dr["BContact_Bak1"]); } if (dr["BContact_Bak2"] != DBNull.Value) { bse_Contacts.BContact_Bak2 = Convert.ToString(dr["BContact_Bak2"]); } if (dr["Stat"] != DBNull.Value) { bse_Contacts.Stat = Convert.ToInt32(dr["Stat"]); } if (dr["BContact_Code"] != DBNull.Value) { bse_Contacts.BContact_Code = Convert.ToString(dr["BContact_Code"]); } if (dr["UpdateDate"] != DBNull.Value) { bse_Contacts.UpdateDate = Convert.ToDateTime(dr["UpdateDate"]); } if (dr["DeleteDate"] != DBNull.Value) { bse_Contacts.DeleteDate = Convert.ToDateTime(dr["DeleteDate"]); } } }catch (System.Exception ex) { throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return(bse_Contacts); }
/// <summary> /// 获取指定的请购单 WH_ApplyBuy对象(即:一条记录 /// </summary> public WH_ApplyBuy GetByKey(decimal mVI_ID) { WH_ApplyBuy wH_ApplyBuy = new WH_ApplyBuy(); string sql = "SELECT MVI_ID,MVI_Code,MVI_RCode,MVI_Type,MVI_MCode,MVI_Spec,MVI_Sup,MVI_Num,MVI_Unit,MVI_MDPrice,Stat,MV_CustCode,MV_CustName,MV_CustRef,MV_CustDate,MV_VerifyStep,MV_VerifyStuff,MV_VerifyDate,MV_VerifyStat,MV_ContractNo FROM WH_ApplyBuy WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND MVI_ID=@MVI_ID "; idb.AddParameter("@MVI_ID", mVI_ID); SqlDataReader dr = null; try { dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { if (dr["MVI_ID"] != DBNull.Value) { wH_ApplyBuy.MVI_ID = Convert.ToDecimal(dr["MVI_ID"]); } if (dr["MVI_Code"] != DBNull.Value) { wH_ApplyBuy.MVI_Code = Convert.ToString(dr["MVI_Code"]); } if (dr["MVI_RCode"] != DBNull.Value) { wH_ApplyBuy.MVI_RCode = Convert.ToString(dr["MVI_RCode"]); } if (dr["MVI_Type"] != DBNull.Value) { wH_ApplyBuy.MVI_Type = Convert.ToString(dr["MVI_Type"]); } if (dr["MVI_MCode"] != DBNull.Value) { wH_ApplyBuy.MVI_MCode = Convert.ToString(dr["MVI_MCode"]); } if (dr["MVI_Spec"] != DBNull.Value) { wH_ApplyBuy.MVI_Spec = Convert.ToString(dr["MVI_Spec"]); } if (dr["MVI_Sup"] != DBNull.Value) { wH_ApplyBuy.MVI_Sup = Convert.ToString(dr["MVI_Sup"]); } if (dr["MVI_Num"] != DBNull.Value) { wH_ApplyBuy.MVI_Num = Convert.ToInt32(dr["MVI_Num"]); } if (dr["MVI_Unit"] != DBNull.Value) { wH_ApplyBuy.MVI_Unit = Convert.ToString(dr["MVI_Unit"]); } if (dr["MVI_MDPrice"] != DBNull.Value) { wH_ApplyBuy.MVI_MDPrice = Convert.ToDouble(dr["MVI_MDPrice"]); } if (dr["Stat"] != DBNull.Value) { wH_ApplyBuy.Stat = Convert.ToInt32(dr["Stat"]); } if (dr["MV_CustCode"] != DBNull.Value) { wH_ApplyBuy.MV_CustCode = Convert.ToString(dr["MV_CustCode"]); } if (dr["MV_CustName"] != DBNull.Value) { wH_ApplyBuy.MV_CustName = Convert.ToString(dr["MV_CustName"]); } if (dr["MV_CustRef"] != DBNull.Value) { wH_ApplyBuy.MV_CustRef = Convert.ToString(dr["MV_CustRef"]); } if (dr["MV_CustDate"] != DBNull.Value) { wH_ApplyBuy.MV_CustDate = Convert.ToString(dr["MV_CustDate"]); } if (dr["MV_VerifyStep"] != DBNull.Value) { wH_ApplyBuy.MV_VerifyStep = Convert.ToString(dr["MV_VerifyStep"]); } if (dr["MV_VerifyStuff"] != DBNull.Value) { wH_ApplyBuy.MV_VerifyStuff = Convert.ToString(dr["MV_VerifyStuff"]); } if (dr["MV_VerifyDate"] != DBNull.Value) { wH_ApplyBuy.MV_VerifyDate = Convert.ToDateTime(dr["MV_VerifyDate"]); } if (dr["MV_VerifyStat"] != DBNull.Value) { wH_ApplyBuy.MV_VerifyStat = Convert.ToString(dr["MV_VerifyStat"]); } if (dr["MV_ContractNo"] != DBNull.Value) { wH_ApplyBuy.MV_ContractNo = Convert.ToString(dr["MV_ContractNo"]); } } }catch (System.Exception ex) { throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return(wH_ApplyBuy); }
/// <summary> /// 获取指定的设备检修计划 Equ_MPlan对象(即:一条记录 /// </summary> public Equ_MPlan GetByKey(decimal mP_ID) { Equ_MPlan equ_MPlan = new Equ_MPlan(); string sql = "SELECT MP_ID,MP_Code,MP_Name,MP_Stuff,MP_Start,MP_End,VerifyStuff,VerifyStat,VerifyDate,Stat,MP_ECode,MP_EName FROM Equ_MPlan WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND MP_ID=@MP_ID "; idb.AddParameter("@MP_ID", mP_ID); SqlDataReader dr = null; try { dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { if (dr["MP_ID"] != DBNull.Value) { equ_MPlan.MP_ID = Convert.ToDecimal(dr["MP_ID"]); } if (dr["MP_Code"] != DBNull.Value) { equ_MPlan.MP_Code = Convert.ToString(dr["MP_Code"]); } if (dr["MP_Name"] != DBNull.Value) { equ_MPlan.MP_Name = Convert.ToString(dr["MP_Name"]); } if (dr["MP_Stuff"] != DBNull.Value) { equ_MPlan.MP_Stuff = Convert.ToString(dr["MP_Stuff"]); } if (dr["MP_Start"] != DBNull.Value) { equ_MPlan.MP_Start = Convert.ToDateTime(dr["MP_Start"]); } if (dr["MP_End"] != DBNull.Value) { equ_MPlan.MP_End = Convert.ToDateTime(dr["MP_End"]); } if (dr["VerifyStuff"] != DBNull.Value) { equ_MPlan.VerifyStuff = Convert.ToString(dr["VerifyStuff"]); } if (dr["VerifyStat"] != DBNull.Value) { equ_MPlan.VerifyStat = Convert.ToString(dr["VerifyStat"]); } if (dr["VerifyDate"] != DBNull.Value) { equ_MPlan.VerifyDate = Convert.ToDateTime(dr["VerifyDate"]); } if (dr["Stat"] != DBNull.Value) { equ_MPlan.Stat = Convert.ToInt32(dr["Stat"]); } if (dr["MP_ECode"] != DBNull.Value) { equ_MPlan.MP_ECode = Convert.ToString(dr["MP_ECode"]); } if (dr["MP_EName"] != DBNull.Value) { equ_MPlan.MP_EName = Convert.ToString(dr["MP_EName"]); } } }catch (System.Exception ex) { throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return(equ_MPlan); }
/// <summary> /// 获取指定的Sys_LoginLog Sys_LoginLog对象(即:一条记录 /// </summary> public Sys_LoginLog GetByKey(decimal eL_ID) { Sys_LoginLog sys_LoginLog = new Sys_LoginLog(); string sql = "SELECT EL_ID,EL_Date,EL_IP,EL_Mac,EL_Success,EL_UserCode,EL_UserName,EL_Dept,EL_Company,EL_CancleDate,Stat FROM Sys_LoginLog WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND EL_ID=@EL_ID "; idb.AddParameter("@EL_ID", eL_ID); SqlDataReader dr = null; try { dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { if (dr["EL_ID"] != DBNull.Value) { sys_LoginLog.EL_ID = Convert.ToDecimal(dr["EL_ID"]); } if (dr["EL_Date"] != DBNull.Value) { sys_LoginLog.EL_Date = Convert.ToDateTime(dr["EL_Date"]); } if (dr["EL_IP"] != DBNull.Value) { sys_LoginLog.EL_IP = Convert.ToString(dr["EL_IP"]); } if (dr["EL_Mac"] != DBNull.Value) { sys_LoginLog.EL_Mac = Convert.ToString(dr["EL_Mac"]); } if (dr["EL_Success"] != DBNull.Value) { sys_LoginLog.EL_Success = Convert.ToString(dr["EL_Success"]); } if (dr["EL_UserCode"] != DBNull.Value) { sys_LoginLog.EL_UserCode = Convert.ToString(dr["EL_UserCode"]); } if (dr["EL_UserName"] != DBNull.Value) { sys_LoginLog.EL_UserName = Convert.ToString(dr["EL_UserName"]); } if (dr["EL_Dept"] != DBNull.Value) { sys_LoginLog.EL_Dept = Convert.ToString(dr["EL_Dept"]); } if (dr["EL_Company"] != DBNull.Value) { sys_LoginLog.EL_Company = Convert.ToString(dr["EL_Company"]); } if (dr["EL_CancleDate"] != DBNull.Value) { sys_LoginLog.EL_CancleDate = Convert.ToDateTime(dr["EL_CancleDate"]); } if (dr["Stat"] != DBNull.Value) { sys_LoginLog.Stat = Convert.ToInt32(dr["Stat"]); } } }catch (System.Exception ex) { throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return(sys_LoginLog); }
/// <summary> /// 获取指定的Bug管理系统 Sys_Bug对象(即:一条记录 /// </summary> public Sys_Bug GetByKey(decimal sys_ID) { Sys_Bug sys_Bug = new Sys_Bug(); string sql = "SELECT Sys_ID,Sys_Code,Sys_Date,Sys_Title,Sys_Des,Sys_Project,Sys_Module,Sys_UserCode,Sys_UserName,Sys_Owner,Sys_OpUser,Sys_Status,Stat FROM Sys_Bug WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND Sys_ID=@Sys_ID "; idb.AddParameter("@Sys_ID", sys_ID); SqlDataReader dr = null; try { sql += "ORDER BY Sys_ID DESC"; dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { if (dr["Sys_ID"] != DBNull.Value) { sys_Bug.Sys_ID = Convert.ToDecimal(dr["Sys_ID"]); } if (dr["Sys_Code"] != DBNull.Value) { sys_Bug.Sys_Code = Convert.ToString(dr["Sys_Code"]); } if (dr["Sys_Date"] != DBNull.Value) { sys_Bug.Sys_Date = Convert.ToDateTime(dr["Sys_Date"]); } if (dr["Sys_Title"] != DBNull.Value) { sys_Bug.Sys_Title = Convert.ToString(dr["Sys_Title"]); } if (dr["Sys_Des"] != DBNull.Value) { sys_Bug.Sys_Des = Convert.ToString(dr["Sys_Des"]); } if (dr["Sys_Project"] != DBNull.Value) { sys_Bug.Sys_Project = Convert.ToString(dr["Sys_Project"]); } if (dr["Sys_Module"] != DBNull.Value) { sys_Bug.Sys_Module = Convert.ToString(dr["Sys_Module"]); } if (dr["Sys_UserCode"] != DBNull.Value) { sys_Bug.Sys_UserCode = Convert.ToString(dr["Sys_UserCode"]); } if (dr["Sys_UserName"] != DBNull.Value) { sys_Bug.Sys_UserName = Convert.ToString(dr["Sys_UserName"]); } if (dr["Sys_Owner"] != DBNull.Value) { sys_Bug.Sys_Owner = Convert.ToString(dr["Sys_Owner"]); } if (dr["Sys_OpUser"] != DBNull.Value) { sys_Bug.Sys_OpUser = Convert.ToString(dr["Sys_OpUser"]); } if (dr["Sys_Status"] != DBNull.Value) { sys_Bug.Sys_Status = Convert.ToString(dr["Sys_Status"]); } if (dr["Stat"] != DBNull.Value) { sys_Bug.Stat = Convert.ToInt32(dr["Stat"]); } } }catch (System.Exception ex) { throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return(sys_Bug); }
/// <summary> /// 获取指定的考评信息 HR_Evaluation对象(即:一条记录 /// </summary> public HR_Evaluation GetByKey(decimal eva_ID) { HR_Evaluation hR_Evaluation = new HR_Evaluation(); string sql = "SELECT Eva_ID,Eva_Code,Eva_StuffCode,Eva_StuffName,Eva_Date,Eva_Records,Eva_Conclusion,Eva_Manager,Eva_Level,Eva_Bak,Stat,CreateDate,UpdateDate,DeleteDate FROM HR_Evaluation WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND Eva_ID=@Eva_ID "; idb.AddParameter("@Eva_ID", eva_ID); SqlDataReader dr = null; try { dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { if (dr["Eva_ID"] != DBNull.Value) { hR_Evaluation.Eva_ID = Convert.ToDecimal(dr["Eva_ID"]); } if (dr["Eva_Code"] != DBNull.Value) { hR_Evaluation.Eva_Code = Convert.ToString(dr["Eva_Code"]); } if (dr["Eva_StuffCode"] != DBNull.Value) { hR_Evaluation.Eva_StuffCode = Convert.ToString(dr["Eva_StuffCode"]); } if (dr["Eva_StuffName"] != DBNull.Value) { hR_Evaluation.Eva_StuffName = Convert.ToString(dr["Eva_StuffName"]); } if (dr["Eva_Date"] != DBNull.Value) { hR_Evaluation.Eva_Date = Convert.ToDateTime(dr["Eva_Date"]); } if (dr["Eva_Records"] != DBNull.Value) { hR_Evaluation.Eva_Records = Convert.ToString(dr["Eva_Records"]); } if (dr["Eva_Conclusion"] != DBNull.Value) { hR_Evaluation.Eva_Conclusion = Convert.ToString(dr["Eva_Conclusion"]); } if (dr["Eva_Manager"] != DBNull.Value) { hR_Evaluation.Eva_Manager = Convert.ToString(dr["Eva_Manager"]); } if (dr["Eva_Level"] != DBNull.Value) { hR_Evaluation.Eva_Level = Convert.ToString(dr["Eva_Level"]); } if (dr["Eva_Bak"] != DBNull.Value) { hR_Evaluation.Eva_Bak = Convert.ToString(dr["Eva_Bak"]); } if (dr["Stat"] != DBNull.Value) { hR_Evaluation.Stat = Convert.ToInt32(dr["Stat"]); } if (dr["CreateDate"] != DBNull.Value) { hR_Evaluation.CreateDate = Convert.ToDateTime(dr["CreateDate"]); } if (dr["UpdateDate"] != DBNull.Value) { hR_Evaluation.UpdateDate = Convert.ToDateTime(dr["UpdateDate"]); } if (dr["DeleteDate"] != DBNull.Value) { hR_Evaluation.DeleteDate = Convert.ToDateTime(dr["DeleteDate"]); } } }catch (System.Exception ex) { throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return(hR_Evaluation); }
/// <summary> /// 获取指定的数据字典 Bse_Dict对象(即:一条记录 /// </summary> public Bse_Dict GetByKey(decimal dict_ID) { Bse_Dict bse_Dict = new Bse_Dict(); string sql = "SELECT Dict_ID,Dict_Key,Dict_Code,Dict_Name,Dict_Order,Dict_PCode,Dict_PName,Dict_Desp,Dict_SCode,Dict_Bak,Dict_UDef1,Dict_UDef2,Dict_UDef3,Dict_UDef4,Dict_UDef5,Dict_Level,Dict_IsEditable,Stat FROM Bse_Dict WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND Dict_ID=@Dict_ID "; idb.AddParameter("@Dict_ID", dict_ID); SqlDataReader dr = null; try { dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { if (dr["Dict_ID"] != DBNull.Value) { bse_Dict.Dict_ID = Convert.ToDecimal(dr["Dict_ID"]); } if (dr["Dict_Key"] != DBNull.Value) { bse_Dict.Dict_Key = Convert.ToString(dr["Dict_Key"]); } if (dr["Dict_Code"] != DBNull.Value) { bse_Dict.Dict_Code = Convert.ToString(dr["Dict_Code"]); } if (dr["Dict_Name"] != DBNull.Value) { bse_Dict.Dict_Name = Convert.ToString(dr["Dict_Name"]); } if (dr["Dict_Order"] != DBNull.Value) { bse_Dict.Dict_Order = Convert.ToInt32(dr["Dict_Order"]); } if (dr["Dict_PCode"] != DBNull.Value) { bse_Dict.Dict_PCode = Convert.ToString(dr["Dict_PCode"]); } if (dr["Dict_PName"] != DBNull.Value) { bse_Dict.Dict_PName = Convert.ToString(dr["Dict_PName"]); } if (dr["Dict_Desp"] != DBNull.Value) { bse_Dict.Dict_Desp = Convert.ToString(dr["Dict_Desp"]); } if (dr["Dict_SCode"] != DBNull.Value) { bse_Dict.Dict_SCode = Convert.ToString(dr["Dict_SCode"]); } if (dr["Dict_Bak"] != DBNull.Value) { bse_Dict.Dict_Bak = Convert.ToString(dr["Dict_Bak"]); } if (dr["Dict_UDef1"] != DBNull.Value) { bse_Dict.Dict_UDef1 = Convert.ToString(dr["Dict_UDef1"]); } if (dr["Dict_UDef2"] != DBNull.Value) { bse_Dict.Dict_UDef2 = Convert.ToString(dr["Dict_UDef2"]); } if (dr["Dict_UDef3"] != DBNull.Value) { bse_Dict.Dict_UDef3 = Convert.ToString(dr["Dict_UDef3"]); } if (dr["Dict_UDef4"] != DBNull.Value) { bse_Dict.Dict_UDef4 = Convert.ToString(dr["Dict_UDef4"]); } if (dr["Dict_UDef5"] != DBNull.Value) { bse_Dict.Dict_UDef5 = Convert.ToString(dr["Dict_UDef5"]); } if (dr["Dict_Level"] != DBNull.Value) { bse_Dict.Dict_Level = Convert.ToInt32(dr["Dict_Level"]); } if (dr["Dict_IsEditable"] != DBNull.Value) { bse_Dict.Dict_IsEditable = Convert.ToInt32(dr["Dict_IsEditable"]); } if (dr["Stat"] != DBNull.Value) { bse_Dict.Stat = Convert.ToInt32(dr["Stat"]); } } }catch (System.Exception ex) { throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return(bse_Dict); }
/// <summary> /// 获取指定的合同细目信息 WH_CItem对象(即:一条记录 /// </summary> public WH_CItem GetByKey(decimal wHCI_ID) { WH_CItem wH_CItem = new WH_CItem(); string sql = "SELECT WHCI_ID,WHCI_CCode,WHCI_MCode,WHCI_Num,WHCI_Unit,WHCI_Manu,WHCI_MDate,Stat,CreateDate,UpdateDate,DeleteDate FROM WH_CItem WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND WHCI_ID=@WHCI_ID "; idb.AddParameter("@WHCI_ID", wHCI_ID); SqlDataReader dr = null; try { dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { if (dr["WHCI_ID"] != DBNull.Value) { wH_CItem.WHCI_ID = Convert.ToDecimal(dr["WHCI_ID"]); } if (dr["WHCI_CCode"] != DBNull.Value) { wH_CItem.WHCI_CCode = Convert.ToString(dr["WHCI_CCode"]); } if (dr["WHCI_MCode"] != DBNull.Value) { wH_CItem.WHCI_MCode = Convert.ToString(dr["WHCI_MCode"]); } if (dr["WHCI_Num"] != DBNull.Value) { wH_CItem.WHCI_Num = Convert.ToInt32(dr["WHCI_Num"]); } if (dr["WHCI_Unit"] != DBNull.Value) { wH_CItem.WHCI_Unit = Convert.ToString(dr["WHCI_Unit"]); } if (dr["WHCI_Manu"] != DBNull.Value) { wH_CItem.WHCI_Manu = Convert.ToString(dr["WHCI_Manu"]); } if (dr["WHCI_MDate"] != DBNull.Value) { wH_CItem.WHCI_MDate = Convert.ToDateTime(dr["WHCI_MDate"]); } if (dr["Stat"] != DBNull.Value) { wH_CItem.Stat = Convert.ToInt32(dr["Stat"]); } if (dr["CreateDate"] != DBNull.Value) { wH_CItem.CreateDate = Convert.ToDateTime(dr["CreateDate"]); } if (dr["UpdateDate"] != DBNull.Value) { wH_CItem.UpdateDate = Convert.ToDateTime(dr["UpdateDate"]); } if (dr["DeleteDate"] != DBNull.Value) { wH_CItem.DeleteDate = Convert.ToDateTime(dr["DeleteDate"]); } } }catch (System.Exception ex) { throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return(wH_CItem); }
/// <summary> /// 获取指定的搅拌站信息 PC_BStation对象(即:一条记录 /// </summary> public PC_BStation GetByKey(decimal pCBS_ID) { PC_BStation pC_BStation = new PC_BStation(); string sql = "SELECT PCBS_ID,PCBS_Code,PCBS_Name,PCBS_Addr,PCBS_Start,PCBS_Status,PCBS_Bak,Stat,CreateDate,UpdateDate,DeleteDate FROM PC_BStation WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND PCBS_ID=@PCBS_ID "; idb.AddParameter("@PCBS_ID", pCBS_ID); SqlDataReader dr = null; try { dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { if (dr["PCBS_ID"] != DBNull.Value) { pC_BStation.PCBS_ID = Convert.ToDecimal(dr["PCBS_ID"]); } if (dr["PCBS_Code"] != DBNull.Value) { pC_BStation.PCBS_Code = Convert.ToString(dr["PCBS_Code"]); } if (dr["PCBS_Name"] != DBNull.Value) { pC_BStation.PCBS_Name = Convert.ToString(dr["PCBS_Name"]); } if (dr["PCBS_Addr"] != DBNull.Value) { pC_BStation.PCBS_Addr = Convert.ToString(dr["PCBS_Addr"]); } if (dr["PCBS_Start"] != DBNull.Value) { pC_BStation.PCBS_Start = Convert.ToDateTime(dr["PCBS_Start"]); } if (dr["PCBS_Status"] != DBNull.Value) { pC_BStation.PCBS_Status = Convert.ToString(dr["PCBS_Status"]); } if (dr["PCBS_Bak"] != DBNull.Value) { pC_BStation.PCBS_Bak = Convert.ToString(dr["PCBS_Bak"]); } if (dr["Stat"] != DBNull.Value) { pC_BStation.Stat = Convert.ToInt32(dr["Stat"]); } if (dr["CreateDate"] != DBNull.Value) { pC_BStation.CreateDate = Convert.ToDateTime(dr["CreateDate"]); } if (dr["UpdateDate"] != DBNull.Value) { pC_BStation.UpdateDate = Convert.ToDateTime(dr["UpdateDate"]); } if (dr["DeleteDate"] != DBNull.Value) { pC_BStation.DeleteDate = Convert.ToDateTime(dr["DeleteDate"]); } } }catch (System.Exception ex) { throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return(pC_BStation); }
/// <summary> /// 获取指定的Sys_DictModule对象(即:一条记录 /// </summary> public Sys_DictModule GetByKey(Int64 iD) { Sys_DictModule sys_DictModule = new Sys_DictModule(); string sql = "SELECT ID,ModuleCode,CodeLength,ChildLength,TableName,CodeField,FilterSQL,Udef1,Udef2,Udef3,Udef4,Udef5 FROM Sys_DictModule WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND ID=@ID "; idb.AddParameter("@ID", iD); SqlDataReader dr = null; try { dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { if (dr["ID"] != DBNull.Value) { sys_DictModule.ID = Convert.ToInt64(dr["ID"]); } if (dr["ModuleCode"] != DBNull.Value) { sys_DictModule.ModuleCode = Convert.ToString(dr["ModuleCode"]); } if (dr["CodeLength"] != DBNull.Value) { sys_DictModule.CodeLength = Convert.ToInt32(dr["CodeLength"]); } if (dr["ChildLength"] != DBNull.Value) { sys_DictModule.ChildLength = Convert.ToInt32(dr["ChildLength"]); } if (dr["TableName"] != DBNull.Value) { sys_DictModule.TableName = Convert.ToString(dr["TableName"]); } if (dr["CodeField"] != DBNull.Value) { sys_DictModule.CodeField = Convert.ToString(dr["CodeField"]); } if (dr["FilterSQL"] != DBNull.Value) { sys_DictModule.FilterSQL = Convert.ToString(dr["FilterSQL"]); } if (dr["Udef1"] != DBNull.Value) { sys_DictModule.Udef1 = Convert.ToString(dr["Udef1"]); } if (dr["Udef2"] != DBNull.Value) { sys_DictModule.Udef2 = Convert.ToString(dr["Udef2"]); } if (dr["Udef3"] != DBNull.Value) { sys_DictModule.Udef3 = Convert.ToString(dr["Udef3"]); } if (dr["Udef4"] != DBNull.Value) { sys_DictModule.Udef4 = Convert.ToString(dr["Udef4"]); } if (dr["Udef5"] != DBNull.Value) { sys_DictModule.Udef5 = Convert.ToString(dr["Udef5"]); } } }catch (System.Exception ex) { throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return(sys_DictModule); }