public void AddModel(QccustomerlibraryModel model, DbTransaction tran) { //model.CreateTime = System.DateTime.Now; QccustomerlibraryTable table = new QccustomerlibraryTable(); InsertSqlSection insertSql = DataAccess.DefaultDB.Insert(table); if (tran != null) { insertSql.SetTransaction(tran); } int iden = DataAccess.DefaultDB.CustomSql("select QCCUSTOMERLIBRARYIDEN.nextval from dual").ToScalar <int>(); insertSql.AddColumn(table.QualityCode, model.QualityCode) .AddColumn(table.BuyerId, model.BuyerId) .AddColumn(table.Brand, model.Brand) .AddColumn(table.CustomerQualityId, model.CustomerQualityId) .AddColumn(table.Sales, model.Sales) .AddColumn(table.SalesGroup, model.SalesGroup) .AddColumn(table.MillComments, model.MillComments) .AddColumn(table.IsFirstOwner, model.IsFirstOwner) .AddColumn(table.CreateDate, model.CreateDate) .AddColumn(table.Creator, model.Creator) .AddColumn(table.Iden, iden) .Execute(); }
//public QC_HF_ChangeLogModelList GetModelListByAttC(QC_HF_ChangeLogModel model) //{ // QC_HF_ChangeLogTable table = new QC_HF_ChangeLogTable(); // SelectSqlSection sql = DataAccess.DefaultDB.Select(table, table.AllColumns()); // sql.Where(table.Sourcing == model.Sourcing) // .Where(table.MaterialGroup == model.MaterialGroup); // sql.Where(table.AfGmmm == model.AfGmmm); // sql.Where(table.BfGmmm == model.BfGmmm); // if (!string.IsNullOrEmpty(model.Status)) // { // sql.Where(table.Status == model.Status); // } // if (model.DyeMethod == "") // { // sql.Where(table.DyeMethod == null || table.DyeMethod == "" || table.DyeMethod == " "); // } // else // { // sql.Where(table.DyeMethod == model.DyeMethod); // } // if (model.Pattern == "") // { // sql.Where(table.Pattern == null || table.Pattern == "" || table.Pattern == " "); // } // else // { // sql.Where(table.Pattern == model.Pattern); // } // if (model.ShrinkageTestingMethod == "") // { // sql.Where(table.ShrinkageTestingMethod == null || table.ShrinkageTestingMethod == "" || table.ShrinkageTestingMethod == " "); // } // else // { // sql.Where(table.ShrinkageTestingMethod == model.ShrinkageTestingMethod); // } // if (model.GmtWashing == "") // { // sql.Where(table.GmtWashing == null || table.GmtWashing == "" || table.GmtWashing == " "); // } // else // { // sql.Where(table.GmtWashing == model.GmtWashing); // } // if (model.Shrinkage == "") // { // sql.Where(table.Shrinkage == null || table.Shrinkage == "" || table.Shrinkage == " "); // } // else // { // sql.Where(table.Shrinkage == model.Shrinkage); // } // using (SafeDataReader sdr = new SafeDataReader(sql.ToDataReader())) // { // QC_HF_ChangeLogModelList result = new QC_HF_ChangeLogModelList(); // while (sdr.Read()) // { // QC_HF_ChangeLogModel m = new QC_HF_ChangeLogModel(); // m.QualityCode = sdr.GetString(table.QUALITY_CODE); // result.Add(m); // } // return result; // } //} //public QC_HF_ChangeLogModelList GetModelListOne(QC_HF_ChangeLogModel model) //{ // string Sql1 = "SELECT * " + // " FROM (SELECT ROWNUM as Items, E.* " + // " FROM (SELECT DISTINCT A.* " + // " FROM QC_HF_ChangeLog A " + // " LEFT JOIN QCConstructionDtl B " + // " ON A.Quality_Code = B.Quality_Code " + // " LEFT JOIN QCFinishDtl C " + // " ON A.Quality_COde = C.Quality_Code " + // " LEFT JOIN QCCustomerLibrary D " + // " ON D.Quality_Code = A.Quality_Code " + // " LEFT JOIN QCCustomerLibrary F " + // " ON F.Quality_Code=A.Quality_Code " + // " where @Condition order by A.Quality_Code asc ) E) " + // " WHERE @PageSize"; // //"select CUSTOMER_CD||'<|>'||NAME as CU from gen_customer where (CUSTOMER_CD like (UPPER(@Name)||'%') or NAME like (UPPER(@Name)||'%') ) and rownum<51 order by NAME asc" // string Sql2 = " SELECT count( DISTINCT A.Quality_Code) " + // " FROM QC_HF_ChangeLog A " + // " LEFT JOIN QCConstructionDtl B " + // " ON A.Quality_Code = B.Quality_Code " + // " LEFT JOIN QCFinishDtl C " + // " ON A.Quality_COde = C.Quality_Code " + // " LEFT JOIN QCCustomerLibrary D " + // " ON D.Quality_Code = A.Quality_Code " + // " LEFT JOIN QCCustomerLibrary F " + // " ON F.Quality_Code=A.Quality_Code where @Condition order by A.Quality_Code asc"; // int flag = 0; // // SelectSqlSection sql = DataAccess.DefaultDB.Select(table, table.AllColumns().Distinct); // // 添加查询条件 // StringBuilder sb = new StringBuilder(""); // if (model.Pattern != "" && model.Pattern != null) // { // sb.Append("UPPER(A.Pattern)=@Pattern"); // flag++; // } // if (model.CreateDate != null && model.CreateDate != DateTime.MinValue) // { // if (flag == 0) // sb.Append("A.Create_Date>=@CreateTime"); // else // sb.Append(" and A.Create_Date>=@CreateTime"); // flag++; // } // if (model.Creator != "" && model.Creator != null) // { // if (flag == 0) // sb.Append("upper(A.Creator)=@Creator"); // else // sb.Append("and upper(A.Creator)=@Creator"); // flag++; // } // if (model.BfGmmm != null && model.BfGmmm != 0) // { // if (flag == 0) sb.Append("A.BF_GMMM=@BfGmmm"); // else // sb.Append(" and A.BF_GMMM=@BfGmmm"); // flag++; // } // if (model.AfGmmm != null && model.AfGmmm != 0) // { // if (flag == 0) // sb.Append("A.AF_GMMM=@AfGmmm"); // else // sb.Append(" and A.AF_GMMM=@AfGmmm"); // flag++; // } // if (model.Status != "" && model.Status != null) // { // if (flag == 0) // sb.Append("UPPER(A.Status)=@Status"); // else // sb.Append(" and UPPER(A.Status)=@Status"); // flag++; // } // if (model.CustomerQaulityId != "" && model.CustomerQaulityId != null) // { // if (flag == 0) // sb.Append("UPPER(F.Customer_Quality_ID)=@CustomerQualityId"); // else // sb.Append(" and UPPER(F.Customer_Quality_ID)=@CustomerQualityId"); // flag++; // } // if (model.Sourcing != "" && model.Sourcing != null) // { // if (flag == 0) // sb.Append("UPPER(A.Sourcing)=@Sourcing"); // else // sb.Append(" and UPPER(A.Sourcing)=@Sourcing"); // flag++; // } // if (model.MaterialGroup != "" && model.MaterialGroup != null) // { // if (flag == 0) // sb.Append("UPPER(A.Material_Group)=@MaterialGroup"); // else // sb.Append(" and UPPER(A.Material_Group)=@MaterialGroup"); // flag++; // } // if (model.QualityCode != "" && model.QualityCode != null) // { // if (flag == 0) // sb.Append("UPPER(A.Quality_Code)=@QualityCode"); // else // sb.Append(" and UPPER(A.Quality_Code)=@QualityCode"); // flag++; // } // if (model.DyeMethod != "" && model.DyeMethod != null) // { // if (flag == 0) // sb.Append("UPPER(A.Dye_Method)=@DyeMethod"); // else // sb.Append(" and UPPER(A.Dye_Method)=@DyeMethod"); // flag++; // } // if (model.Sales != "" && model.Sales != null) // { // if (flag == 0) // sb.Append("upper(D.Sales)=@Salesed"); // else // sb.Append(" and upper(D.Sales)=@Salesed"); // flag++; // } // if (model.SalesTeam != "" && model.SalesTeam != null) // { // if (flag == 0) // sb.Append("UPPER(D.Sales_Group)=@SalesTeam"); // else // sb.Append(" and UPPER(D.Sales_Group)=@SalesTeam"); // flag++; // } // if (model.Construction != "" && model.Construction != null) // { // if (flag == 0) // sb.Append("UPPER(B.Construction)=@Construction"); // else // sb.Append(" and UPPER(B.Construction)=@Construction"); // flag++; // } // if (model.Finishing != "" && model.Finishing != null) // { // if (flag == 0) // sb.Append("UPPER(C.Finishing_Code)=@Finishing"); // else // sb.Append(" and UPPER(C.Finishing_Code)=@Finishing"); // flag++; // } // // 添加对customer条件的判断 by LYH 2014/2/25 // if (model.CustomerCode != "" && model.CustomerCode != null) // { // if (flag == 0) // sb.Append("UPPER(D.BUYER_ID) = @CustomerCode"); // else // sb.Append(" and UPPER(D.BUYER_ID) = @CustomerCode"); // flag++; // } // QC_HF_ChangeLogModelList result = new QC_HF_ChangeLogModelList(); // if (flag == 0) // return result; // Sql1 = Sql1.Replace("@Condition", sb.ToString()); // Sql1 = Sql1.Replace("@PageSize", "Items>" + ((model.StartPage - 1) * model.PageSize) + " and Items<=" + (model.StartPage * model.PageSize)); // Sql2 = Sql2.Replace("@Condition", sb.ToString()); // CustomSqlSection csql1 = DataAccess.DefaultDB.CustomSql(Sql1); // CustomSqlSection csql2 = DataAccess.DefaultDB.CustomSql(Sql2); // // 对查询参数赋值 // string tempSql = sb.ToString(); // if (tempSql.Contains("@AfGmmm")) // { // csql1.AddInputParameter("AfGmmm", DbType.Int32, model.AfGmmm); // csql2.AddInputParameter("AfGmmm", DbType.Int32, model.AfGmmm); // } // if (tempSql.Contains("@CreateTime")) // { // csql1.AddInputParameter("CreateTime", DbType.DateTime, model.CreateDate); // csql2.AddInputParameter("CreateTime", DbType.DateTime, model.CreateDate); // } // if (tempSql.Contains("@BfGmmm")) // { // csql1.AddInputParameter("BfGmmm", DbType.Int32, model.BfGmmm); // csql2.AddInputParameter("BfGmmm", DbType.Int32, model.BfGmmm); // } // if (tempSql.Contains("@Pattern")) // { // csql1.AddInputParameter("Pattern", DbType.String, model.Pattern.ToUpper()); // csql2.AddInputParameter("Pattern", DbType.String, model.Pattern.ToUpper()); // } // if (tempSql.Contains("@Status")) // { // csql1.AddInputParameter("Status", DbType.String, model.Status.ToUpper()); // csql2.AddInputParameter("Status", DbType.String, model.Status.ToUpper()); // } // if (tempSql.Contains("@Sourcing")) // { // csql1.AddInputParameter("Sourcing", DbType.String, model.Sourcing.ToUpper()); // csql2.AddInputParameter("Sourcing", DbType.String, model.Sourcing.ToUpper()); // } // if (tempSql.Contains("@CustomerQualityId")) // { // csql1.AddInputParameter("CustomerQualityId", DbType.String, model.CustomerQaulityId.ToUpper()); // csql2.AddInputParameter("CustomerQualityId", DbType.String, model.CustomerQaulityId.ToUpper()); // } // if (tempSql.Contains("@MaterialGroup")) // { // csql1.AddInputParameter("MaterialGroup", DbType.String, model.MaterialGroup.ToUpper()); // csql2.AddInputParameter("MaterialGroup", DbType.String, model.MaterialGroup.ToUpper()); // } // if (tempSql.Contains("@QualityCode")) // { // csql1.AddInputParameter("QualityCode", DbType.String, model.QualityCode.ToUpper()); // csql2.AddInputParameter("QualityCode", DbType.String, model.QualityCode.ToUpper()); // } // if (tempSql.Contains("@Creator")) // { // csql1.AddInputParameter("Creator", DbType.String, model.Creator.ToUpper()); // csql2.AddInputParameter("Creator", DbType.String, model.Creator.ToUpper()); // } // if (tempSql.Contains("@DyeMethod")) // { // csql1.AddInputParameter("DyeMethod", DbType.String, model.DyeMethod.ToUpper()); // csql2.AddInputParameter("DyeMethod", DbType.String, model.DyeMethod.ToUpper()); // } // if (tempSql.Contains("@Salesed")) // { // csql1.AddInputParameter("Salesed", DbType.String, model.Sales.ToUpper()); // csql2.AddInputParameter("Salesed", DbType.String, model.Sales.ToUpper()); // } // if (tempSql.Contains("@SalesTeam")) // { // csql1.AddInputParameter("SalesTeam", DbType.String, model.SalesTeam.ToUpper()); // csql2.AddInputParameter("SalesTeam", DbType.String, model.SalesTeam.ToUpper()); // } // if (tempSql.Contains("@Construction")) // { // csql1.AddInputParameter("Construction", DbType.String, model.Construction.ToUpper()); // csql2.AddInputParameter("Construction", DbType.String, model.Construction.ToUpper()); // } // if (tempSql.Contains("@Finishing")) // { // csql1.AddInputParameter("Finishing", DbType.String, model.Finishing.ToUpper()); // csql2.AddInputParameter("Finishing", DbType.String, model.Finishing.ToUpper()); // } // // 添加对customer条件的判断 by LYH 2014/2/25 // if (tempSql.Contains("@CustomerCode")) // { // csql1.AddInputParameter("CustomerCode", DbType.String, model.CustomerCode.ToUpper()); // csql2.AddInputParameter("CustomerCode", DbType.String, model.CustomerCode.ToUpper()); // } // // int count = TableMapModel.SetRangeSql(ref sql, table, table.QualityCode, model.StartPage, model.PageSize, model.OrderByField); // int count = csql2.ToScalar<int>(); // QC_HF_ChangeLogTable table = new QC_HF_ChangeLogTable(); // QcconstructiondtlManager qcm = new QcconstructiondtlManager(); // QcfinishdtlManager qsm = new QcfinishdtlManager(); // QccustomerlibraryManager qlm = new QccustomerlibraryManager(); // QcconstructiondtlModelList qcml = new QcconstructiondtlModelList(); // QcfinishdtlModelList qsml = new QcfinishdtlModelList(); // QccustomerlibraryModelList qclm = new QccustomerlibraryModelList(); // QcavailablewidthModelList qsaw = new QcavailablewidthModelList(); // QcavailablewidthManager qcam = new QcavailablewidthManager(); // QcyarndtlManager qym = new QcyarndtlManager(); // QcyarndtlModelList qyml = new QcyarndtlModelList(); // DataSet ds; // CustomSqlSection css; // DataTable dt; // using (SafeDataReader sdr = new SafeDataReader(csql1.ToDataReader())) // { // while (sdr.Read()) // { // QC_HF_ChangeLogModel m = new QC_HF_ChangeLogModel(); // m.GridRowCount = count; // m.QualityCode = sdr.GetString(table.QualityCode); // qcml = qcm.GetModelListOne(new QcconstructiondtlModel() { QualityCode = m.QualityCode }); // for (int i = 0; i < qcml.Count; i++) // { // m.Construction = m.Construction + qcml[i].Construction + ";"; // } // qsml = qsm.GetModelListOne(new QcfinishdtlModel() { QualityCode = m.QualityCode }); // for (int i = 0; i < qsml.Count; i++) // { // m.Finishing = m.Finishing + qsml[i].FinishingCode + ";"; // } // qclm = qlm.GetModelList(new QccustomerlibraryModel() { QualityCode = m.QualityCode }); // for (int i = 0; i < qclm.Count; i++) // { // m.CustomerQualityId = m.CustomerQualityId + qclm[i].CustomerQualityId + ";"; // m.BuyserIds = m.BuyserIds + qclm[i].BuyerId + ";"; // m.Brank = m.Brank + qclm[i].Brand + ";"; // m.MillComments = m.MillComments + qclm[i].MillComments + ";"; // } // qsaw = qcam.GetModelList(new QcavailablewidthModel() { QualityCode = m.QualityCode }); // for (int i = 0; i < qsaw.Count; i++) // { // if (i != qsaw.Count - 1) // m.AvaWidth = m.AvaWidth + string.Format("{0}G{1}Inch/{2}N/{3}-{4}\"", qsaw[i].Gauge, qsaw[i].Diameter, qsaw[i].TotalNeedles, qsaw[i].Width, qsaw[i].MaxWidth) + "--"; // else // m.AvaWidth = m.AvaWidth + string.Format("{0}G{1}Inch/{2}N/{3}-{4}\"", qsaw[i].Gauge, qsaw[i].Diameter, qsaw[i].TotalNeedles, qsaw[i].Width, qsaw[i].MaxWidth); // } // qyml = qym.GetModelList(new QcyarndtlModel() { QualityCode = m.QualityCode }); // for (int i = 0; i < qyml.Count; i++) // { // if (i != qyml.Count - 1) // m.YarnInfo = m.YarnInfo + string.Format("{0}X{1} {2} {3}% {4}", qyml[i].YarnCount, qyml[i].Threads, qyml[i].YarnType, qyml[i].YarnRatio, qyml[i].YarnComponent) + "--"; // else // m.YarnInfo = m.YarnInfo + string.Format("{0}X{1} {2} {3}% {4}", qyml[i].YarnCount, qyml[i].Threads, qyml[i].YarnType, qyml[i].YarnRatio, qyml[i].YarnComponent); // } // //by mengjw 2015-08-04 // //原来 // //css= DataAccess.DefaultDB.CustomSql("SELECT distinct pi.ppo_no as PPO,pi.FABRIC_TYPE_CD "+ // // "FROM ppo_hd ph,gen_customer c,ppo_QC_HF_ChangeLog qc, ppo_item pi, fab_combo fc, ppo_qccomment qcc,ppo_item_combo pic,QC_HF_ChangeLog qm "+ // // " WHERE ph.ppo_no=pi.ppo_no and fc.fab_combo_id = qcc.fab_combo_id and qc.ppo_item_id=pi.ppo_item_id and pi.ppo_item_id=pic.ppo_item_id and pi.quality_code=qm.quality_code and "+ // // " pic.fab_combo_id=fc.fab_combo_id and qc.ppo_qc_id=qcc.ppo_qc_id and ph.customer_cd=c.customer_cd and qm.Status='Approved' and QCC.STATUS='Approved' and qm.quality_code=@QC "); // //改为 // css = DataAccess.DefaultDB.CustomSql("SELECT distinct pi.ppo_no as PPO,pi.FABRIC_TYPE_CD " + // "FROM ppo_hd ph,gen_customer c,ppo_QC_HF_ChangeLog qc, ppo_item pi, fab_combo fc, ppo_qccomment qcc,ppo_item_combo pic,QC_HF_ChangeLog qm " + // " WHERE ph.ppo_no=pi.ppo_no and fc.fab_combo_id = qcc.fab_combo_id and qc.ppo_item_id=pi.ppo_item_id and pi.ppo_item_id=pic.ppo_item_id and pi.quality_code=qm.quality_code and " + // " pic.fab_combo_id=fc.fab_combo_id and qc.ppo_qc_id=qcc.ppo_qc_id and ph.customer_cd=c.customer_cd and QCC.STATUS='Approved' and qm.quality_code=@QC and rownum<=1"); // css.AddInputParameter("QC", DbType.String, m.QualityCode); // ds = css.ToDataSet(); // dt = ds.Tables[0]; // for (int i = 0; i < dt.Rows.Count; i++) // { // m.ApprovedFromSPPO = m.ApprovedFromSPPO + dt.Rows[i]["PPO"].ToString() + "(" + dt.Rows[i]["FABRIC_TYPE_CD"].ToString() + ");"; // } // m.CreateDate = sdr.GetDateTime(table.CreateDate); // m.Creator = sdr.GetString(table.Creator); // m.ApproveDate = sdr.GetDateTime(table.ApproveDate); // m.Approver = sdr.GetString(table.Approver); // m.Status = sdr.GetString(table.Status); // if (m.Status == "NEW") // m.Status = "New"; // m.Sourcing = sdr.GetString(table.Sourcing); // m.MaterialGroup = sdr.GetString(table.MaterialGroup); // m.AnalysisNo = sdr.GetString(table.AnalysisNo); // m.RefQualityCode = sdr.GetString(table.RefQualityCode); // m.Pattern = sdr.GetString(table.Pattern); // m.DyeMethod = sdr.GetString(table.DyeMethod); // m.ReplaceBy = sdr.GetString(table.ReplaceBy); // m.Repeat = sdr.GetString(table.REPEAT); // m.BfGmmm = sdr.GetInt32(table.BfGmmm); // m.AfGmmm = sdr.GetInt32(table.AfGmmm); // m.Shrinkage = sdr.GetString(table.Shrinkage); // m.ShrinkageTestingMethod = sdr.GetString(table.ShrinkageTestingMethod); // m.GmtWashing = sdr.GetString(table.GmtWashing); // m.Layout = sdr.GetString(table.Layout); // m.YarnLength = sdr.GetString(table.YarnLength); // m.TappingType = sdr.GetString(table.TappingType); // m.Measurement = sdr.GetString(table.Measurement); // m.Remark = sdr.GetString(table.Remark); // m.SpecialType = sdr.GetString(table.SpecialType); // m.LastUpdateTime = sdr.GetDateTime(table.LastUpdateTime); // m.LastUpdateBy = sdr.GetString(table.LastUpdateBy); // m.GK_NO = sdr.GetString(table.GK_NO); // m.QC_Ref_PPO = sdr.GetString(table.QC_Ref_PPO); // m.HF_Ref_PPO = sdr.GetString(table.HF_Ref_PPO); // m.QC_Ref_GP = sdr.GetString(table.QC_Ref_GP); // m.HF_Ref_GP = sdr.GetString(table.HF_Ref_GP); // result.Add(m); // } // return result; // } //} public void AddModel(QC_HF_ChangeLogModel model, DbTransaction tran) { QC_HF_ChangeLogTable table = new QC_HF_ChangeLogTable(); InsertSqlSection insertSql = DataAccess.DefaultDB.Insert(table); if (tran != null) { insertSql.SetTransaction(tran); } int iden = DataAccess.DefaultDB.CustomSql("select SEQ_NO.nextval from dual").ToScalar <int>(); insertSql.AddColumn(table.QUALITY_CODE, model.QualityCode) .AddColumn(table.CREATE_DATE, model.CreateDate) .AddColumn(table.CREATOR, model.Creator) .AddColumn(table.QC_Ref_PPO_Old, model.QC_Ref_PPO_Old) .AddColumn(table.QC_Ref_GP_Old, model.QC_Ref_GP_Old) .AddColumn(table.HF_Ref_PPO_Old, model.HF_Ref_PPO_Old) .AddColumn(table.HF_Ref_GP_Old, model.HF_Ref_GP_Old) .AddColumn(table.QC_Ref_PPO_New, model.QC_Ref_PPO_New) .AddColumn(table.QC_Ref_GP_New, model.QC_Ref_GP_New) .AddColumn(table.HF_Ref_PPO_New, model.HF_Ref_PPO_New) .AddColumn(table.HF_Ref_GP_New, model.HF_Ref_GP_New) .AddColumn(table.Iden, iden) .Execute(); }
public void AddModel(QcfinishdtlModel model, DbTransaction tran) { //model.CreateTime = System.DateTime.Now; QcfinishdtlTable table = new QcfinishdtlTable(); InsertSqlSection insertSql = DataAccess.DefaultDB.Insert(table); if (tran != null) { insertSql.SetTransaction(tran); } int iden = DataAccess.DefaultDB.CustomSql("select QCFINISHDTLIDEN.nextval from dual").ToScalar <int>(); insertSql.AddColumn(table.QualityCode, model.QualityCode) .AddColumn(table.FinishingCode, model.FinishingCode) .AddColumn(table.Iden, iden) .Execute(); }
public void AddModel(QcavailablewidthModel model, DbTransaction tran) { //model.CreateTime = System.DateTime.Now; QcavailablewidthTable table = new QcavailablewidthTable(); int iden = DataAccess.DefaultDB.CustomSql("select QCAVAILABLEWIDTHIDEN.nextval from dual").ToScalar <int>(); InsertSqlSection insertSql = DataAccess.DefaultDB.Insert(table); if (tran != null) { insertSql.SetTransaction(tran); } insertSql.AddColumn(table.QualityCode, model.QualityCode) .AddColumn(table.Gauge, model.Gauge) .AddColumn(table.Iden, iden) .AddColumn(table.Diameter, model.Diameter) .AddColumn(table.TotalNeedles, model.TotalNeedles) .AddColumn(table.Width, model.Width) .AddColumn(table.MaxWidth, model.MaxWidth) .AddColumn(table.UpdatedBy, model.UpdatedBy) .AddColumn(table.UpdatedTime, model.UpdatedTime) .Execute(); }
public void AddModel(QcyarndtlModel model, DbTransaction tran) { //model.CreateTime = System.DateTime.Now; QcyarndtlTable table = new QcyarndtlTable(); InsertSqlSection insertSql = DataAccess.DefaultDB.Insert(table); if (tran != null) { insertSql.SetTransaction(tran); } int iden = DataAccess.DefaultDB.CustomSql("select QCYARNDTLIDEN.nextval from dual").ToScalar <int>(); insertSql.AddColumn(table.QualityCode, model.QualityCode) .AddColumn(table.YarnType, model.YarnType) .AddColumn(table.YarnCount, model.YarnCount) .AddColumn(table.Threads, model.Threads) .AddColumn(table.YarnRatio, model.YarnRatio) .AddColumn(table.WarpWeft, model.WarpWeft) .AddColumn(table.YarnDensity, model.YarnDensity) .AddColumn(table.YarnComponent, model.YarnComponent) .AddColumn(table.Iden, iden) .Execute(); }