/// <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));
}
