public List <SubInvoiceInfo> GetListByCriteria(SubInvoiceInfo query) { List <SubInvoiceInfo> result = new List <SubInvoiceInfo>(); CustomDataCommand dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("GetSubInvoiceList"); using (DynamicQuerySqlBuilder sqlBuilder = new DynamicQuerySqlBuilder( dataCommand.CommandText, dataCommand, null, "SysNo")) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "SOSysNo", DbType.Int32, "@SOSysNo", QueryConditionOperatorType.Equal, query.SOSysNo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "WarehouseNo", DbType.Int32, "@WarehouseNo", QueryConditionOperatorType.Equal, query.StockSysNo); dataCommand.CommandText = sqlBuilder.BuildQuerySql(); result = dataCommand.ExecuteEntityList <SubInvoiceInfo>((r, s) => { string masterProductSysNoStr = r["MasterProductSysNoStr"].ToString(); if (!string.IsNullOrEmpty(masterProductSysNoStr)) { s.MasterProductSysNo = masterProductSysNoStr .Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries) .ToList().ConvertAll(sysNoStr => int.Parse(sysNoStr)); } }, true, true); } return(result); }
public SubInvoiceInfo Create(SubInvoiceInfo entity) { DataCommand command = DataCommandManager.GetDataCommand("InsertSubInvoice"); command.SetParameterValue("@SOSysNo", entity.SOSysNo); command.SetParameterValue("@StockSysNo", entity.StockSysNo); command.SetParameterValue("@InvoiceSeq", entity.InvoiceSeq); command.SetParameterValue("@ProductSysNo", entity.ProductSysNo); command.SetParameterValue("@SplitQty", entity.SplitQty); command.SetParameterValue("@CompanyCode", entity.CompanyCode); command.SetParameterValue("@IsExtendWarrantyItem", entity.IsExtendWarrantyItem); string masterProductSysNoStr = ""; if (entity.MasterProductSysNo != null && entity.MasterProductSysNo.Count > 0) { for (int i = 0; i < entity.MasterProductSysNo.Count; i++) { masterProductSysNoStr += entity.MasterProductSysNo[i] + (i < entity.MasterProductSysNo.Count - 1 ? "," : ""); } } command.SetParameterValue("@MasterProductSysNo", masterProductSysNoStr); entity.SysNo = Convert.ToInt32(command.ExecuteScalar()); return(LoadBySysNo(entity.SysNo.Value)); }
public virtual List <SubInvoiceInfo> GetListByCriteria(SubInvoiceInfo query) { return(m_SubInvoiceDA.GetListByCriteria(query)); }