/// <summary> /// 得到一个对象实体 /// </summary> public db.Model.todo DataRowToModel(DataRow row) { db.Model.todo model = new db.Model.todo(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["dateValue"] != null && row["dateValue"].ToString() != "") { model.dateValue = DateTime.Parse(row["dateValue"].ToString()); } if (row["deadDate"] != null && row["deadDate"].ToString() != "") { model.deadDate = DateTime.Parse(row["deadDate"].ToString()); } if (row["content"] != null) { model.content = row["content"].ToString(); } if (row["importantStar"] != null && row["importantStar"].ToString() != "") { model.importantStar = int.Parse(row["importantStar"].ToString()); } if (row["urgencyStar"] != null && row["urgencyStar"].ToString() != "") { model.urgencyStar = int.Parse(row["urgencyStar"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(db.Model.todo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update todo set "); if (model.dateValue != null) { strSql.Append("dateValue='" + model.dateValue + "',"); } else { strSql.Append("dateValue= null ,"); } if (model.deadDate != null) { strSql.Append("deadDate='" + model.deadDate + "',"); } else { strSql.Append("deadDate= null ,"); } if (model.content != null) { strSql.Append("content='" + model.content + "',"); } else { strSql.Append("content= null ,"); } if (model.importantStar != null) { strSql.Append("importantStar=" + model.importantStar + ","); } else { strSql.Append("importantStar= null ,"); } if (model.urgencyStar != null) { strSql.Append("urgencyStar=" + model.urgencyStar + ","); } else { strSql.Append("urgencyStar= null ,"); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where ID=" + model.ID + ""); int rowsAffected = DbHelperOleDb.ExecuteSql(strSql.ToString()); if (rowsAffected > 0) { return(true); } else { return(false); } }
private void Ele_MouseDoubleClick(object sender, MouseButtonEventArgs e) { db.Model.todo model = new db.Model.todo(); model.content = "test"; model.dateValue = DateTime.Now; model.deadDate = DateTime.Now; model.importantStar = 5; model.urgencyStar = 5; db.BLL.todo bll = new db.BLL.todo(); if (bll.Add(model)) { MessageBox.Show("添加完成"); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(db.Model.todo model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.dateValue != null) { strSql1.Append("dateValue,"); strSql2.Append("'" + model.dateValue + "',"); } if (model.deadDate != null) { strSql1.Append("deadDate,"); strSql2.Append("'" + model.deadDate + "',"); } if (model.content != null) { strSql1.Append("content,"); strSql2.Append("'" + model.content + "',"); } if (model.importantStar != null) { strSql1.Append("importantStar,"); strSql2.Append("" + model.importantStar + ","); } if (model.urgencyStar != null) { strSql1.Append("urgencyStar,"); strSql2.Append("" + model.urgencyStar + ","); } strSql.Append("insert into todo("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); int rows = DbHelperOleDb.ExecuteSql(strSql.ToString()); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public db.Model.todo GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append(" ID,dateValue,deadDate,content,importantStar,urgencyStar "); strSql.Append(" from todo "); strSql.Append(" where ID=" + ID + ""); db.Model.todo model = new db.Model.todo(); DataSet ds = DbHelperOleDb.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }