/// <summary> /// 增加一条数据 /// </summary> public void Add(ERM.MDL.Settings model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.AppTitle != null) { strSql1.Append("AppTitle,"); strSql2.Append("'" + model.AppTitle + "',"); } if (model.defaultTempID != null) { strSql1.Append("defaultTempID,"); strSql2.Append("" + model.defaultTempID + ","); } if (model.ID != null) { strSql1.Append("ID,"); strSql2.Append("" + model.ID + ","); } if (model.port != null) { strSql1.Append("port,"); strSql2.Append("'" + model.port + "',"); } if (model.PromptTitle != null) { strSql1.Append("PromptTitle,"); strSql2.Append("'" + model.PromptTitle + "',"); } if (model.ServerAddr != null) { strSql1.Append("ServerAddr,"); strSql2.Append("'" + model.ServerAddr + "',"); } if (model.timeout != null) { strSql1.Append("timeout,"); strSql2.Append("" + model.timeout + ","); } if (model.UserTitle != null) { strSql1.Append("UserTitle,"); strSql2.Append("'" + model.UserTitle + "',"); } if (model.Ver != null) { strSql1.Append("Ver,"); strSql2.Append("'" + model.Ver + "',"); } strSql.Append("insert into Settings("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); DbHelperOleDb.ExecuteSql(strSql.ToString()); }
/// <summary> /// 获得设置 /// </summary> /// <returns></returns> public ERM.MDL.T_Settings GetSetting() { string sql = "select top 1 * from Settings"; DataSet ds = DbHelperOleDb.Query(sql); ERM.MDL.Settings model = new ERM.MDL.Settings(); model.AppTitle = ds.Tables[0].Rows[0]["AppTitle"].ToString(); model.PromptTitle = ds.Tables[0].Rows[0]["PromptTitle"].ToString(); model.UserTitle = ds.Tables[0].Rows[0]["UserTitle"].ToString(); model.UserTitle2 = ds.Tables[0].Rows[0]["UserTitle2"].ToString(); return(model); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(ERM.MDL.Settings model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Settings set "); strSql.Append("AppTitle='" + model.AppTitle + "',"); strSql.Append("defaultTempID=" + model.defaultTempID + ","); strSql.Append("ID=" + model.ID + ","); strSql.Append("port='" + model.port + "',"); strSql.Append("PromptTitle='" + model.PromptTitle + "',"); strSql.Append("ServerAddr='" + model.ServerAddr + "',"); strSql.Append("timeout=" + model.timeout + ","); strSql.Append("UserTitle='" + model.UserTitle + "',"); strSql.Append("Ver='" + model.Ver + "'"); strSql.Append(" where ID=" + model.ID + " "); DbHelperOleDb.ExecuteSql(strSql.ToString()); }
/// <summary> /// 得到一个对象实体 /// </summary> public ERM.MDL.Settings Find(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append(" AppTitle,defaultTempID,ID,port,PromptTitle,ServerAddr,timeout,UserTitle,Ver "); strSql.Append(" from Settings "); strSql.Append(" where ID=" + ID + " "); ERM.MDL.Settings model = new ERM.MDL.Settings(); DataSet ds = DbHelperOleDb.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { model.AppTitle = ds.Tables[0].Rows[0]["AppTitle"].ToString(); if (ds.Tables[0].Rows[0]["defaultTempID"].ToString() != "") { model.defaultTempID = int.Parse(ds.Tables[0].Rows[0]["defaultTempID"].ToString()); } if (ds.Tables[0].Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } model.port = ds.Tables[0].Rows[0]["port"].ToString(); model.PromptTitle = ds.Tables[0].Rows[0]["PromptTitle"].ToString(); model.ServerAddr = ds.Tables[0].Rows[0]["ServerAddr"].ToString(); if (ds.Tables[0].Rows[0]["timeout"].ToString() != "") { model.timeout = int.Parse(ds.Tables[0].Rows[0]["timeout"].ToString()); } model.UserTitle = ds.Tables[0].Rows[0]["UserTitle"].ToString(); model.Ver = ds.Tables[0].Rows[0]["Ver"].ToString(); return(model); } else { return(null); } }