/// <summary> /// 更新一条数据 /// </summary> public bool Update(ProjectModify model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update projectmodify set "); strSql.Append("PROJECTID=@PROJECTID,"); strSql.Append("FOLDERNAME=@FOLDERNAME,"); strSql.Append("FOLDERFULLNAME=@FOLDERFULLNAME,"); strSql.Append("ISUPLOADATTACH=@ISUPLOADATTACH,"); strSql.Append("ISFINISHED=@ISFINISHED,"); strSql.Append("REVIEWSTATUS=@REVIEWSTATUS,"); strSql.Append("createdate=@createdate"); strSql.Append(" where ID=@ID "); MySqlParameter[] parameters = { new MySqlParameter("@PROJECTID", MySqlDbType.VarChar, 40), new MySqlParameter("@FOLDERNAME", MySqlDbType.VarChar, 200), new MySqlParameter("@FOLDERFULLNAME", MySqlDbType.VarChar, 400), new MySqlParameter("@ISUPLOADATTACH", MySqlDbType.Decimal, 1), new MySqlParameter("@ISFINISHED", MySqlDbType.Decimal, 1), new MySqlParameter("@REVIEWSTATUS", MySqlDbType.Decimal, 1), new MySqlParameter("@createdate", MySqlDbType.DateTime), new MySqlParameter("@ID", MySqlDbType.VarChar, 40) }; parameters[0].Value = model.PROJECTID; parameters[1].Value = model.FOLDERNAME; parameters[2].Value = model.FOLDERFULLNAME; parameters[3].Value = model.ISUPLOADATTACH; parameters[4].Value = model.ISFINISHED; parameters[5].Value = model.REVIEWSTATUS; parameters[6].Value = model.CREATEDATE; parameters[7].Value = model.ID; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ProjectModify DataRowToModel(DataRow row) { ProjectModify model = new ProjectModify(); if (row != null) { if (row["ID"] != null) { model.ID = row["ID"].ToString(); } if (row["PROJECTID"] != null) { model.PROJECTID = row["PROJECTID"].ToString(); } if (row["FOLDERNAME"] != null) { model.FOLDERNAME = row["FOLDERNAME"].ToString(); } if (row["FOLDERFULLNAME"] != null) { model.FOLDERFULLNAME = row["FOLDERFULLNAME"].ToString(); } if (row["ISUPLOADATTACH"] != null && row["ISUPLOADATTACH"].ToString() != "") { model.ISUPLOADATTACH = decimal.Parse(row["ISUPLOADATTACH"].ToString()); } if (row["ISFINISHED"] != null && row["ISFINISHED"].ToString() != "") { model.ISFINISHED = decimal.Parse(row["ISFINISHED"].ToString()); } if (row["REVIEWSTATUS"] != null && row["REVIEWSTATUS"].ToString() != "") { model.REVIEWSTATUS = decimal.Parse(row["REVIEWSTATUS"].ToString()); } if (row["CREATEDATE"] != null && row["CREATEDATE"].ToString() != "") { model.CREATEDATE = DateTime.Parse(row["CREATEDATE"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(ProjectModify model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into projectmodify("); strSql.Append("ID,PROJECTID,FOLDERNAME,FOLDERFULLNAME,ISUPLOADATTACH,ISFINISHED,REVIEWSTATUS,createdate)"); strSql.Append(" values ("); strSql.Append("@ID,@PROJECTID,@FOLDERNAME,@FOLDERFULLNAME,@ISUPLOADATTACH,@ISFINISHED,@REVIEWSTATUS,@createdate)"); MySqlParameter[] parameters = { new MySqlParameter("@ID", MySqlDbType.VarChar, 40), new MySqlParameter("@PROJECTID", MySqlDbType.VarChar, 40), new MySqlParameter("@FOLDERNAME", MySqlDbType.VarChar, 200), new MySqlParameter("@FOLDERFULLNAME", MySqlDbType.VarChar, 400), new MySqlParameter("@ISUPLOADATTACH", MySqlDbType.Decimal, 1), new MySqlParameter("@ISFINISHED", MySqlDbType.Decimal, 1), new MySqlParameter("@REVIEWSTATUS", MySqlDbType.Decimal, 1), new MySqlParameter("@createdate", MySqlDbType.DateTime) }; parameters[0].Value = model.ID; parameters[1].Value = model.PROJECTID; parameters[2].Value = model.FOLDERNAME; parameters[3].Value = model.FOLDERFULLNAME; parameters[4].Value = model.ISUPLOADATTACH; parameters[5].Value = model.ISFINISHED; parameters[6].Value = model.REVIEWSTATUS; parameters[7].Value = model.CREATEDATE; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ProjectModify GetModel(string ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,PROJECTID,FOLDERNAME,FOLDERFULLNAME,ISUPLOADATTACH,ISFINISHED,REVIEWSTATUS,createdate from projectmodify "); strSql.Append(" where ID=@ID "); MySqlParameter[] parameters = { new MySqlParameter("@ID", MySqlDbType.VarChar, 40) }; parameters[0].Value = ID; ProjectModify model = new ProjectModify(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ProjectModify model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(ProjectModify model) { return(dal.Add(model)); }