int Add(StringBuilder strSql, LineProductMesEntityu.SupplierForMouldEntity model)
{
strSql = new StringBuilder( );
strSql.Append("insert into MIKSFM(");
strSql.Append("SFM001,SFM002,SFM003,SFM004,SFM005,SFM007,SFM008,SFM009,SFM006,SFM010)");
strSql.Append(" values (");
strSql.Append("@SFM001,@SFM002,@SFM003,@SFM004,@SFM005,@SFM007,@SFM008,@SFM009,@SFM006,@SFM010)");
strSql.Append(";select @@IDENTITY");
SqlParameter [] parameters =
{
new SqlParameter("@SFM001", SqlDbType.NVarChar, 20),
new SqlParameter("@SFM002", SqlDbType.NVarChar, 50),
new SqlParameter("@SFM003", SqlDbType.NVarChar, 20),
new SqlParameter("@SFM004", SqlDbType.NVarChar, 20),
new SqlParameter("@SFM005", SqlDbType.NVarChar, 20),
new SqlParameter("@SFM007", SqlDbType.NVarChar, 20),
new SqlParameter("@SFM008", SqlDbType.NVarChar, 20),
new SqlParameter("@SFM009", SqlDbType.NVarChar, 50),
new SqlParameter("@SFM006", SqlDbType.Bit, 1),
new SqlParameter("@SFM010", SqlDbType.NVarChar, 20)
};
parameters [0].Value = model.SFM001;
parameters [1].Value = model.SFM002;
parameters [2].Value = model.SFM003;
parameters [3].Value = model.SFM004;
parameters [4].Value = model.SFM005;
parameters [5].Value = model.SFM007;
parameters [6].Value = model.SFM008;
parameters [7].Value = model.SFM009;
parameters [8].Value = model.SFM006;
parameters [9].Value = model.SFM010;
return(SqlHelper.ExecuteSqlReturnId(strSql.ToString( ), parameters));
}
protected override int Edit( )
{
if (row == null)
{
XtraMessageBox.Show("请选择需要编辑的内容");
return(0);
}
ChildForm.FormSupplierMould form = new ChildForm.FormSupplierMould(model);
form.StartPosition = FormStartPosition.CenterScreen;
if (form.ShowDialog( ) == System.Windows.Forms.DialogResult.OK)
{
model = form.getModel;
if (model == null)
{
return(0);
}
row = tableView.Rows [selectIdx];
row.BeginEdit( );
setValue(row);
row.EndEdit( );
gridControl1.RefreshDataSource( );
row = null;
}
return(base.Edit( ));
}
int Edit(StringBuilder strSql, LineProductMesEntityu.SupplierForMouldEntity model)
{
strSql = new StringBuilder( );
strSql.Append("update MIKSFM set ");
strSql.Append("SFM001=@SFM001,");
strSql.Append("SFM002=@SFM002,");
strSql.Append("SFM003=@SFM003,");
strSql.Append("SFM004=@SFM004,");
strSql.Append("SFM005=@SFM005,");
strSql.Append("SFM007=@SFM007,");
strSql.Append("SFM008=@SFM008,");
strSql.Append("SFM009=@SFM009,");
strSql.Append("SFM006=@SFM006,");
strSql.Append("SFM010=@SFM010 ");
strSql.Append(" where idx=@idx");
SqlParameter [] parameters =
{
new SqlParameter("@SFM001", SqlDbType.NVarChar, 20),
new SqlParameter("@SFM002", SqlDbType.NVarChar, 50),
new SqlParameter("@SFM003", SqlDbType.NVarChar, 20),
new SqlParameter("@SFM004", SqlDbType.NVarChar, 20),
new SqlParameter("@SFM005", SqlDbType.NVarChar, 20),
new SqlParameter("@SFM007", SqlDbType.NVarChar, 20),
new SqlParameter("@SFM008", SqlDbType.NVarChar, 20),
new SqlParameter("@SFM009", SqlDbType.NVarChar, 50),
new SqlParameter("@SFM006", SqlDbType.Bit, 1),
new SqlParameter("@idx", SqlDbType.Int, 4),
new SqlParameter("@SFM010", SqlDbType.NVarChar, 20)
};
parameters [0].Value = model.SFM001;
parameters [1].Value = model.SFM002;
parameters [2].Value = model.SFM003;
parameters [3].Value = model.SFM004;
parameters [4].Value = model.SFM005;
parameters [5].Value = model.SFM007;
parameters [6].Value = model.SFM008;
parameters [7].Value = model.SFM009;
parameters [8].Value = model.SFM006;
parameters [9].Value = model.idx;
parameters [10].Value = model.SFM010;
int rows = SqlHelper.ExecuteNonQuery(strSql.ToString( ), parameters);
if (rows > 0)
{
return(model.idx);
}
else
{
return(-1);
}
}
/// <summary>
/// 保存数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Save(LineProductMesEntityu.SupplierForMouldEntity model)
{
StringBuilder strSql = new StringBuilder( );
if (model.idx < 1)
{
model.SFM001 = getOddNum( );
return(Add(strSql, model));
}
else
{
return(Edit(strSql, model));
}
}
/// <summary>
/// 注销
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool CancellationBool(LineProductMesEntityu.SupplierForMouldEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE MIKSFM SET SFM006=@SFM006 WHERE idx=@idx");
SqlParameter [] parameter =
{
new SqlParameter("@SFM006", SqlDbType.Bit),
new SqlParameter("@idx", SqlDbType.Int)
};
parameter [0].Value = model.SFM006;
parameter [1].Value = model.idx;
return(SqlHelper.ExecuteNonQueryResult(strSql.ToString( ), parameter));
}
public FormSupplierForMould( )
{
InitializeComponent( );
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( ));
model = new LineProductMesEntityu.SupplierForMouldEntity( );
_bll = new LineProductMesBll.Bll.SupplierForMouldBll( );
ToolBarContain.ToolbarsC(barTool, new DevExpress.XtraBars.BarItem [] { toolCanecl, toolSave, toolPrint, toolExamin });
Query( );
}
public FormSupplierMould(LineProductMesEntityu.SupplierForMouldEntity entity)
{
InitializeComponent( );
_bll = new LineProductMesBll.Bll.SupplierForMouldBll( );
model = new LineProductMesEntityu.SupplierForMouldEntity( );
getPUA( );
model = entity;
if (model != null && model.idx > 0)
{
setValue( );
}
else
{
txtSFM001.Text = _bll.getOddNum( );
}
}
protected override int Add( )
{
ChildForm.FormSupplierMould form = new ChildForm.FormSupplierMould(null);
form.StartPosition = FormStartPosition.CenterScreen;
if (form.ShowDialog( ) == System.Windows.Forms.DialogResult.OK)
{
model = form.getModel;
if (model == null)
{
return(0);
}
row = null;
row = tableView.NewRow( );
row ["idx"] = model.idx;
setValue(row);
tableView.Rows.Add(row);
gridControl1.RefreshDataSource( );
row = null;
}
return(base.Add( ));
}
bool getValue( )
{
dxErrorProvider1.ClearErrors( );
if (string.IsNullOrEmpty(txtSFM002.Text))
{
dxErrorProvider1.SetError(txtSFM002, "不可为空");
return(false);
}
model = new LineProductMesEntityu.SupplierForMouldEntity( );
model.SFM001 = txtSFM001.Text;
model.SFM002 = txtSFM002.Text;
model.SFM003 = txtSFM003.Text;
model.SFM004 = txtSFM004.Text;
model.SFM005 = txtSFM005.Text;
model.SFM006 = false;
model.SFM007 = txtSFM007.Text;
model.SFM008 = txtSFM008.Text;
model.SFM009 = txtSFM009.Text;
model.SFM010 = txtSFM010.Text;
model.idx = txtSFM001.Tag == null ? 0 : Convert.ToInt32(txtSFM001.Tag);
return(true);
}
/// <summary>
/// 注销
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool CancellationBool(LineProductMesEntityu.SupplierForMouldEntity model)
{
return(dal.CancellationBool(model));
}
/// <summary>
/// 保存数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Save(LineProductMesEntityu.SupplierForMouldEntity model)
{
return(dal.Save(model));
}
