/// <summary>
/// 更新taskinfo 通过taskid
/// </summary>
/// <returns></returns>
public int updateTaskInfo(Model.zuopinfo zuop)
{
try
{
SqlParameter[] parmers = new SqlParameter[] {
new SqlParameter("@taskName", SqlDbType.NVarChar, 100),
new SqlParameter("@remark", SqlDbType.NVarChar),
new SqlParameter("@category", SqlDbType.NVarChar, 50),
new SqlParameter("@time", SqlDbType.NVarChar, 13),
new SqlParameter("themeID", SqlDbType.Int),
new SqlParameter("taskID", SqlDbType.Int)
};
parmers[0].Value = zuop.zuopName;
parmers[1].Value = zuop.zuopbeizhu;
parmers[2].Value = zuop.leibie;
parmers[3].Value = zuop.shijain;
parmers[4].Value = zuop.huodId;
parmers[5].Value = zuop.zuopId;
int a = Convert.ToInt32(DB.ExecuteNonQuery(cs, "updateTask", parmers));
if (a == 1)
{
return(zuop.zuopId);
}
return(0);
}catch (Exception ex) {
return(0);
}
}
/// <summary>
/// 删除作品
/// </summary>
/// <param name="zp"></param>
/// <returns></returns>
public int delectzuopin_DLL(Model.zuopinfo zp)
{
SqlParameter[] parme = new SqlParameter[] {
new SqlParameter("@taskID", SqlDbType.Int),
};
parme[0].Value = zp.zuopId;
return(DB.ExecuteNonQuery(cs, "deleteTask", parme));
}
/// <summary>
/// 编辑作品
/// </summary>
/// <param name="zuop"></param>
/// <returns></returns>
public int getupdatezuop_DLL(Model.zuopinfo zuop)
{
try
{
SqlParameter[] editzuop_zx = new SqlParameter[] {
new SqlParameter("@taskID", SqlDbType.Int),
new SqlParameter("@taskName", SqlDbType.NVarChar, 100),
new SqlParameter("@remark", SqlDbType.NVarChar),
};
editzuop_zx[0].Value = zuop.zuopId;
editzuop_zx[1].Value = zuop.zuopName;
editzuop_zx[2].Value = zuop.zuopbeizhu;
int a = DB.ExecuteNonQuery(cs, "editTask", editzuop_zx);
return(a);
}catch (Exception ex) {
return(0);
}
}
/// <summary>
/// 创建作品
/// </summary>
/// <param name="zuop"></param>
/// <returns></returns>
public int insertzuopin_DLL(Model.zuopinfo zuop)
{
try
{
SqlParameter[] parmers = new SqlParameter[] {
new SqlParameter("@taskName", SqlDbType.NVarChar, 100),
new SqlParameter("@remark", SqlDbType.NVarChar),
new SqlParameter("@category", SqlDbType.NVarChar, 50),
new SqlParameter("@time", SqlDbType.NVarChar, 13),
new SqlParameter("themeID", SqlDbType.Int),
};
parmers[0].Value = zuop.zuopName;
parmers[1].Value = zuop.zuopbeizhu;
parmers[2].Value = zuop.leibie;
parmers[3].Value = zuop.shijain;
parmers[4].Value = zuop.huodId;
int a = Convert.ToInt32(DB.ExecuteScalar(cs, "createTask", parmers));
return(a);
}catch (Exception ex) {
return(0);
}
}
