private void FormMain_Load(object sender, EventArgs e) { List <ConStrInfo> lstConStr = new List <ConStrInfo>(); var dao = new ConStrDao(); DataTable dt = dao.GetList("").Tables[0]; foreach (DataRow dr in dt.Rows) { var tempItemp = new ConStrInfo() { ID = Convert.ToInt32(dr["ID"]), ConName = dr["ConName"].ToString(), ConStrContent = dr["ConStrContent"].ToString() }; lstConStr.Add(tempItemp); cbDatabase.Items.Add(tempItemp); } cbDatabase.DisplayMember = "ConName"; cbDatabase.ValueMember = "ID"; cbDatabase.SelectedIndex = 0; DicConStr = lstConStr.ToDictionary(m => m.ID, m => m); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ConStrInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ConStr set "); strSql.Append("ConName=@ConName,"); strSql.Append("ConStrContent=@ConStrContent"); strSql.Append(" where ID=@ID"); OleDbParameter[] parameters = { new OleDbParameter("@ConName", OleDbType.VarChar, 255), new OleDbParameter("@ConStrContent", OleDbType.VarChar, 0), new OleDbParameter("@ID", OleDbType.Integer, 4) }; parameters[0].Value = model.ConName; parameters[1].Value = model.ConStrContent; parameters[2].Value = model.ID; int rows = AccessHelper.ExecuteNonQuery(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(ConStrInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ConStr("); strSql.Append("ConName,ConStrContent)"); strSql.Append(" values ("); strSql.Append("@ConName,@ConStrContent)"); OleDbParameter[] parameters = { new OleDbParameter("@ConName", OleDbType.VarChar, 255), new OleDbParameter("@ConStrContent", OleDbType.VarChar, 0) }; parameters[0].Value = model.ConName; parameters[1].Value = model.ConStrContent; int rows = AccessHelper.ExecuteNonQuery(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ConStrInfo DataRowToModel(DataRow row) { ConStrInfo model = new ConStrInfo(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["ConName"] != null) { model.ConName = row["ConName"].ToString(); } if (row["ConStrContent"] != null) { model.ConStrContent = row["ConStrContent"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public ConStrInfo GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,ConName,ConStrContent from ConStr "); strSql.Append(" where ID=@ID"); OleDbParameter[] parameters = { new OleDbParameter("@ID", OleDbType.Integer, 4) }; parameters[0].Value = ID; ConStrInfo model = new ConStrInfo(); DataSet ds = AccessHelper.ExecuteDataSet(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }