public static RPSetup ConvertToRPSetup(DataRow row) { RPSetup info = new RPSetup(); try { info.ScreenID =row["ScreenID"].ToString() ; info.RPID = Convert.ToInt32(row["RPID"]); info.ReportName = row["ReportName"].ToString(); info.ReportCap = row["ReportCap"].ToString(); info.String1 = row["String1"].ToString(); info.String1Pro = row["String1Pro"].ToString(); info.String2 = row["String2"].ToString(); info.String2Pro = row["String2Pro"].ToString(); info.String3 = row["String3"].ToString(); info.String3Pro = row["String3Pro"].ToString(); info.Date1 = row["Date1"].ToString(); info.Date2 = row["Date2"].ToString(); info.Date3 = row["Date3"].ToString(); info.Bool1 = row["Bool1"].ToString(); info.Bool2 = row["Bool2"].ToString(); info.Bool3 = row["Bool3"].ToString(); info.List = row["List"].ToString(); info.ListPro = row["ListPro"].ToString(); } catch { info = null; } return info; }
//public static DataTable GetBy_RPID(int RPID) //{ // return ConnectDB.ExecuteReader("pr_RPSetup_GetByRPID", new String[] { "RPID" }, new Object[] { RPID }); //} public static RPSetup GetBy_RPID(int RPID) { DataTable tb = ConnectDB.ExecuteReader("pr_RPSetup_GetByRPID", new String[] { "RPID" }, new Object[] { RPID }); RPSetup info = new RPSetup(); if (tb.Rows.Count > 0) info = ConvertToRPSetup(tb.Rows[0]); return info; }