public FormArt( )
{
InitializeComponent( );
model = new LineProductMesEntityu.ArtEntity( );
body = new LineProductMesEntityu.ArsEntity( );
_bll = new LineProductMesBll.Bll.ArtBll( );
_bodyOne = new LineProductMesEntityu.AruEntity( );
//获取UI线程同步上下文
m_SyncContext = SynchronizationContext.Current;
GridViewMoHuSelect.SetFilter(new DevExpress.XtraGrid.Views.Grid.GridView [] { gridView1, gridView2, gridView3, View1, View4, View2, View3, gridView4 });
GrivColumnStyle.setColumnStyle(new DevExpress.XtraGrid.Views.Grid.GridView [] { gridView1, gridView2, gridView3, View1, View4, View2, View3, gridView4 });
FieldInfo fi = typeof(XPaint).GetField("graphics", BindingFlags.Static | BindingFlags.NonPublic);
fi.SetValue(null, new DrawXPaint( ));
ToolBarContain.ToolbarsC(barTool, new DevExpress.XtraBars.BarButtonItem [] { toolCancellation, toolExamin });
Query( );
controlUnEnable( );
controlClear( );
InitData( );
}
void EditBody(Dictionary <object, object> SQLString, LineProductMesEntityu.ArtEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("update MIKART set ");
strSql.Append("ART002=@ART002,");
strSql.Append("ART003=@ART003,");
strSql.Append("ART004=@ART004,");
strSql.Append("ART005=@ART005,");
strSql.Append("ART006=@ART006,");
strSql.Append("ART007=@ART007,");
//strSql . Append ( "ART008=@ART008," );
strSql.Append("ART009=@ART009,");
strSql.Append("ART010=@ART010,");
strSql.Append("ART011=@ART011,");
strSql.Append("ART012=@ART012,");
strSql.Append("ART013=@ART013 ");
strSql.Append(" where idx=@idx");
SqlParameter [] parameters =
{
new SqlParameter("@ART003", SqlDbType.NVarChar, 20),
new SqlParameter("@ART004", SqlDbType.Decimal, 9),
new SqlParameter("@ART005", SqlDbType.Decimal, 9),
new SqlParameter("@ART006", SqlDbType.NVarChar, 50),
new SqlParameter("@ART007", SqlDbType.NVarChar, 50),
//new SqlParameter("@ART008", SqlDbType.NVarChar,255),
new SqlParameter("@ART009", SqlDbType.NVarChar, 255),
new SqlParameter("@ART010", SqlDbType.NVarChar, 5),
new SqlParameter("@idx", SqlDbType.Int, 4),
new SqlParameter("@ART002", SqlDbType.NVarChar, 20),
new SqlParameter("@ART011", SqlDbType.NVarChar, 20),
new SqlParameter("@ART012", SqlDbType.Int, 4),
new SqlParameter("@ART013", SqlDbType.NVarChar, 20)
};
parameters [0].Value = model.ART003;
parameters [1].Value = model.ART004;
parameters [2].Value = model.ART005;
parameters [3].Value = model.ART006;
parameters [4].Value = model.ART007;
//parameters [ 5 ] . Value = model . ART008;
parameters [5].Value = model.ART009;
parameters [6].Value = model.ART010;
parameters [7].Value = model.idx;
parameters [8].Value = model.ART002;
parameters [9].Value = model.ART011;
parameters [10].Value = model.ART012;
parameters [11].Value = model.ART013;
SQLString.Add(strSql, parameters);
}
/// <summary>
/// 注销
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool CancellationBool(LineProductMesEntityu.ArtEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE MIKART SET ART018=@ART018 WHERE idx=@idx");
SqlParameter [] parameter =
{
new SqlParameter("@ART018", SqlDbType.Bit),
new SqlParameter("@idx", SqlDbType.Int)
};
parameter [0].Value = model.ART018;
parameter [1].Value = model.idx;
return(SqlHelper.ExecuteNonQueryResult(strSql.ToString( ), parameter));
}
/// <summary>
/// 保存数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Save(LineProductMesEntityu.ArsEntity model, DataTable table, Hashtable haTable)
{
Dictionary <object, object> SQLString = new Dictionary <object, object> ( );
AddHeader(SQLString, model);
if (table != null && table.Rows.Count > 0)
{
LineProductMesEntityu.ArtEntity body = new LineProductMesEntityu.ArtEntity( );
body.ART001 = model.ARS001;
foreach (DataRow row in table.Rows)
{
body.ART011 = row ["ART011"].ToString( );
body.ART002 = row ["ART002"].ToString( );
body.ART003 = row ["ART003"].ToString( );
body.ART004 = string.IsNullOrEmpty(row ["ART004"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ART004"].ToString( ));
body.ART005 = string.IsNullOrEmpty(row ["ART005"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ART005"].ToString( ));
body.ART006 = row ["ART006"].ToString( );
body.ART007 = row ["ART007"].ToString( );
//body . ART008 = row [ "ART008" ] . ToString ( );
body.ART009 = row ["ART009"].ToString( );
body.ART010 = string.IsNullOrEmpty(row ["ART010"].ToString( )) == true ? "否" : row ["ART010"].ToString( );
body.ART012 = string.IsNullOrEmpty(row ["ART012"].ToString( )) == true ? 0 : Convert.ToInt32(row ["ART012"].ToString( ));
body.ART013 = row ["ART013"].ToString( );
AddBody(SQLString, body);
if (haTable != null && haTable.Count > 0)
{
DataTable tableView = ( DataTable )haTable [body.ART001 + body.ART011];
if (tableView != null && tableView.Rows.Count > 0)
{
LineProductMesEntityu.AruEntity bodyOne = new LineProductMesEntityu.AruEntity( );
bodyOne.ARU001 = body.ART001;
bodyOne.ARU002 = body.ART011;
foreach (DataRow rows in tableView.Rows)
{
bodyOne.ARU003 = rows ["ARU003"].ToString( );
bodyOne.ARU004 = rows ["ARU004"].ToString( );
AddBodyOne(SQLString, bodyOne);
}
}
}
}
}
return(SqlHelper.ExecuteSqlTranDic(SQLString));
}
void AddBody(Dictionary <object, object> SQLString, LineProductMesEntityu.ArtEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("insert into MIKART(");
strSql.Append("ART001,ART002,ART003,ART004,ART005,ART006,ART007,ART009,ART010,ART011,ART012,ART013)");
strSql.Append(" values (");
strSql.Append("@ART001,@ART002,@ART003,@ART004,@ART005,@ART006,@ART007,@ART009,@ART010,@ART011,@ART012,@ART013)");
SqlParameter [] parameters =
{
new SqlParameter("@ART001", SqlDbType.NVarChar, 20),
new SqlParameter("@ART002", SqlDbType.NVarChar, 20),
new SqlParameter("@ART003", SqlDbType.NVarChar, 20),
new SqlParameter("@ART004", SqlDbType.Decimal, 9),
new SqlParameter("@ART005", SqlDbType.Decimal, 9),
new SqlParameter("@ART006", SqlDbType.NVarChar, 50),
new SqlParameter("@ART007", SqlDbType.NVarChar, 50),
new SqlParameter("@ART009", SqlDbType.NVarChar, 255),
new SqlParameter("@ART010", SqlDbType.NVarChar, 5),
new SqlParameter("@ART011", SqlDbType.NVarChar, 20),
new SqlParameter("@ART012", SqlDbType.Int, 4),
new SqlParameter("@ART013", SqlDbType.NVarChar, 20)
};
parameters [0].Value = model.ART001;
parameters [1].Value = model.ART002;
parameters [2].Value = model.ART003;
parameters [3].Value = model.ART004;
parameters [4].Value = model.ART005;
parameters [5].Value = model.ART006;
parameters [6].Value = model.ART007;
parameters [7].Value = model.ART009;
parameters [8].Value = model.ART010;
parameters [9].Value = model.ART011;
parameters [10].Value = model.ART012;
parameters [11].Value = model.ART013;
SQLString.Add(strSql, parameters);
}
/// <summary>
/// 注销
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool CancellationBool(LineProductMesEntityu.ArtEntity model)
{
return(dal.CancellationBool(model));
}
