public static DataTable JHViewdataBydwbm(string dwbm) { string str = string.Format("select * from View_BasAsset4 where DWBM='{0}'", dwbm); DataTable dt = DBUnity.AdapterToTab(str); return(dt); }
public static Print_State GetPrint_StateByPtintID(int ptintID) { string sql = "SELECT * FROM Print_State WHERE PtintID = @PtintID"; try { SqlParameter para = new SqlParameter("@PtintID", ptintID); DataTable dt = DBUnity.AdapterToTab(sql, para); if (dt.Rows.Count > 0) { Print_State print_State = new Print_State(); print_State.PtintID = dt.Rows[0]["PtintID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PtintID"]; print_State.PrintBH = dt.Rows[0]["PrintBH"] == DBNull.Value ? "" : (string)dt.Rows[0]["PrintBH"]; print_State.PrintState = dt.Rows[0]["PrintState"] == DBNull.Value ? "" : (string)dt.Rows[0]["PrintState"]; print_State.PrintTimes = dt.Rows[0]["PrintTimes"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PrintTimes"]; return(print_State); } else { return(null); } } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static DataTable GetDepDt(string dwbm) { string sql = string.Format("select VCDEPTCODE as DepID,VCDEPTNAME as DepName from BASDEPTCODE where UNITCODE='{0}' and VCDEPTNAME!='系统维护部'", dwbm); DataTable dt = DBUnity.AdapterToTab(sql); return(dt); }
public static DataTable JHDataTableBydwbmdep(string dwbm, string depcode) { DataTable dt = null; string sql = string.Format("select * from View_BasAsset4 where DWBM ='{0}' and SYGLBM='{1}' ORDER BY RZRQ DESC ", dwbm, depcode); dt = DBUnity.AdapterToTab(sql); return(dt); }
public static DataTable JHDataTableBystrdwbm(string listassid, string tt, string dwbm) { DataTable dt = null; string sql = string.Format("select * from View_BasAsset4 where DWBM='{2}' and KPBH in ({0}) and MC='{1}'", listassid, tt, dwbm); dt = DBUnity.AdapterToTab(sql); return(dt); }
public static DataTable JHAllDataTableByDWBM(string re, string dwbm) { DataTable dt = null; string sql = String.Format("select * from View_BasAsset4 where (KPBH in ({0})) and DWBM='{1}'", re, dwbm); dt = DBUnity.AdapterToTab(sql); return(dt); }
private static DataTable GetPrint_StateBySql(string sql, params SqlParameter[] values) { try { DataTable dt = DBUnity.AdapterToTab(sql, values); return(dt); } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
private static DataTable GetPrint_StateBySql(string safeSql) { try { DataTable dt = DBUnity.AdapterToTab(safeSql); return(dt); } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
/// <summary> /// 分页方法 /// </summary> /// <param name="sqlStr"></param> /// <param name="PageIndex"></param> /// <param name="PageSize"></param> /// <returns></returns> public static DataTable GetAspNetPager(string sqlStr, int PageIndex, int PageSize) { int startRecord = PageIndex * PageSize; return(DBUnity.AdapterToTab(sqlStr, startRecord, PageSize)); }