/// <summary> /// 编辑上次入库记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateStr(MulaolaoLibrary.SuLiaoBuQiContractLibrary model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("UPDATE R_PQS SET "); strSql.Append("PJ102=@PJ102,"); strSql.Append("PJ103=@PJ103"); strSql.Append(" WHERE idx=@idx"); SqlParameter[] parameter = { new SqlParameter("@PJ102", SqlDbType.BigInt), new SqlParameter("@PJ103", SqlDbType.Decimal), new SqlParameter("@PJ102", SqlDbType.Int) }; parameter[0].Value = model.PJ102; parameter[1].Value = model.PJ103; parameter[2].Value = model.IDX; int row = SqlHelper.ExecuteNonQuery(strSql.ToString( ), parameter); if (row > 0) { return(true); } else { return(false); } }
public r347(MulaolaoLibrary.SuLiaoBuQiContractLibrary 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.SuLiaoBuQiContractLibrary model, string tableNum, string tableName, string logins, DateTime dtOne, string stateOf, string stateOfOdd) { ArrayList SQLString = new ArrayList( ); StringBuilder strSql = new StringBuilder( ); strSql.Append("UPDATE R_PQS SET "); strSql.AppendFormat("PJ96={0},", model.PJ96); strSql.AppendFormat("PJ14={0},", model.PJ14); strSql.AppendFormat("PJ97={0}", model.PJ97); strSql.AppendFormat(" WHERE idx='{0}'", model.IDX); SQLString.Add(strSql.ToString( )); SQLString.Add(Drity.DrityOfComparation(tableNum, tableName, logins, dtOne, model.PJ92, strSql.ToString( ).Replace("'", "''"), stateOf, stateOfOdd)); return(SqlHelper.ExecuteSqlTran(SQLString)); }
void read347( ) { r347model.PJ05 = dt; r347 form = new r347(r347model); if (form.ShowDialog( ) == DialogResult.OK) { r347model = form.getModel; if (r347model == null) { return; } _qup.QUR004 = r347model.PJ09; _qup.QUR015 = r347model.PJ89; _qup.QUR006 = r347model.PJ11; _qup.QUR013 = r347model.PJ12; _qup.QUR010 = r347model.PJ97; editRow( ); } }
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); } }
/// <summary> /// 批量编辑数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateBatch(MulaolaoLibrary.SuLiaoBuQiContractLibrary model, string tableNum, string tableName, string logins, DateTime dtOne, string stateOf, string stateOfOdd) { return(dao.UpdateBatch(model, tableNum, tableName, logins, dtOne, stateOf, stateOfOdd)); }
/// <summary> /// 编辑上次入库记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateStr(MulaolaoLibrary.SuLiaoBuQiContractLibrary model) { return(dao.UpdateStr(model)); }