public FormWinding( )
{
InitializeComponent( );
_wid = new ProductionErpEntity.WindingWIDEntity( );
_wie = new ProductionErpEntity.WindingWIEEntity( );
_bll = new ProductionErpBll.Bll.WindingBll( );
tableView = new DataTable( );
Utility.GridViewMoHuSelect.SetFilter(gridView1);
FieldInfo fi = typeof(XPaint).GetField("graphics", BindingFlags.Static | BindingFlags.NonPublic);
fi.SetValue(null, new DrawXPaint( ));
wait.Hide( );
//barMenu . LinksPersistInfo . RemoveAt ( toolExport . Id );
getOddNum( );
lupGoods.Properties.DataSource = _bll.getTableGD( );
lupGoods.Properties.DisplayMember = "RAA001";
UserInfo = _bll.getTableUser( );
secUser.DataSource = UserInfo;
secUser.DisplayMember = "WIE011";
secUser.ValueMember = "WIE011";
controlUnEnable( );
}
public ProductionErpEntity.WindingWIDEntity GetModel(DataRow row)
{
ProductionErpEntity.WindingWIDEntity _model = new ProductionErpEntity.WindingWIDEntity( );
if (row != null)
{
if (row ["WID001"] != null)
{
_model.WID001 = row ["WID001"].ToString( );
}
if (row ["WID002"] != null)
{
_model.WID002 = row ["WID002"].ToString( );
}
//if ( row [ "WID003" ] != null )
// _model . WID003 = row [ "WID003" ] . ToString ( );
//if ( row [ "WID004" ] != null )
// _model . WID004 = row [ "WID004" ] . ToString ( );
if (row ["WID005"] != null && row ["WID005"].ToString( ) != "")
{
_model.WID005 = DateTime.Parse(row ["WID005"].ToString( ));
}
}
return(_model);
}
private void backgroundWorker1_DoWork(object sender, System.ComponentModel.DoWorkEventArgs e)
{
_wid = _bll.tableHead(strWhere);
tableView = _bll.tableView(strWhere);
tableOddNum = _bll.getTableOnly("WID001", "MOXWID");
}
/// <summary>
/// edit data of view to database
/// </summary>
/// <param name="table"></param>
/// <param name="_wid"></param>
/// <returns></returns>
public bool Edit(DataTable table, ProductionErpEntity.WindingWIDEntity _wid)
{
Hashtable SQLString = new Hashtable( );
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE MOXWID SET ");
//strSql . Append ( "WID003=@WID003," );
//strSql . Append ( "WID004=@WID004," );
strSql.Append("WID005=@WID005 ");
strSql.Append("WHERE WID001=@WID001");
SqlParameter [] parameter =
{
new SqlParameter("@WID001", SqlDbType.NVarChar, 50),
//new SqlParameter("@WID003",SqlDbType.NVarChar,50),
//new SqlParameter("@WID004",SqlDbType.NVarChar,50),
new SqlParameter("@WID005", SqlDbType.Date, 3)
};
parameter [0].Value = _wid.WID001;
//parameter [ 1 ] . Value = _wid . WID003;
//parameter [ 2 ] . Value = _wid . WID004;
parameter [1].Value = _wid.WID005;
SQLString.Add(strSql, parameter);
ProductionErpEntity.WindingWIEEntity _wie = new ProductionErpEntity.WindingWIEEntity( );
_wie.WIE001 = _wid.WID001;
DataTable dt = getTable(_wie.WIE001);
for (int i = 0; i < table.Rows.Count; i++)
{
_wie.WIE002 = table.Rows [i] ["WIE002"].ToString( );
_wie.WIE003 = table.Rows [i] ["WIE003"].ToString( );
if (string.IsNullOrEmpty(table.Rows [i] ["WIE004"].ToString( )))
{
_wie.WIE004 = null;
}
else
{
_wie.WIE004 = Convert.ToDateTime(table.Rows [i] ["WIE004"].ToString( ));
}
_wie.WIE005 = table.Rows [i] ["WIE005"].ToString( );
_wie.WIE006 = string.IsNullOrEmpty(table.Rows [i] ["WIE006"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["WIE006"].ToString( ));
_wie.WIE007 = table.Rows [i] ["WIE007"].ToString( );
_wie.WIE008 = string.IsNullOrEmpty(table.Rows [i] ["WIE008"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["WIE008"].ToString( ));
_wie.WIE009 = string.IsNullOrEmpty(table.Rows [i] ["WIE009"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["WIE009"].ToString( ));
_wie.WIE010 = string.IsNullOrEmpty(table.Rows [i] ["WIE010"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["WIE010"].ToString( ));
_wie.idx = string.IsNullOrEmpty(table.Rows [i] ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["idx"].ToString( ));
_wie.WIE011 = table.Rows [i] ["WIE011"].ToString( );
_wie.WIE012 = table.Rows [i] ["WIE012"].ToString( );
_wie.WIE013 = string.IsNullOrEmpty(table.Rows [i] ["WIE013"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["WIE013"].ToString( ));
_wie.WIE014 = string.IsNullOrEmpty(table.Rows [i] ["WIE014"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["WIE014"].ToString( ));
_wie.WIE015 = table.Rows [i] ["WIE015"].ToString( );
if (string.IsNullOrEmpty(table.Rows [i] ["WIE016"].ToString( )))
{
_wie.WIE016 = null;
}
else
{
_wie.WIE016 = Convert.ToDateTime(table.Rows [i] ["WIE016"].ToString( ));
}
if (dt.Select("WIE002='" + _wie.WIE002 + "' AND WIE005='" + _wie.WIE005 + "'").Length > 0)
{
edit_wie(SQLString, strSql, _wie);
}
else
{
add_wie(SQLString, strSql, _wie);
}
}
for (int i = 0; i < dt.Rows.Count; i++)
{
_wie.idx = string.IsNullOrEmpty(dt.Rows [i] ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(dt.Rows [i] ["idx"].ToString( ));
_wie.WIE002 = dt.Rows [i] ["WIE002"].ToString( );
_wie.WIE005 = dt.Rows [i] ["WIE005"].ToString( );
if (table.Select("WIE002='" + _wie.WIE002 + "' AND WIE005='" + _wie.WIE005 + "'").Length < 1)
{
delete_wie(SQLString, strSql, _wie.idx);
}
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
/// <summary>
/// add data of view to database
/// </summary>
/// <param name="table"></param>
/// <param name="_wid"></param>
/// <returns></returns>
public bool Add(DataTable table, ProductionErpEntity.WindingWIDEntity _wid)
{
Hashtable SQLString = new Hashtable( );
StringBuilder strSql = new StringBuilder( );
_wid.WID001 = getOddNum( );
strSql.Append("INSERT INTO MOXWID (");
strSql.Append("WID001,WID002,WID005) "); //,WID003,WID004
strSql.Append("VALUES (");
strSql.Append("@WID001,@WID002,@WID005) "); //,@WID003,@WID004
SqlParameter [] parameter =
{
new SqlParameter("@WID001", SqlDbType.NVarChar, 50),
new SqlParameter("@WID002", SqlDbType.NVarChar, 50),
//new SqlParameter("@WID003",SqlDbType.NVarChar,50),
//new SqlParameter("@WID004",SqlDbType.NVarChar,50),
new SqlParameter("@WID005", SqlDbType.Date, 3)
};
parameter [0].Value = _wid.WID001;
parameter [1].Value = _wid.WID002;
//parameter [ 2 ] . Value = _wid . WID003;
//parameter [ 3 ] . Value = _wid . WID004;
parameter [2].Value = _wid.WID005;
SQLString.Add(strSql, parameter);
ProductionErpEntity.WindingWIEEntity _wie = new ProductionErpEntity.WindingWIEEntity( );
_wie.WIE001 = _wid.WID001;
for (int i = 0; i < table.Rows.Count; i++)
{
_wie.WIE002 = table.Rows [i] ["WIE002"].ToString( );
_wie.WIE003 = table.Rows [i] ["WIE003"].ToString( );
if (string.IsNullOrEmpty(table.Rows [i] ["WIE004"].ToString( )))
{
_wie.WIE004 = null;
}
else
{
_wie.WIE004 = Convert.ToDateTime(table.Rows [i] ["WIE004"].ToString( ));
}
_wie.WIE005 = table.Rows [i] ["WIE005"].ToString( );
_wie.WIE006 = string.IsNullOrEmpty(table.Rows [i] ["WIE006"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["WIE006"].ToString( ));
_wie.WIE007 = table.Rows [i] ["WIE007"].ToString( );
_wie.WIE008 = string.IsNullOrEmpty(table.Rows [i] ["WIE008"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["WIE008"].ToString( ));
_wie.WIE009 = string.IsNullOrEmpty(table.Rows [i] ["WIE009"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["WIE009"].ToString( ));
_wie.WIE010 = string.IsNullOrEmpty(table.Rows [i] ["WIE010"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["WIE010"].ToString( ));
_wie.WIE011 = table.Rows [i] ["WIE011"].ToString( );
_wie.WIE012 = table.Rows [i] ["WIE012"].ToString( );
_wie.WIE013 = string.IsNullOrEmpty(table.Rows [i] ["WIE013"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["WIE013"].ToString( ));
_wie.WIE014 = string.IsNullOrEmpty(table.Rows [i] ["WIE014"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["WIE014"].ToString( ));
_wie.WIE015 = table.Rows [i] ["WIE015"].ToString( );
if (string.IsNullOrEmpty(table.Rows [i] ["WIE016"].ToString( )))
{
_wie.WIE016 = null;
}
else
{
_wie.WIE016 = Convert.ToDateTime(table.Rows [i] ["WIE016"].ToString( ));
}
add_wie(SQLString, strSql, _wie);
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
/// <summary>
/// edit data of view to database
/// </summary>
/// <param name="table"></param>
/// <param name="_wid"></param>
/// <returns></returns>
public bool Edit(DataTable table, ProductionErpEntity.WindingWIDEntity _wid)
{
return(_dal.Edit(table, _wid));
}
