protected override List <object> GetDataSource()
{
List <PurchaseItemRecord> items = null;
if (SearchCondition == null)
{
items = new PurchaseOrderBLL(AppSettings.Current.ConnStr).GetRecords(null).QueryObjects;
}
else
{
items = new PurchaseOrderBLL(AppSettings.Current.ConnStr).GetRecords(SearchCondition).QueryObjects;
}
return((from item in items
orderby item.SheetNo ascending
select(object) item).ToList());
}
private void BindSupplier()
{
try
{
List <EntitySupplierMaster> lstOther = new PurchaseOrderBLL().GetSupplierList();
lstOther.Insert(0, new EntitySupplierMaster()
{
PKId = 0, SupplierName = "--Select--"
});
ddlSupplier.DataSource = lstOther;
ddlSupplier.DataValueField = "PKId";
ddlSupplier.DataTextField = "SupplierName";
ddlSupplier.DataBind();
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
}
public void Execute(IJobExecutionContext context)
{
IPurchaseOrderBLL orderBll = new PurchaseOrderBLL();
List <Order> orderList = null;
DateTime dateTimeM = DateTime.Now;
FlashLogger.Error(string.Format("下载采购订单【{0}】", System.Threading.Thread.CurrentThread.ManagedThreadId));
while (dateTimeM > Convert.ToDateTime("2016-03-01"))
{
var listEntity = orderBll.GetOrders(TimeHelper.GetStartDateTime(dateTimeM),
TimeHelper.GetEndDateTime(dateTimeM), "1");
if (listEntity == null)
{
break;
}
orderList = listEntity.DataList;
if (orderList != null && orderList.Count > 0)
{
for (int i = 1; i <= listEntity.TotalPageCount; i++)
{
orderBll.AddOrders(orderList);
FlashLogger.Warn(string.Format("{0} : 第{1}页/共{2}页 成功下载 {3} 条采购订单信息.【{4}】", dateTimeM.ToString("yyyy-MM-dd"),
i, listEntity.TotalPageCount, orderList.Count, System.Threading.Thread.CurrentThread.ManagedThreadId));
orderList = orderBll.GetOrders(TimeHelper.GetStartDateTime(dateTimeM),
TimeHelper.GetEndDateTime(dateTimeM), (i + 1).ToString()).DataList;
}
}
//else
//{
// FlashLogger.Warn(string.Format("{0} : 无采购订单信息.【{1}】", dateTimeM.ToString("yyyy-MM-dd"),
// System.Threading.Thread.CurrentThread.ManagedThreadId));
//}
dateTimeM = dateTimeM.AddDays(-1);
//System.Threading.Thread.Sleep(3000);
}
FlashLogger.Error(string.Format("采购订单下载完毕【{0}】", System.Threading.Thread.CurrentThread.ManagedThreadId));
//测试
}
private void btnNullify_Click(object sender, EventArgs e)
{
PurchaseOrderBLL processor = new PurchaseOrderBLL(AppSettings.Current.ConnStr);
PerformOperation <PurchaseOrder>(processor, SheetOperation.Nullify);
}
private void btnSave_Click(object sender, EventArgs e)
{
PurchaseOrderBLL processor = new PurchaseOrderBLL(AppSettings.Current.ConnStr);
PerformOperation <PurchaseOrder>(processor, IsAdding ? SheetOperation.Create : SheetOperation.Modify);
}
// insert using SqlBulkCopy
private void ImportExcel(string file, string type)
{
DataTable dt = new DataTable();
string tableName = "";
if (type == "po")
{
tableName = "tmpPurchaseOrder";
dt = GetPurchaseOrderExcel(file);
PurchaseOrderBLL.deleteAllTmpPurchaseOrder();
}
else
{
tableName = "tmpForecastOrder";
dt = GetForecastOrderExcel(file);
ForecastOrderBLL.deleteAllTmpForecastOrder();
}
if (dt.Rows.Count > 0)
{
try
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString))
{
con.Open();
using (SqlBulkCopy copy = new SqlBulkCopy(con))
{
int columnCount = dt.Columns.Count;
for (int i = 0; i < columnCount; i++)
{
copy.ColumnMappings.Add(i, i);
}
copy.DestinationTableName = tableName;
copy.WriteToServer(dt);
}
con.Close();
}
System.Windows.Forms.MessageBox.Show("資料匯入完畢，共匯入 " + dt.Rows.Count + " 筆資料", "Message");
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show("檔案匯入資料庫失敗", "Message");
}
finally
{
dt = null;
}
}
else
{
}
if (type == "po")
{
// This T-SQL do :
// 1.Copy tmp data to real table, tmpPurchaseOrder => PurchaseOrder
// 2.Insert new customer, sales, product
PurchaseOrderBLL.updateBasicDataByPo();
SetCustomerDg1();
}
else
{
// This T-SQL do :
// 1.copy tmp data to real table, tmpForecastOrder => ForecastOrder
// 2.insert new customer, sales
ForecastOrderBLL.updateBasicDataByFo();
SetCustomerDg2();
}
}
