/// <summary> /// 取得客戶名稱清單 /// </summary> /// <returns></returns> public IEnumerable <CustomerName> GetCustomerNameList() { var sqlCmd = "SELECT Name FROM Customer"; var result = DapperHelper.QueryCollection <CustomerName>(AppSettingConfig.ConnectionString(), CommandType.Text, sqlCmd); return(result); }
/// <summary> /// 初始化服务总线(使用WCF服务) /// </summary> public static void InitializeRemoteBus() { bizbus = new RemoteBizBus(); RemoteBizBus rbizbus = bizbus as RemoteBizBus; string configuri = AppSettingConfig.getRemoteUriPath() + "Config"; string configPath = AppSettingConfig.getLocalConfigPath(); BasicHttpBinding bhb = new BasicHttpBinding("BasicHttpBinding_Service"); EndpointAddress epa = new EndpointAddress(configuri); IHostConfig hostconfig = ChannelFactory <IHostConfig> .CreateChannel(bhb, epa); XmlDocument doc = new XmlDocument(); if (string.IsNullOrEmpty(configPath)) { string configstring = hostconfig.GetConfigString(); doc.LoadXml(configstring); } //else //{ // string file = AppDomain.CurrentDomain.BaseDirectory + @"\namespace DrectSoft.FrameWork.Config"; // doc.Load(file); //} List <ServicePackageInfo> packages = ConfigLoader.GetPackageList(doc.DocumentElement); rbizbus.packages = packages; }
/// <summary> /// 自动注入配置文件(调用方法前,需要将配置信息注入IConfiguration中) /// </summary> /// <param name="services"></param> /// <param name="configuration"></param> /// <param name="appSettingConfig">默认更改或者读取的文件配置,如果不设置,则默认读取根目录的appsettings.json</param> /// <param name="isCompleteName">是否输入完整的类名,默认:false,为true时则需要输入命名空间+类名</param> /// <param name="action"></param> /// <param name="errConfigAction">配置信息错误回调</param> /// <returns></returns> public static IServiceCollection AddAutoConfig(this IServiceCollection services, IConfiguration configuration, AppSettingConfig appSettingConfig, bool isCompleteName = false, Action <ConfigAutoRegister> action = null, Action <string> errConfigAction = null) { Load(); ConfigAutoRegister configAutoRegisterExt = new ConfigAutoRegister(); if (action == null) { configAutoRegisterExt.AddSingletonConfig(services, configuration, isCompleteName, errConfigAction); configAutoRegisterExt.AddScopedConfig(services, isCompleteName, errConfigAction); configAutoRegisterExt.AddTransientConfig(services, isCompleteName, errConfigAction); } else { action.Invoke(configAutoRegisterExt); } if (appSettingConfig == null) { appSettingConfig = new AppSettingConfig() { DefaultPath = "appsettings.json" }; } services.AddTransient(provider => appSettingConfig); services.AddTransient(typeof(IWritableOptions <>), typeof(WritableOptions <>)); return(services); }
/// <summary> /// 新增加工程序 /// </summary> /// <param name="processSequenceDetails"></param> /// <returns></returns> public List <int> InsertProcessSequence(List <ProcessSequenceDetail> processSequenceDetails) { string sqlCmd = @" INSERT INTO [dbo].[ProcessSequence] ([FabricID] ,[FactoryID] ,[ProcessItem] ,[Loss] ,[WorkPay] ,[Order] ,[Group]) OUTPUT INSERTED.SequenceNo VALUES (@FabricID ,@FactoryID ,@ProcessItem ,@Loss ,@WorkPay ,@Order ,@Group)"; List <int> sequenceNoList = new List <int>(); foreach (var item in processSequenceDetails) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@FabricID", SqlDbType.Int) { Value = item.FabricID }, new SqlParameter("@FactoryID", SqlDbType.Int) { Value = item.FactoryID }, new SqlParameter("@ProcessItem", SqlDbType.TinyInt) { Value = item.ProcessItem }, new SqlParameter("@Loss", SqlDbType.Decimal) { Value = item.Loss }, new SqlParameter("@WorkPay", SqlDbType.SmallInt) { Value = item.WorkPay }, new SqlParameter("@Order", SqlDbType.TinyInt) { Value = item.Order }, new SqlParameter("@Group", SqlDbType.TinyInt) { Value = item.Group } }; sequenceNoList.Add(DapperHelper.Query <int>(AppSettingConfig.ConnectionString(), CommandType.Text, sqlCmd, parameters)); } return(sequenceNoList); }
/// <summary> /// 更新客戶布種單價 /// </summary> /// <returns></returns> public int UpdateCustomerTextilePrice(CustomerCheckBillSheet selectedCustomerCheckBillSheet, int updateCustomerPrice) { string sql = @"UPDATE dbo.CustomerTextilePrice SET Price = @Price WHERE AccountCustomerID = @AccountCustomerID AND AccountTextileID = @AccountTextileID"; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@AccountCustomerID", SqlDbType.NChar) { Value = selectedCustomerCheckBillSheet.C_01 }, new SqlParameter("@AccountTextileID", SqlDbType.Int) { Value = selectedCustomerCheckBillSheet.AccountTextileID }, new SqlParameter("@Price", SqlDbType.Int) { Value = updateCustomerPrice } }; var result = DapperHelper.ExecuteParameter(AppSettingConfig.ConnectionString(), CommandType.Text, sql, parameters); return(result); }
public void CreateExcelFile <T>(CreateExcelAction <T> createExcelAction, List <T> list, ExcelFormat excelFormat) { //建立Excel 2003檔案 IWorkbook wb = new XSSFWorkbook(); ISheet ws = wb.CreateSheet("Class"); XSSFRow row = (XSSFRow)ws.CreateRow(0); row.Height = 440; ICellStyle positionStyle = wb.CreateCellStyle(); positionStyle.WrapText = true; positionStyle.Alignment = NPOI.SS.UserModel.HorizontalAlignment.Center; positionStyle.VerticalAlignment = NPOI.SS.UserModel.VerticalAlignment.Center; foreach (var item in excelFormat.ColumnFormats) { ws.SetColumnWidth(excelFormat.ColumnFormats.IndexOf(item), item.CoiumnWidth); CreateCell(row, excelFormat.ColumnFormats.IndexOf(item), item.ColumnTitle, positionStyle); } int rowIndex = 1; foreach (var storeData in list) { createExcelAction(wb, ws, positionStyle, ref rowIndex, storeData); } FileStream file = new FileStream(string.Concat(AppSettingConfig.FilePath(), @"\", excelFormat.FileName, DateTime.Now.ToString("yyyyMMdd"), ".xlsx"), FileMode.Create);//產生檔案 wb.Write(file); file.Close(); }
/// <summary> /// 取得所有紗商的紗價 /// </summary> /// <returns></returns> public IEnumerable <MerchantYarnPrice> GetMerchantYarnPriceList() { string sqlCmd = @"SELECT * FROM YarnPrice"; var result = DapperHelper.QueryCollection <MerchantYarnPrice>(AppSettingConfig.ConnectionString(), CommandType.Text, sqlCmd); return(result); }
private IWorkbook workbook = null; //新建IWorkbook對象 public NewProcessOrderPage() { InitializeComponent(); string fileName = string.Concat(AppSettingConfig.ProcessOrderFilePath(), AppSettingConfig.ProcessOrderFileName()); try { FileStream fileStream = new FileStream(fileName, FileMode.Open, FileAccess.Read); workbook = new XSSFWorkbook(fileStream); //xlsx數據讀入workbook var processOrderSheet = new List <string>(); for (int sheetCount = 0; sheetCount < workbook.NumberOfSheets; sheetCount++) { ISheet sheet = workbook.GetSheetAt(sheetCount); //獲取第i個工作表 if (!sheet.SheetName.Contains("HY")) { continue; } processOrderSheet.Add(sheet.SheetName); } ComboBoxProcessOrderSheet.ItemsSource = processOrderSheet; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public IEnumerable <TrashItem> GetTrashItems() { var sqlCmd = "SELECT * FROM ITEM.dbf"; var result = DapperHelper.QueryDbfCollection <TrashItem>(AppSettingConfig.DbfConnectionString(), CommandType.Text, sqlCmd); return(result); }
//var sqlCmd = @"update ProcessOrderFlowDate // set InputDate = @InputDate, // UpdateDate = GETDATE() // where OrderFlowNo = @OrderFlowNo and OrderColorDetailNo in @OrderColorDetailNo"; //var parameter = // new // { // OrderColorDetailNo = orderColorDetailNoList, // InputDate = date, // OrderFlowNo = orderFlowNo // }; public void UpdateProductName(string v) { string sqlCmd = @"SELECT * from ITEM.dbf WHERE I_03 Like '%*%'";//@"UPDATE ITEM.dbf SET I_03=REPLACE(I_03,'*','X') WHERE I_03 LIKE '%*%'"; var result = DapperHelper.QueryDbfCollection <TrashItem>(AppSettingConfig.DbfConnectionString(), CommandType.Text, sqlCmd); var replace = result.Select(s => new TrashItem { I_03 = s.I_03.Replace("*", "X"), F_01 = s.F_01, I_01 = s.I_01 }); foreach (var item in replace) { string sqlCmd2 = @"UPDATE ITEM.dbf SET I_03=@I_03 WHERE F_01=@F_01 AND I_01=@I_01"; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@I_03", SqlDbType.NVarChar) { Value = item.I_03 }, new SqlParameter("@F_01", SqlDbType.NVarChar) { Value = item.F_01 }, new SqlParameter("@I_01", SqlDbType.NVarChar) { Value = item.I_01 }, }; var count = DapperHelper.QueryDbfCollection <int>(AppSettingConfig.DbfConnectionString(), CommandType.Text, sqlCmd2, parameters); } }
/// <summary> /// 取得客戶出貨紀錄 /// </summary> /// <param name="customerName"></param> /// <param name="customerDatePickerBegin"></param> /// <param name="customerDatePickerEnd"></param> /// <returns></returns> public IEnumerable <TrashCustomerShipped> GetCustomerShippedList(string customerName, DateTime customerDatePickerBegin, DateTime customerDatePickerEnd) { string sqlCmd = ""; if (string.IsNullOrEmpty(customerName)) { sqlCmd = string.Concat(@"SELECT DISTINCT cust.C_Name,invosub.IN_DATE,invosub.I_01,item.I_03,invosub.QUANTITY FROM (CUST.dbf AS cust INNER JOIN INVOSUB.dbf AS invosub ON cust.CARD_NO = invosub.C_01) INNER JOIN ITEM.dbf AS item ON invosub.I_01 = ITEM.I_01 AND invosub.F_01 = ITEM.F_01 WHERE invosub.IN_DATE Between cDate('" + customerDatePickerBegin.ToString() + "') and cDate('" + customerDatePickerEnd.ToString() + "')"); } else { sqlCmd = @"SELECT DISTINCT cust.C_Name,invosub.IN_DATE,invosub.I_01,item.I_03,invosub.QUANTITY FROM (CUST.dbf AS cust INNER JOIN INVOSUB.dbf AS invosub ON cust.CARD_NO = invosub.C_01) INNER JOIN ITEM.dbf AS item ON invosub.I_01 = ITEM.I_01 AND invosub.F_01 = ITEM.F_01 WHERE cust.C_NAME = '" + customerName + "' AND invosub.IN_DATE Between cDate('" + customerDatePickerBegin.ToString() + "') and cDate('" + customerDatePickerEnd.ToString() + "')"; } //SqlParameter[] parameters = new SqlParameter[] //{ // new SqlParameter("@CustomerName", SqlDbType.NVarChar) { Value = customerName }, //}; var result = DapperHelper.QueryDbfCollection <TrashCustomerShipped>(AppSettingConfig.DbfConnectionString(), CommandType.Text, sqlCmd); return(result); }
/// <summary> /// 取得客戶清單 /// </summary> public IEnumerable <TrashCustomer> GetCustomerList() { var sqlCmd = @"SELECT CARD_NO,C_NAME FROM CUST.dbf"; var result = DapperHelper.QueryDbfCollection <TrashCustomer>(AppSettingConfig.DbfConnectionString(), CommandType.Text, sqlCmd); return(result); }
private static void InitExcelHandlers() { // 指定的多个带有controller的assembly的名称 string handlerAssemblies = AppSettingConfig.GetSetting("ExcelHandlerAssemblies", ""); //"Wanda.HR.KPI.Web.Common"; _excelHandlers = new Dictionary <string, ExcelCategoryHandler>(); string[] assemblyArray = handlerAssemblies.Split(",;".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); List <Type> handlerTypes = new List <Type>(); foreach (var assembly in assemblyArray) { var types = (from t in Assembly.Load(assembly).GetTypes() where IsSubClassOf(t, typeof(ExcelCategoryHandler)) select t).ToList(); handlerTypes.AddRange(types); } foreach (Type type in handlerTypes) { string typeName = type.Name.ToLower(); // todo alias ExcelCategoryHandler handler = (ExcelCategoryHandler)Activator.CreateInstance(type); _excelHandlers.Add(typeName, handler); } }
/// <summary> /// 修改加工程序,可修改工繳,損耗,順序 /// </summary> /// <param name="sequenceNo"></param> /// <param name="loss"></param> /// <param name="workPay"></param> /// <param name="order"></param> /// <returns></returns> public int EditProcessSequence(int sequenceNo, decimal loss, int workPay, int order) { var sqlCmd = @"UPDATE [dbo].[ProcessSequence] SET [Loss] = @Loss ,[WorkPay] = @WorkPay ,[Order] = @Order WHERE SequenceNo=@SequenceNo"; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@SequenceNo", SqlDbType.Int) { Value = sequenceNo }, new SqlParameter("@Loss", SqlDbType.Decimal) { Value = loss }, new SqlParameter("@WorkPay", SqlDbType.Int) { Value = workPay }, new SqlParameter("@Order", SqlDbType.Int) { Value = order } }; var result = DapperHelper.ExecuteParameter(AppSettingConfig.ConnectionString(), CommandType.Text, sqlCmd, parameters); return(result); }
/// <summary> /// 新增紗規格 /// </summary> /// <param name="yarnSpecification"></param> /// <returns></returns> public int AddYarnSpecification(YarnSpecification yarnSpecification) { string sqlCmd = @"INSERT INTO [dbo].[YarnSpecification] ([Ingredient],[YarnCount],[Color]) VALUES (@Ingredient,@YarnCount,@Color)"; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@Ingredient", SqlDbType.NVarChar) { Value = yarnSpecification.Ingredient }, new SqlParameter("@YarnCount", SqlDbType.NVarChar) { Value = yarnSpecification.YarnCount }, new SqlParameter("@Color", SqlDbType.NVarChar) { Value = yarnSpecification.Color } }; var result = DapperHelper.ExecuteParameter(AppSettingConfig.ConnectionString(), CommandType.Text, sqlCmd, parameters); return(result); }
public int UpdateProcessOrderFlowDate(List <ProcessOrderFlowFactoryName> processOrderFlow) { string sql = @"UPDATE ProcessOrderFlow SET InputDate = @InputDate,CompleteDate = @CompleteDate WHERE OrderDetailNo = @OrderDetailNo;"; var count = DapperHelper.Execute(AppSettingConfig.ConnectionString(), CommandType.Text, sql, processOrderFlow); return(count); }
/// <summary> /// 取得所有布種預設單價 /// </summary> /// <returns></returns> public IEnumerable <AccountTextile> GetAccountTextile() { string sql = @"SELECT * FROM AccountTextile;"; var result = DapperHelper.QueryCollection <AccountTextile>(AppSettingConfig.ConnectionString(), CommandType.Text, sql); return(result); }
private void ComboBoxSelectionChangedExecute() { string priviousTextile = SelectedTextile; TextileColorList = null; TextileList = null; RaisePropertyChanged("TextileColorList"); RaisePropertyChanged("TextileList"); List <string> textileList = new List <string>(); if (!_workbookDictionary.TryGetValue(FileName, out IWorkbook dictionaryWorkbook)) { string fileNamePath = string.Concat(AppSettingConfig.InventoryHistoryRecordFilePath(), "/", FileName); Tuple <List <string>, IWorkbook> tuple = ExcelModule.GetExcelWorkbook(fileNamePath); TextileList = tuple.Item1; GetShippingDate(tuple.Item2.GetSheetAt(1)); _workbookDictionary.Add(FileName, tuple.Item2); } else { for (int sheetCount = 1; sheetCount < dictionaryWorkbook.NumberOfSheets; sheetCount++) { ISheet sheet = dictionaryWorkbook.GetSheetAt(sheetCount); //獲取第i個工作表 textileList.Add(sheet.SheetName); } TextileList = textileList; GetShippingDate(dictionaryWorkbook.GetSheetAt(1)); } RaisePropertyChanged("TextileList"); SelectedTextile = priviousTextile; RaisePropertyChanged("SelectedTextile"); }
public int NewProcessOrderFlow(ProcessOrderFlow processOrderFlow, IEnumerable <int> orderColorDetailNo) { var sqlCmd = @"INSERT INTO ProcessOrderFlow OUTPUT inserted.OrderDetailNo VALUES (@OrderNo,@FactoryID);"; SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@OrderNo", SqlDbType.Int) { Value = processOrderFlow.OrderNo }, new SqlParameter("@FactoryID", SqlDbType.Int) { Value = processOrderFlow.FactoryID } }; var orderDetailNo = DapperHelper.Query <int>(AppSettingConfig.ConnectionString(), CommandType.Text, sqlCmd, parameter); var cmd = @"INSERT INTO ProcessOrderFlowDate VALUES(@OrderColorDetailNo,@OrderDetailNo,null,null,GETDATE());"; var parameters = orderColorDetailNo.Select(s => new { OrderColorDetailNo = s, OrderDetailNo = orderDetailNo, }); var count = DapperHelper.Execute(AppSettingConfig.ConnectionString(), CommandType.Text, cmd, parameters); return(count); }
/// <summary> /// 取得布種清單 /// </summary> /// <returns></returns> public IEnumerable <Fabric> GetFabricList() { string sqlCmd = "SELECT * FROM Fabric"; var result = DapperHelper.QueryCollection <Fabric>(AppSettingConfig.ConnectionString(), CommandType.Text, sqlCmd); return(result); }
public int UpdateProcessOrderColorDetailStatusByLastComplete(int orderFlowNo, IEnumerable <int> orderColorDetailNoList) { var sqlCmd = @" DECLARE @lastOrderFlowNo INT SELECT TOP 1 @lastOrderFlowNo = OrderFlowNo FROM ProcessOrderFlowDate WHERE OrderColorDetailNo = @OrderColorDetailNo ORDER BY OrderFlowNo DESC IF(@lastOrderFlowNo = @OrderFlowNo) begin UPDATE ProcessOrderColorDetail SET Status = 5, UpdateDate = GETDATE() WHERE OrderColorDetailNo IN @OrderColorDetailNoList end"; var parameter = new { OrderColorDetailNo = orderColorDetailNoList.First(), OrderFlowNo = orderFlowNo, OrderColorDetailNoList = orderColorDetailNoList }; var count = DapperHelper.Execute(AppSettingConfig.ConnectionString(), CommandType.Text, sqlCmd, parameter); return(count); }
/// <summary> /// 得到配置 /// </summary> /// <param name="appSettingConfig"></param> /// <returns></returns> private AppSettingConfig GetAppSettingConfig(AppSettingConfig appSettingConfig) { var settingConfig = appSettingConfig ?? new AppSettingConfig(); settingConfig.Maps = SafeList(settingConfig.Maps); settingConfig.DefaultPath = settingConfig.DefaultPath.SafeString(); return(settingConfig); }
public int InsertProcessOrderFlowDate(List <ProcessOrderFlowDate> proecessOrderFlowDateList) { string sql = @"INSERT INTO ProcessOrderFlowDate VALUES (@OrderColorDetailNo,@OrderFlowNo,@InputDate,@CompleteDate,@UpdateDate);"; return(DapperHelper.Execute(AppSettingConfig.ConnectionString(), CommandType.Text, sql, proecessOrderFlowDateList)); }
static void Main() { // Add the event handler for handling UI thread exceptions to the event. Application.ThreadException += new ThreadExceptionEventHandler(Application_ThreadException); // Set the unhandled exception mode to force all Windows Forms errors to go through our handler. Application.SetUnhandledExceptionMode(UnhandledExceptionMode.CatchException); // Add the event handler for handling non-UI thread exceptions to the event. AppDomain.CurrentDomain.UnhandledException += new UnhandledExceptionEventHandler(CurrentDomain_UnhandledException); Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); //get config file Shop currentShop = null; const string appSettingPath = "Config/AppSetting.config"; if (File.Exists(appSettingPath)) { AppSettingConfig appSettingConfig = XmlUtil.Deserialize <AppSettingConfig>(appSettingPath); ConstantValuePool.BizSettingConfig = appSettingConfig; ShopService shopService = new ShopService(); currentShop = shopService.GetCurrentShop(appSettingConfig.IPAddress, appSettingConfig.Port); } if (currentShop != null && !string.IsNullOrEmpty(currentShop.ShopNo)) { ConstantValuePool.CurrentShop = currentShop; //Check for registration int remainDays = 0; if (true) //(ProductRegister.CheckProductRegistration(ref remainDays)) { Application.Run(new FormLogin()); } else { string strVersion = string.Empty; Assembly executingAssembly = Assembly.GetExecutingAssembly(); object[] objectAttrs = executingAssembly.GetCustomAttributes(typeof(AssemblyFileVersionAttribute), false); if (objectAttrs.Length > 0) { AssemblyFileVersionAttribute fileAttr = objectAttrs[0] as AssemblyFileVersionAttribute; if (fileAttr != null) { strVersion = fileAttr.Version; } } FormProductTry formTry = new FormProductTry(remainDays, currentShop.ShopName, currentShop.ShopNo, strVersion); formTry.ShowDialog(); if (formTry.Result) { Application.Run(new FormLogin()); } } } else { MessageBox.Show("找不到有效的服务端程序,请检查服务是否启动或者配置是否正确。", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); Application.Run(new FormConfig()); } }
private static List <Message> GetAllSuccess() { IConfigurationRoot root = AppSettingConfig.GetAppSettingConfig(); var errors = root.GetSection("SystemMessages"); string filePath = errors["JsonSuccessPath"].ToLower(); string json = File.ReadAllText(filePath); return(JsonConvert.DeserializeObject <List <Message> >(json)); }
/// <summary> /// 取得工廠編號 /// </summary> /// <param name="FactoryName"></param> /// <returns></returns> public IEnumerable <FactoryIdentity> GetFactoryIdentiys(string[] FactoryNameString) { var sqlCmd = "SELECT FactoryID,Name FROM Factory WHERE Name IN @Name"; var parameter = (new { Name = FactoryNameString }); //var y = (new { Name = new[] { "強金利", "祥玉" } }); var result = DapperHelper.QueryCollection <FactoryIdentity, object>(AppSettingConfig.ConnectionString(), CommandType.Text, sqlCmd, parameter); return(result); }
/// <summary> /// 新增工廠清單 /// </summary> /// <param name="factory"></param> /// <returns></returns> public int InsertFactory(Factory factory) { var sqlCmd = @"INSERT INTO [dbo].[Factory] VALUES (@Name,@PhoneNumber,@CellPhone,@Fax,@Process,@Address,@Sort)"; var result = DapperHelper.Execute(AppSettingConfig.ConnectionString(), CommandType.Text, sqlCmd, factory); return(result); }
public int InsertProcessOrderFlow(List <ProcessOrderFlow> processOrderFlow) { string sql = @"INSERT INTO ProcessOrderFlow VALUES (@OrderNo,@FactoryID);"; var result = DapperHelper.Execute(AppSettingConfig.ConnectionString(), CommandType.Text, sql, processOrderFlow); return(result); }
/// <summary> /// 新增布種 /// </summary> /// <param name="fabric"></param> /// <returns></returns> public int AddFabric(Fabric fabric) { var sqlCmd = @"INSERT INTO [dbo].[Fabric] VALUES (@FabricName,@AverageUnitPrice,@AverageCost,@UpdateDate)"; var result = DapperHelper.Execute(AppSettingConfig.ConnectionString(), CommandType.Text, sqlCmd, fabric); return(result); }
/// <summary> /// 依據多個加工訂單顏色明細編號號取得工廠直送清單 /// </summary> /// <param name="processOrderColorDetailNo"></param> /// <returns></returns> public IEnumerable <FactoryShippingName> GetFactoryShippingNameList(IEnumerable <int> processOrderColorDetailNo) { var sqlCmd = @"select fs.ShippingNo,fs.OrderColorDetailNo,c.Name,fs.Quantity,fs.CreateDate,fs.ShippingDate from FactoryShipping fs inner join Customer c on c.CustomerID = fs.CustomerID where OrderColorDetailNo IN @OrderColorDetailNo"; var parameter = (new { OrderColorDetailNo = processOrderColorDetailNo }); return(DapperHelper.QueryCollection <FactoryShippingName, object>(AppSettingConfig.ConnectionString(), CommandType.Text, sqlCmd, parameter)); }