/// <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);
}
