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));
}
