int Edit(StringBuilder strSql, LineProductMesEntityu.MachinePlatEntity model) { strSql = new StringBuilder( ); strSql.Append("update MIKMAP set "); strSql.Append("MAP001=@MAP001,"); strSql.Append("MAP002=@MAP002,"); strSql.Append("MAP003=@MAP003,"); strSql.Append("MAP004=@MAP004,"); strSql.Append("MAP005=@MAP005,"); strSql.Append("MAP006=@MAP006 "); strSql.Append(" where idx=@idx"); SqlParameter [] parameters = { new SqlParameter("@MAP001", SqlDbType.NVarChar, 20), new SqlParameter("@MAP002", SqlDbType.NVarChar, 50), new SqlParameter("@MAP003", SqlDbType.NVarChar, 20), new SqlParameter("@MAP004", SqlDbType.NVarChar, 20), new SqlParameter("@MAP005", SqlDbType.NVarChar, 50), new SqlParameter("@MAP006", SqlDbType.NVarChar, 150), new SqlParameter("@idx", SqlDbType.Int, 4) }; parameters [0].Value = model.MAP001; parameters [1].Value = model.MAP002; parameters [2].Value = model.MAP003; parameters [3].Value = model.MAP004; parameters [4].Value = model.MAP005; parameters [5].Value = model.MAP006; parameters [6].Value = model.idx; return(SqlHelper.ExecuteNonQuery(strSql.ToString( ), parameters)); }
int Add(StringBuilder strSql, LineProductMesEntityu.MachinePlatEntity model) { strSql = new StringBuilder( ); strSql.Append("insert into MIKMAP("); strSql.Append("MAP001,MAP002,MAP003,MAP004,MAP005,MAP006)"); strSql.Append(" values ("); strSql.Append("@MAP001,@MAP002,@MAP003,@MAP004,@MAP005,@MAP006)"); strSql.Append(";select @@IDENTITY"); SqlParameter [] parameters = { new SqlParameter("@MAP001", SqlDbType.NVarChar, 20), new SqlParameter("@MAP002", SqlDbType.NVarChar, 50), new SqlParameter("@MAP003", SqlDbType.NVarChar, 20), new SqlParameter("@MAP004", SqlDbType.NVarChar, 20), new SqlParameter("@MAP005", SqlDbType.NVarChar, 50), new SqlParameter("@MAP006", SqlDbType.NVarChar, 150) }; parameters [0].Value = model.MAP001; parameters [1].Value = model.MAP002; parameters [2].Value = model.MAP003; parameters [3].Value = model.MAP004; parameters [4].Value = model.MAP005; parameters [5].Value = model.MAP006; return(SqlHelper.ExecuteSqlReturnId(strSql.ToString( ), parameters)); }
public FormMaPlate(LineProductMesEntityu.MachinePlatEntity model) { InitializeComponent( ); _model = new LineProductMesEntityu.MachinePlatEntity( ); _bll = new LineProductMesBll.Bll.MachinePlatBll( ); GridViewMoHuSelect.SetFilter(view); FieldInfo fi = typeof(XPaint).GetField("graphics", BindingFlags.Static | BindingFlags.NonPublic); fi.SetValue(null, new DrawXPaint( )); getTable( ); this._model = model; setValue( ); if (model == null || model.idx < 1) { this.Text = this.Text + "新增"; txtMAP001.Text = _bll.getOddNum( ); } else { this.Text = this.Text + "编辑"; } }
private void btnOk_Click(object sender, System.EventArgs e) { if (string.IsNullOrEmpty(txtMAP002.Text)) { XtraMessageBox.Show("请输入机台名称"); return; } if (string.IsNullOrEmpty(txtMAP004.Text)) { XtraMessageBox.Show("请选择车间"); return; } _model = new LineProductMesEntityu.MachinePlatEntity( ); _model.MAP001 = txtMAP001.Text; _model.MAP002 = txtMAP002.Text; _model.MAP003 = txtMAP004.EditValue.ToString( ); _model.MAP004 = txtMAP004.Text; _model.MAP005 = txtMAP005.Text; _model.MAP006 = txtMAP006.Text; _model.idx = txtMAP001.Tag == null ? 0 : Convert.ToInt32(txtMAP001.Tag); _model.idx = _bll.Save(_model); if (_model.idx > 0) { XtraMessageBox.Show("成功保存"); this.DialogResult = System.Windows.Forms.DialogResult.OK; } else { XtraMessageBox.Show("保存失败"); } }
protected override int Edit( ) { if (row == null) { XtraMessageBox.Show("请选择需要编辑的列"); return(0); } ChildForm.FormMaPlate from = new ChildForm.FormMaPlate(model); from.StartPosition = FormStartPosition.CenterScreen; if (from.ShowDialog( ) != DialogResult.OK) { return(0); } model = from.getModel; if (model == null) { return(0); } row = null; row = tableView.Rows [selectIdx]; row.BeginEdit( ); setColumn(row); row.EndEdit( ); gridControl1.RefreshDataSource( ); row = null; return(base.Edit( )); }
/// <summary> /// 保存数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Save(LineProductMesEntityu.MachinePlatEntity model) { StringBuilder strSql = new StringBuilder( ); if (model.idx < 1) { model.MAP001 = getOddNum( ); return(Add(strSql, model)); } else { return(Edit(strSql, model)); } }
/// <summary> /// 注销 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool CancellationBool(LineProductMesEntityu.MachinePlatEntity model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("UPDATE MIKMAP SET MAP007=@MAP007 WHERE idx=@idx"); SqlParameter [] parameter = { new SqlParameter("@MAP007", SqlDbType.Bit), new SqlParameter("@idx", SqlDbType.Int, 4) }; parameter [0].Value = model.MAP007; parameter [1].Value = model.idx; return(SqlHelper.ExecuteNonQueryResult(strSql.ToString( ), parameter)); }
public FormMachinePlat( ) { InitializeComponent( ); model = new LineProductMesEntityu.MachinePlatEntity( ); _bll = new LineProductMesBll.Bll.MachinePlatBll( ); GridViewMoHuSelect.SetFilter(gridView1); FieldInfo fi = typeof(XPaint).GetField("graphics", BindingFlags.Static | BindingFlags.NonPublic); fi.SetValue(null, new DrawXPaint( )); ToolBarContain.ToolbarsC(barTool, new DevExpress.XtraBars.BarItem [] { toolCanecl, toolSave, toolPrint, toolExamin }); Query( ); }
protected override int Add( ) { ChildForm.FormMaPlate from = new ChildForm.FormMaPlate(null); from.StartPosition = FormStartPosition.CenterScreen; if (from.ShowDialog( ) != DialogResult.OK) { return(0); } model = from.getModel; if (model == null) { return(0); } row = null; row = tableView.NewRow( ); row ["idx"] = model.idx; setColumn(row); tableView.Rows.Add(row); gridControl1.RefreshDataSource( ); row = null; return(base.Add( )); }
/// <summary> /// 注销 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool CancellationBool(LineProductMesEntityu.MachinePlatEntity model) { return(dal.CancellationBool(model)); }
/// <summary> /// 保存数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Save(LineProductMesEntityu.MachinePlatEntity model) { return(dal.Save(model)); }