private static List <V_INOUTSTOCK> DoQuery(string sql_str) { List <V_INOUTSTOCK> rtn = new List <V_INOUTSTOCK>(); DBHelper_Sqlserver DBHelper_Sqlserver = new DBHelper_Sqlserver(); try { using (IDataReader dr = DBHelper_Sqlserver.ExecuteReader(sql_str)) { while (dr.Read()) { var p = new V_INOUTSTOCK(); #region 逐个赋值 p.WAREHOUSENO = DBHelper_Sqlserver.GetDataValue <string>(dr, "WAREHOUSENO"); p.CONTAINERNO = DBHelper_Sqlserver.GetDataValue <string>(dr, "CONTAINERNO"); p.TASKTYPE = DBHelper_Sqlserver.GetDataValue <string>(dr, "TASKTYPE"); p.SOURCEPLACE = DBHelper_Sqlserver.GetDataValue <string>(dr, "SOURCEPLACE"); p.TOPLACE = DBHelper_Sqlserver.GetDataValue <string>(dr, "TOPLACE"); p.UPDATEUSER = DBHelper_Sqlserver.GetDataValue <string>(dr, "UPDATEUSER"); p.UPDATETIME = DBHelper_Sqlserver.GetDataValue <string>(dr, "UPDATETIME"); p.TASKCONTENTSTRING = DBHelper_Sqlserver.GetDataValue <string>(dr, "TASKCONTENTSTRING"); #endregion rtn.Add(p); } } } catch { } return(rtn); }
/// <summary> /// 路桥的数据库备份 /// </summary> /// <param name="bkFileName"></param> /// <returns></returns> public static bool BackUpForDB(string bkFileName) { if (System.IO.File.Exists(bkFileName)) { System.IO.File.Delete(bkFileName); } string sqltxt = @"BACKUP DATABASE [ASRS_VOLVO] TO Disk='" + bkFileName + "'"; DBHelper_Sqlserver dbh = new DBHelper_Sqlserver(); int val = dbh.ExecuteNonQuery(sqltxt); if (val > 0) { return(true); } else { return(false); } }