public static Model.WebBase GetModel(object obj) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 SMSState,SMSName,SMSPassword,TelVerify,SMSTitle,MonitorTel,SMSMinCount,EmailSmtp,EmailName,EmailPassword,EmailTitle,EmailVerify,EmailState,DaySMSCount,RandPassword,MonitorEmail,AutoID from WebBase "); yny_005.Model.WebBase model = new yny_005.Model.WebBase(); DataSet ds = DbHelperSQL.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
private static yny_005.Model.WebBase DataRowToModel(DataRow row) { yny_005.Model.WebBase model = new yny_005.Model.WebBase(); if (row != null) { if (row["SMSState"] != null && row["SMSState"].ToString() != "") { if ((row["SMSState"].ToString() == "1") || (row["SMSState"].ToString().ToLower() == "true")) { model.SMSState = true; } else { model.SMSState = false; } } if (row["SMSName"] != null) { model.SMSName = row["SMSName"].ToString(); } if (row["SMSPassword"] != null) { model.SMSPassword = row["SMSPassword"].ToString(); } if (row["TelVerify"] != null && row["TelVerify"].ToString() != "") { if ((row["TelVerify"].ToString() == "1") || (row["TelVerify"].ToString().ToLower() == "true")) { model.TelVerify = true; } else { model.TelVerify = false; } } if (row["AutoID"] != null && row["AutoID"].ToString() != "") { if ((row["AutoID"].ToString() == "1") || (row["AutoID"].ToString().ToLower() == "true")) { model.AutoID = true; } else { model.AutoID = false; } } if (row["SMSTitle"] != null) { model.SMSTitle = row["SMSTitle"].ToString(); } if (row["MonitorTel"] != null) { model.MonitorTel = row["MonitorTel"].ToString(); } if (row["SMSMinCount"] != null && row["SMSMinCount"].ToString() != "") { model.SMSMinCount = int.Parse(row["SMSMinCount"].ToString()); } if (row["EmailSmtp"] != null) { model.EmailSmtp = row["EmailSmtp"].ToString(); } if (row["EmailName"] != null) { model.EmailName = row["EmailName"].ToString(); } if (row["EmailPassword"] != null) { model.EmailPassword = row["EmailPassword"].ToString(); } if (row["EmailTitle"] != null) { model.EmailTitle = row["EmailTitle"].ToString(); } if (row["EmailVerify"] != null && row["EmailVerify"].ToString() != "") { if ((row["EmailVerify"].ToString() == "1") || (row["EmailVerify"].ToString().ToLower() == "true")) { model.EmailVerify = true; } else { model.EmailVerify = false; } } if (row["EmailState"] != null && row["EmailState"].ToString() != "") { if ((row["EmailState"].ToString() == "1") || (row["EmailState"].ToString().ToLower() == "true")) { model.EmailState = true; } else { model.EmailState = false; } } if (row["DaySMSCount"] != null && row["DaySMSCount"].ToString() != "") { model.DaySMSCount = int.Parse(row["DaySMSCount"].ToString()); } if (row["RandPassword"] != null && row["RandPassword"].ToString() != "") { if ((row["RandPassword"].ToString() == "1") || (row["RandPassword"].ToString().ToLower() == "true")) { model.RandPassword = true; } else { model.RandPassword = false; } } if (row["MonitorEmail"] != null) { model.MonitorEmail = row["MonitorEmail"].ToString(); } } return(model); }