/// <summary> /// 编辑上次入库记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateStr(MulaolaoLibrary.WuJinContractLibrary model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("UPDATE R_PQU SET "); strSql.Append("PQU109=@PQU109,"); strSql.Append("PQU110=@PQU110"); strSql.Append(" WHERE idx=@idx"); SqlParameter[] parameter = { new SqlParameter("@PQU109", SqlDbType.BigInt), new SqlParameter("@PQU110", SqlDbType.BigInt), new SqlParameter("@PQU109", SqlDbType.BigInt), }; parameter[0].Value = model.PQU109; parameter[0].Value = model.PQU110; parameter[0].Value = model.IDX; int row = SqlHelper.ExecuteNonQuery(strSql.ToString( ), parameter); if (row > 0) { return(true); } else { return(false); } }
public r343(MulaolaoLibrary.WuJinContractLibrary model) { InitializeComponent( ); _bll = new MulaolaoBll.Bll.QuoBll( ); GridViewMoHuSelect.SetFilter(new DevExpress.XtraGrid.Views.Grid.GridView [] { View }); GrivColumnStyle.setColumnStyle(new DevExpress.XtraGrid.Views.Grid.GridView [] { View }); this.model = model; setValue( ); getInfo( ); }
/// <summary> /// 批量编辑 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateBatch(MulaolaoLibrary.WuJinContractLibrary model, string tableNum, string tableName, string logins, DateTime dtOne, string oddNum, string stateOf, string stateOfOdd) { ArrayList SQLString = new ArrayList( ); StringBuilder strSql = new StringBuilder( ); strSql.Append("UPDATE R_PQU SET "); strSql.AppendFormat("PQU101='{0}',", model.PQU101); strSql.AppendFormat("PQU104='{0}',", model.PQU104); strSql.AppendFormat("PQU18='{0}'", model.PQU18); strSql.AppendFormat(" WHERE idx='{0}'", model.IDX); SQLString.Add(strSql.ToString( )); SQLString.Add(Drity.DrityOfComparation(tableNum, tableName, logins, dtOne, oddNum, strSql.ToString( ).Replace("'", "''"), stateOf, stateOfOdd)); return(SqlHelper.ExecuteSqlTran(SQLString)); }
void read343( ) { r343model.PQU04 = dt; r343 form = new r343(r343model); if (form.ShowDialog( ) == DialogResult.OK) { r343model = form.getModel; if (r343model == null) { return; } _qup.QUR004 = r343model.PQU10; _qup.QUR015 = r343model.PQU12; _qup.QUR006 = r343model.PQU13; _qup.QUR013 = r343model.PQU16; _qup.QUR010 = r343model.PQU18; _qup.QUR016 = 0; editRow( ); } }
/// <summary> /// 批量编辑 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateBatch(MulaolaoLibrary.WuJinContractLibrary model, string tableNum, string tableName, string logins, DateTime dtOne, string oddNumn, string stateOf, string stateOfOdd) { return(dao.UpdateBatch(model, tableNum, tableName, logins, dtOne, oddNumn, stateOf, stateOfOdd)); }
/// <summary> /// 编辑上次入库记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateStr(MulaolaoLibrary.WuJinContractLibrary model) { return(dao.UpdateStr(model)); }
void choiseCon( ) { if (DicStr.r195.Equals(_qup.QUR003)) { if ("add".Equals(conState)) { r195Model = new MulaolaoLibrary.ChanPinZhiBiaoLibrary( ); } read195( ); } else if (DicStr.r196.Equals(_qup.QUR003)) { if ("add".Equals(conState)) { r196model = new MulaolaoLibrary.SiReYiYinContractLibrary( ); } read196( ); } else if (DicStr.r338.Equals(_qup.QUR003)) { if ("add".Equals(conState)) { r338model = new MulaolaoLibrary.JiaoMiDuContractLibrary( ); } read338( ); } else if (DicStr.r341.Equals(_qup.QUR003)) { if ("add".Equals(conState)) { r341model = new MulaolaoLibrary.MuCaiContractLibrary( ); } read341( ); } else if (DicStr.r342.Equals(_qup.QUR003)) { if ("add".Equals(conState)) { r342model = new MulaolaoLibrary.CheMuJianContractLibrary( ); } read342( ); } else if (DicStr.r343.Equals(_qup.QUR003)) { if ("add".Equals(conState)) { r343model = new MulaolaoLibrary.WuJinContractLibrary( ); } read343( ); } else if (DicStr.r347.Equals(_qup.QUR003)) { if ("add".Equals(conState)) { r347model = new MulaolaoLibrary.SuLiaoBuQiContractLibrary( ); } read347( ); } else if (DicStr.r349.Equals(_qup.QUR003)) { if ("add".Equals(conState)) { r349model = new MulaolaoLibrary.WaiXianContractLibrary( ); } read349( ); } else if (DicStr.r339.Equals(_qup.QUR003)) { if ("add".Equals(conState)) { r339model = new MulaolaoLibrary.YouQiLibrary( ); } read339( ); } else if (DicStr.r344.Equals(_qup.QUR003)) { if ("add".Equals(conState)) { r344model = new MulaolaoLibrary.GunQiContractLibrary( ); } read344( ); } gridControl1.RefreshDataSource( ); }
void setValueToModel( ) { if (DicStr.r195.Equals(_qup.QUR003)) { r195Model = new MulaolaoLibrary.ChanPinZhiBiaoLibrary( ); r195Model.CP06 = _qup.QUR004; r195Model.CP07 = _qup.QUR015; r195Model.CP09 = _qup.QUR005; r195Model.CP10 = Convert.ToDecimal(_qup.QUR013); r195Model.CP13 = Convert.ToDecimal(_qup.QUR006); } else if (DicStr.r196.Equals(_qup.QUR003)) { r196model = new MulaolaoLibrary.SiReYiYinContractLibrary( ); r196model.AH10 = _qup.QUR004; r196model.AH18 = _qup.QUR005; r196model.AH13 = Convert.ToDecimal(_qup.QUR006); r196model.AH16 = Convert.ToDecimal(_qup.QUR013); r196model.AH11 = _qup.QUR015; } else if (DicStr.r338.Equals(_qup.QUR003)) { r338model = new MulaolaoLibrary.JiaoMiDuContractLibrary( ); r338model.JM09 = _qup.QUR004; r338model.JM10 = Convert.ToDecimal(_qup.QUR006); r338model.JM94 = Convert.ToDecimal(_qup.QUR007); r338model.JM95 = Convert.ToDecimal(_qup.QUR008); r338model.JM96 = Convert.ToDecimal(_qup.QUR009); r338model.JM15 = Convert.ToDecimal(_qup.QUR010); r338model.JM120 = _qup.QUR012; r338model.JM11 = Convert.ToDecimal(_qup.QUR013); } else if (DicStr.r341.Equals(_qup.QUR003)) { r341model = new MulaolaoLibrary.MuCaiContractLibrary( ); r341model.PQV10 = _qup.QUR004; r341model.PQV12 = Convert.ToInt32(_qup.QUR006); r341model.PQV71 = Convert.ToDecimal(_qup.QUR007); r341model.PQV72 = Convert.ToDecimal(_qup.QUR008); r341model.PQV73 = Convert.ToDecimal(_qup.QUR009); r341model.PQV64 = Convert.ToDecimal(_qup.QUR010); r341model.PQV11 = Convert.ToDecimal(_qup.QUR012); } else if (DicStr.r342.Equals(_qup.QUR003)) { r342model = new MulaolaoLibrary.CheMuJianContractLibrary( ); r342model.AF015 = _qup.QUR004; r342model.AF019 = Convert.ToInt32(_qup.QUR006); r342model.AF020 = Convert.ToDecimal(_qup.QUR007); r342model.AF021 = Convert.ToDecimal(_qup.QUR008); r342model.AF022 = Convert.ToDecimal(_qup.QUR009); r342model.AF018 = Convert.ToInt64(_qup.QUR010); r342model.AF023 = Convert.ToDecimal(_qup.QUR013); r342model.AF087 = Convert.ToDecimal(_qup.QUR012); r342model.AF088 = Convert.ToDecimal(_qup.QUR014); } else if (DicStr.r343.Equals(_qup.QUR003)) { r343model = new MulaolaoLibrary.WuJinContractLibrary( ); r343model.PQU10 = _qup.QUR004; r343model.PQU12 = _qup.QUR015; r343model.PQU13 = _qup.QUR006; r343model.PQU16 = _qup.QUR013; r343model.PQU18 = _qup.QUR010; } else if (DicStr.r347.Equals(_qup.QUR003)) { r347model = new MulaolaoLibrary.SuLiaoBuQiContractLibrary( ); r347model.PJ09 = _qup.QUR004; r347model.PJ89 = _qup.QUR015; r347model.PJ11 = _qup.QUR006; r347model.PJ12 = _qup.QUR013; r347model.PJ97 = _qup.QUR010; } else if (DicStr.r349.Equals(_qup.QUR003)) { r349model = new MulaolaoLibrary.WaiXianContractLibrary( ); r349model.WX10 = _qup.QUR004; r349model.WX11 = _qup.QUR015; r349model.WX13 = _qup.QUR013; r349model.WX14 = _qup.QUR006; r349model.WX16 = Convert.ToInt64(_qup.QUR010); } else if (DicStr.r339.Equals(_qup.QUR003)) { r339model = new MulaolaoLibrary.YouQiLibrary( ); r339model.YQ10 = _qup.QUR004; r339model.YQ112 = Convert.ToInt32(_qup.QUR006); r339model.YQ119 = _qup.QUR005; r339model.YQ19 = Convert.ToDecimal(_qup.QUR010); } else if (DicStr.r344.Equals(_qup.QUR003)) { r344model = new MulaolaoLibrary.GunQiContractLibrary( ); r344model.MZ016 = _qup.QUR004; r344model.MZ018 = _qup.QUR015; r344model.MZ021 = Convert.ToInt32(_qup.QUR010); r344model.MZ025 = Convert.ToDecimal(_qup.QUR013); r344model.MZ105 = Convert.ToDecimal(_qup.QUR016); } }