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