/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.ScriptInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ScriptInfo set "); strSql.Append("RecordID=@RecordID,"); strSql.Append("ScriptName=@ScriptName,"); strSql.Append("ScriptDetails=@ScriptDetails"); strSql.Append(" where "); SQLiteParameter[] parameters = { new SQLiteParameter("@RecordID", DbType.Int32, 8), new SQLiteParameter("@ScriptName", DbType.String), new SQLiteParameter("@ScriptDetails", DbType.String) }; parameters[0].Value = model.RecordID; parameters[1].Value = model.ScriptName; parameters[2].Value = model.ScriptDetails; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.ScriptInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ScriptInfo("); strSql.Append("RecordID,ScriptName,ScriptDetails)"); strSql.Append(" values ("); strSql.Append("@RecordID,@ScriptName,@ScriptDetails)"); SQLiteParameter[] parameters = { new SQLiteParameter("@RecordID", DbType.Int32, 8), new SQLiteParameter("@ScriptName", DbType.String), new SQLiteParameter("@ScriptDetails", DbType.String) }; parameters[0].Value = model.RecordID; parameters[1].Value = model.ScriptName; parameters[2].Value = model.ScriptDetails; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.ScriptInfo DataRowToModel(DataRow row) { Model.ScriptInfo model = new Model.ScriptInfo(); if (row != null) { if (row["RecordID"] != null && row["RecordID"].ToString() != "") { model.RecordID = int.Parse(row["RecordID"].ToString()); } if (row["ScriptName"] != null) { model.ScriptName = row["ScriptName"].ToString(); } if (row["ScriptDetails"] != null) { model.ScriptDetails = row["ScriptDetails"].ToString(); } } return(model); }
/// <summary> /// 保存脚本 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_Save_r_Click(object sender, EventArgs e) { if (!new DynamicInvoke().ReCompiler(txt_Details_r.Text.Trim("\r\n").Trim())) { return; } Model.ScriptInfo sc; if ((sc = scriptList.Find(i => i.ScriptName == txt_FileName_r.Text.Trim("\r\n").Trim())) != null) { sc.ScriptDetails = txt_Details_r.Text; scriptBll.Update(sc); } else { sc = new Model.ScriptInfo(); sc.ScriptName = txt_FileName_r.Text.Trim("\r\n").Trim(); sc.ScriptDetails = txt_Details_r.Text.Trim("\r\n").Trim(); scriptList.Add(sc); scriptBll.Add(sc); cmb_Choose_c.DataSource = scriptList.Select(i => i.ScriptName).ToArray(); } MessageBox.Show("保存完毕"); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.ScriptInfo GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select RecordID,ScriptName,ScriptDetails from ScriptInfo "); strSql.Append(" where "); SQLiteParameter[] parameters = { }; Model.ScriptInfo model = new Model.ScriptInfo(); DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }