/// <summary> /// 更新一条数据 /// </summary> public bool Update(ERPWPF.Model.Log model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Log set "); strSql.Append("LOperation=@LOperation,"); strSql.Append("Luser=@Luser,"); strSql.Append("LTime=@LTime"); strSql.Append(" where Lid=@Lid "); SQLiteParameter[] parameters = { new SQLiteParameter("@LOperation", DbType.String), new SQLiteParameter("@Luser", DbType.String), new SQLiteParameter("@LTime", DbType.String), new SQLiteParameter("@Lid", DbType.Int32, 8) }; parameters[0].Value = model.LOperation; parameters[1].Value = model.Luser; parameters[2].Value = model.LTime; parameters[3].Value = model.Lid; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(ERPWPF.Model.Log model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Log("); strSql.Append("Lid,LOperation,Luser,LTime)"); strSql.Append(" values ("); strSql.Append("@Lid,@LOperation,@Luser,@LTime)"); SQLiteParameter[] parameters = { new SQLiteParameter("@Lid", DbType.Int32, 8), new SQLiteParameter("@LOperation", DbType.String), new SQLiteParameter("@Luser", DbType.String), new SQLiteParameter("@LTime", DbType.String) }; parameters[0].Value = model.Lid; parameters[1].Value = model.LOperation; parameters[2].Value = model.Luser; parameters[3].Value = model.LTime; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ERPWPF.Model.Log DataRowToModel(DataRow row) { ERPWPF.Model.Log model = new ERPWPF.Model.Log(); if (row != null) { if (row["Lid"] != null && row["Lid"].ToString() != "") { model.Lid = int.Parse(row["Lid"].ToString()); } if (row["LOperation"] != null) { model.LOperation = row["LOperation"].ToString(); } if (row["Luser"] != null) { model.Luser = row["Luser"].ToString(); } if (row["LTime"] != null) { model.LTime = row["LTime"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public ERPWPF.Model.Log GetModel(int Lid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select Lid,LOperation,Luser,LTime from Log "); strSql.Append(" where Lid=@Lid "); SQLiteParameter[] parameters = { new SQLiteParameter("@Lid", DbType.Int32, 8) }; parameters[0].Value = Lid; ERPWPF.Model.Log model = new ERPWPF.Model.Log(); DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }