/// <summary>
/// 插入
/// </summary>
/// <param name="tm"></param>
/// <returns></returns>
//public int inserttm(tiaominfo tm)
//{
// return tmDLL.insert_tm_DLL(tm);
//}
//public DataTable selectCurrentTM(tiaominfo tm)
//{
// return tmDLL.selectTMID_DLL(tm);
//}
/// <summary>
/// 更新作品条目表的排序列
/// </summary>
/// <param name="tm"></param>
/// <param name="tuoz"></param>
public void updatetmPaixuline(tiaominfo tm, string[] tuoz)
{
int a = tmDLL.select_for_updatexulie(tm);
int b = a;
for (int i = 0; i < tuoz.Length - 1; i++)
{
tmDLL.update_paixu_DLL(Convert.ToInt32(tuoz[i]) - b + 1, a);
a++;
}
}
/// <summary>
/// 选择条目id
/// </summary>
/// <param name="tm"></param>
/// <returns></returns>
//public DataTable selectTMID_DLL(Model.tiaominfo tm)
//{
// SqlParameter[] parmer = new SqlParameter[] {
// new SqlParameter("@作品ID",SqlDbType.Int)
// };
// parmer[0].Value = tm.zuopId;
// return DB.getDataTable(cs, "选择_条目表", parmer);
//}
public int inserttm(tiaominfo tm)
{
SqlParameter[] parmers = new SqlParameter[] {
new SqlParameter("@taskID", SqlDbType.NVarChar, 12),
new SqlParameter("@oldName", SqlDbType.NVarChar, 100),
new SqlParameter("@newName", SqlDbType.NVarChar, 100),
new SqlParameter("@category", SqlDbType.NVarChar, 100),
new SqlParameter("@path1", SqlDbType.NVarChar, 300),
new SqlParameter("@path2", SqlDbType.NVarChar, 300),
new SqlParameter("@sort", SqlDbType.NVarChar, 12)
};
parmers[0].Value = tm.zuopId;
parmers[1].Value = tm.oldname;
parmers[2].Value = tm.newname;
parmers[3].Value = tm.leixing;
parmers[4].Value = tm.lujing1;
parmers[5].Value = tm.lujing2;
parmers[6].Value = tm.paixu;
return(DB.ExecuteNonQuery(cs, "insertItem", parmers));
}
/// <summary>
/// 插入条目表
/// </summary>
/// <param name="tm"></param>
public int insertItem(tiaominfo tm)
{
return(tmDLL.inserttm(tm));
}
