摘要： System.Data.DataTable dt = NewTable();SqlDatabase db = new SqlDatabase(); //声明数据库连接 SqlConnection conn = new SqlConnection(db.CreateConnection().ConnectionString); conn.Open(); //声明SqlBulkCopy ,using释... 阅读全文

摘要： alter PROCEDURE DelTem@authorName varchar(200)asdeclare @StockInID varchar(200)begin insert into StockIn select distinct StreamLineID,WareHouseID,SupplyID,0 as 'state',@authorName from StockInDetailT... 阅读全文

摘要： public System.Data.DataTable GetExcelData(string excelFilePath) { try { Excel.Application app = new Excel.Application(); Excel.Sheets sheets; Excel.Workbook workbook; System.Data.DataTable dt = new Sy... 阅读全文

摘要： if (DateTime.TryParse(txtInDate.Text, out inDate))database.AddInParameter(cmd, "@InDate", DbType.String, inDate); elsedatabase.AddInParameter(cmd, "@InDate", DbType.DateTime, DBNull.Value); 阅读全文

摘要： 代码 阅读全文