/// <summary> /// 更新一条数据 /// </summary> public bool Update(LPWeb.Model.Company_EasyMortgage model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Company_EasyMortgage set "); strSql.Append("ClientID=@ClientID,"); strSql.Append("URL=@URL,"); strSql.Append("SyncIntervalHours=@SyncIntervalHours,"); strSql.Append("Enabled=@Enabled"); //strSql.Append(" where "); SqlParameter[] parameters = { new SqlParameter("@ClientID", SqlDbType.NVarChar, 255), new SqlParameter("@URL", SqlDbType.NVarChar, 255), new SqlParameter("@SyncIntervalHours", SqlDbType.Int, 4), new SqlParameter("@Enabled", SqlDbType.Bit, 1) }; parameters[0].Value = model.ClientID; parameters[1].Value = model.URL; parameters[2].Value = model.SyncIntervalHours; parameters[3].Value = model.Enabled; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(LPWeb.Model.Company_EasyMortgage model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Company_EasyMortgage("); strSql.Append("ClientID,URL,SyncIntervalHours,Enabled)"); strSql.Append(" values ("); strSql.Append("@ClientID,@URL,@SyncIntervalHours,@Enabled)"); SqlParameter[] parameters = { new SqlParameter("@ClientID", SqlDbType.NVarChar, 255), new SqlParameter("@URL", SqlDbType.NVarChar, 255), new SqlParameter("@SyncIntervalHours", SqlDbType.Int, 4), new SqlParameter("@Enabled", SqlDbType.Bit, 1) }; parameters[0].Value = model.ClientID; parameters[1].Value = model.URL; parameters[2].Value = model.SyncIntervalHours; parameters[3].Value = model.Enabled; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public LPWeb.Model.Company_EasyMortgage GetModel() { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ClientID,URL,SyncIntervalHours,Enabled from Company_EasyMortgage "); //strSql.Append(" where "); SqlParameter[] parameters = { }; LPWeb.Model.Company_EasyMortgage model = new LPWeb.Model.Company_EasyMortgage(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { model.ClientID = ds.Tables[0].Rows[0]["ClientID"].ToString(); model.URL = ds.Tables[0].Rows[0]["URL"].ToString(); if (ds.Tables[0].Rows[0]["SyncIntervalHours"].ToString() != "") { model.SyncIntervalHours = int.Parse(ds.Tables[0].Rows[0]["SyncIntervalHours"].ToString()); } if (ds.Tables[0].Rows[0]["Enabled"].ToString() != "") { if ((ds.Tables[0].Rows[0]["Enabled"].ToString() == "1") || (ds.Tables[0].Rows[0]["Enabled"].ToString().ToLower() == "true")) { model.Enabled = true; } else { model.Enabled = false; } } return(model); } else { return(null); } }