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