protected override int Edit( ) { if (row == null) { XtraMessageBox.Show("请选择需要编辑的内容"); return(0); } ChildForm.FormMouldInfo from = new ChildForm.FormMouldInfo(model); from.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen; if (from.ShowDialog( ) == System.Windows.Forms.DialogResult.OK) { model = from.getModel; if (model == null) { return(0); } row = tableView.Rows [selectIdx]; row.BeginEdit( ); setValue(row); row.EndEdit( ); gridControl1.RefreshDataSource( ); row = null; } return(base.Edit( )); }
/// <summary> /// 保存 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Save(LineProductMesEntityu.MouldInformationEntity model, string codePrefix) { if (model.idx < 1) { model.MOI001 = getOddNum(codePrefix); return(Add(model)); } else { return(Edit(model)); } }
int Add(LineProductMesEntityu.MouldInformationEntity model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("insert into MIKMOI("); strSql.Append("MOI001,MOI002,MOI003,MOI004,MOI005,MOI006,MOI007,MOI008,MOI009,MOI010,MOI011,MOI012,MOI013,MOI014,MOI015,MOI016,MOI017,MOI018)"); strSql.Append(" values ("); strSql.Append("@MOI001,@MOI002,@MOI003,@MOI004,@MOI005,@MOI006,@MOI007,@MOI008,@MOI009,@MOI010,@MOI011,@MOI012,@MOI013,@MOI014,@MOI015,@MOI016,@MOI017,@MOI018)"); strSql.Append(";select @@IDENTITY"); SqlParameter [] parameters = { new SqlParameter("@MOI001", SqlDbType.NVarChar, 20), new SqlParameter("@MOI002", SqlDbType.NVarChar, 50), new SqlParameter("@MOI003", SqlDbType.NVarChar, 50), new SqlParameter("@MOI004", SqlDbType.NVarChar, 20), new SqlParameter("@MOI005", SqlDbType.NVarChar, 50), new SqlParameter("@MOI006", SqlDbType.NVarChar, 5), new SqlParameter("@MOI007", SqlDbType.NVarChar, 5), new SqlParameter("@MOI008", SqlDbType.NVarChar, 20), new SqlParameter("@MOI009", SqlDbType.NVarChar, 50), new SqlParameter("@MOI010", SqlDbType.NVarChar, 200), new SqlParameter("@MOI011", SqlDbType.Date, 3), new SqlParameter("@MOI012", SqlDbType.NVarChar, 50), new SqlParameter("@MOI013", SqlDbType.NVarChar, 20), new SqlParameter("@MOI014", SqlDbType.NVarChar, 50), new SqlParameter("@MOI015", SqlDbType.NVarChar, 200), new SqlParameter("@MOI016", SqlDbType.Bit, 1), new SqlParameter("@MOI017", SqlDbType.NVarChar, 20), new SqlParameter("@MOI018", SqlDbType.NVarChar, 20) }; parameters [0].Value = model.MOI001; parameters [1].Value = model.MOI002; parameters [2].Value = model.MOI003; parameters [3].Value = model.MOI004; parameters [4].Value = model.MOI005; parameters [5].Value = model.MOI006; parameters [6].Value = model.MOI007; parameters [7].Value = model.MOI008; parameters [8].Value = model.MOI009; parameters [9].Value = model.MOI010; parameters [10].Value = model.MOI011; parameters [11].Value = model.MOI012; parameters [12].Value = model.MOI013; parameters [13].Value = model.MOI014; parameters [14].Value = model.MOI015; parameters [15].Value = model.MOI016; parameters [16].Value = model.MOI017; parameters [17].Value = model.MOI018; return(SqlHelper.ExecuteSqlReturnId(strSql.ToString( ), parameters)); }
/// <summary> /// 注销 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool CancellationBool(LineProductMesEntityu.MouldInformationEntity model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("UPDATE MIKMOI SET MOI016=@MOI016 WHERE idx=@idx"); SqlParameter [] parameter = { new SqlParameter("@MOI016", SqlDbType.Bit), new SqlParameter("@idx", SqlDbType.Int) }; parameter [0].Value = model.MOI016; parameter [1].Value = model.idx; return(SqlHelper.ExecuteNonQueryResult(strSql.ToString( ), parameter)); }
public FormMouldInformation( ) { InitializeComponent( ); model = new LineProductMesEntityu.MouldInformationEntity( ); _bll = new LineProductMesBll.Bll.MouldInformationBll( ); GridViewMoHuSelect.SetFilter(gridView1); GrivColumnStyle.setColumnStyle(new DevExpress.XtraGrid.Views.Grid.GridView [] { 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.FormMouldInfo from = new ChildForm.FormMouldInfo(null); from.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen; if (from.ShowDialog( ) == System.Windows.Forms.DialogResult.OK) { model = from.getModel; if (model == null) { return(0); } row = tableView.NewRow( ); row ["idx"] = model.idx; setValue(row); tableView.Rows.Add(row); gridControl1.RefreshDataSource( ); row = null; } return(base.Add( )); }
public FormMouldInfo(LineProductMesEntityu.MouldInformationEntity entity) { InitializeComponent( ); model = new LineProductMesEntityu.MouldInformationEntity( ); _bll = new LineProductMesBll.Bll.MouldInformationBll( ); GridViewMoHuSelect.SetFilter(new DevExpress.XtraGrid.Views.Grid.GridView [] { View1 }); FieldInfo fi = typeof(XPaint).GetField("graphics", BindingFlags.Static | BindingFlags.NonPublic); fi.SetValue(null, new DrawXPaint( )); getValue( ); model = entity; if (model == null || model.idx < 1) { //txtMOI001 . Text = _bll . getOddNum ( ); state = "add"; } else { setValue( ); } }
int Edit(LineProductMesEntityu.MouldInformationEntity model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("update MIKMOI set "); strSql.Append("MOI001=@MOI001,"); strSql.Append("MOI002=@MOI002,"); strSql.Append("MOI003=@MOI003,"); strSql.Append("MOI004=@MOI004,"); strSql.Append("MOI005=@MOI005,"); strSql.Append("MOI006=@MOI006,"); strSql.Append("MOI007=@MOI007,"); strSql.Append("MOI008=@MOI008,"); strSql.Append("MOI009=@MOI009,"); strSql.Append("MOI010=@MOI010,"); strSql.Append("MOI011=@MOI011,"); strSql.Append("MOI012=@MOI012,"); strSql.Append("MOI013=@MOI013,"); strSql.Append("MOI014=@MOI014,"); strSql.Append("MOI015=@MOI015,"); strSql.Append("MOI016=@MOI016"); strSql.Append(" where idx=@idx"); SqlParameter [] parameters = { new SqlParameter("@MOI001", SqlDbType.NVarChar, 20), new SqlParameter("@MOI002", SqlDbType.NVarChar, 50), new SqlParameter("@MOI003", SqlDbType.NVarChar, 50), new SqlParameter("@MOI004", SqlDbType.NVarChar, 20), new SqlParameter("@MOI005", SqlDbType.NVarChar, 50), new SqlParameter("@MOI006", SqlDbType.NVarChar, 5), new SqlParameter("@MOI007", SqlDbType.NVarChar, 5), new SqlParameter("@MOI008", SqlDbType.NVarChar, 20), new SqlParameter("@MOI009", SqlDbType.NVarChar, 50), new SqlParameter("@MOI010", SqlDbType.NVarChar, 200), new SqlParameter("@MOI011", SqlDbType.Date, 3), new SqlParameter("@MOI012", SqlDbType.NVarChar, 50), new SqlParameter("@MOI013", SqlDbType.NVarChar, 20), new SqlParameter("@MOI014", SqlDbType.NVarChar, 50), new SqlParameter("@MOI015", SqlDbType.NVarChar, 200), new SqlParameter("@MOI016", SqlDbType.Bit, 1), new SqlParameter("@idx", SqlDbType.Int, 4) }; parameters [0].Value = model.MOI001; parameters [1].Value = model.MOI002; parameters [2].Value = model.MOI003; parameters [3].Value = model.MOI004; parameters [4].Value = model.MOI005; parameters [5].Value = model.MOI006; parameters [6].Value = model.MOI007; parameters [7].Value = model.MOI008; parameters [8].Value = model.MOI009; parameters [9].Value = model.MOI010; parameters [10].Value = model.MOI011; parameters [11].Value = model.MOI012; parameters [12].Value = model.MOI013; parameters [13].Value = model.MOI014; parameters [14].Value = model.MOI015; parameters [15].Value = model.MOI016; parameters [16].Value = model.idx; int rows = SqlHelper.ExecuteNonQuery(strSql.ToString( ), parameters); if (rows > 0) { return(model.idx); } else { return(-1); } }
bool getValueModel( ) { dxErrorProvider1.ClearErrors( ); if (string.IsNullOrEmpty(txtMOI002.Text)) { dxErrorProvider1.SetError(txtMOI002, "不可为空"); return(false); } if (string.IsNullOrEmpty(txtMOI005.Text)) { dxErrorProvider1.SetError(txtMOI005, "不可为空"); return(false); } if (string.IsNullOrEmpty(txtMOI006.Text)) { dxErrorProvider1.SetError(txtMOI006, "不可为空"); return(false); } if (string.IsNullOrEmpty(txtMOI007.Text)) { dxErrorProvider1.SetError(txtMOI007, "不可为空"); return(false); } //if ( string . IsNullOrEmpty ( txtMOI010 . Text ) ) //{ // dxErrorProvider1 . SetError ( txtMOI010 ,"不可为空" ); // return false; //} if (string.IsNullOrEmpty(txtMOI011.Text)) { dxErrorProvider1.SetError(txtMOI011, "不可为空"); return(false); } if (string.IsNullOrEmpty(txtMOI014.Text)) { dxErrorProvider1.SetError(txtMOI014, "不可为空"); return(false); } if (string.IsNullOrEmpty(txtMOI001.Text)) { dxErrorProvider1.SetError(txtMOI001, "不可为空"); return(false); } model = new LineProductMesEntityu.MouldInformationEntity( ); model.idx = txtMOI001.Tag == null ? 0 : Convert.ToInt32(txtMOI001.Tag); model.MOI001 = txtMOI001.Text; model.MOI002 = txtMOI002.Text; model.MOI003 = txtMOI003.Text; model.MOI004 = txtMOI005.EditValue == null ? string.Empty : txtMOI005.EditValue.ToString( ); model.MOI005 = txtMOI005.Text; model.MOI006 = txtMOI006.Text; model.MOI007 = txtMOI007.Text; model.MOI008 = txtMOI009.EditValue == null ? string.Empty : txtMOI009.EditValue.ToString( ); model.MOI009 = txtMOI009.Text; model.MOI010 = txtMOI010.Text; if (string.IsNullOrEmpty(txtMOI011.Text)) { model.MOI011 = null; } else { model.MOI011 = Convert.ToDateTime(txtMOI011.Text); } model.MOI012 = txtMOI012.Text; model.MOI013 = txtMOI014.EditValue == null ? string.Empty : txtMOI014.EditValue.ToString( ); model.MOI014 = txtMOI014.Text; model.MOI015 = txtMOI015.Text; model.MOI016 = false; model.MOI017 = txtMOI017.Text; model.MOI018 = txtMOI018.Text; return(true); }
/// <summary> /// 注销 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool CancellationBool(LineProductMesEntityu.MouldInformationEntity model) { return(dal.CancellationBool(model)); }
/// <summary> /// 保存 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Save(LineProductMesEntityu.MouldInformationEntity model, string codePrefix) { return(dal.Save(model, codePrefix)); }