public Form2(DataTable tableOne, MaterileEntity.MaterielPDCEntity _pdc, string ContrNum, string productNum, string productName)
{
InitializeComponent( );
this._pdc = new MaterileEntity.MaterielPDCEntity( );
_pdd = new MaterileEntity.MaterielPDDEntity( );
_bll = new MaterielBll.Bll.MaterielTwoBll( );
toolQuery.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
toolAdd.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
toolDelete.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
toolEdit.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
toolSave.Visibility = DevExpress.XtraBars.BarItemVisibility.Always;
toolCancel.Visibility = DevExpress.XtraBars.BarItemVisibility.Always;
toolProv.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
toolNext.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
toolPrint.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
toolExport.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
this.txtContrNum.Text = ContrNum;
this.txtCusNum.Tag = productNum;
this.txtCusNum.Text = productName;
this.table = tableOne;
this._pdc = _pdc;
query( );
}
void add_pdd_one(Hashtable SQLString, StringBuilder strSql, MaterileEntity.MaterielPDDEntity _pdd)
{
strSql = new StringBuilder( );
strSql.Append("INSERT INTO TENPDD (");
strSql.Append("PDD001,PDD002,PDD003,PDD004,PDD005,PDD006,PDD007,PDD008,PDD009,PDD011,PDD012) ");
strSql.Append("VALUES (");
strSql.Append("@PDD001,@PDD002,@PDD003,@PDD004,@PDD005,@PDD006,@PDD007,@PDD008,@PDD009,@PDD011,@PDD012)");
SqlParameter [] parameter =
{
new SqlParameter("@PDD001", SqlDbType.NVarChar, 200),
new SqlParameter("@PDD002", SqlDbType.NVarChar, 10),
new SqlParameter("@PDD003", SqlDbType.NVarChar, 200),
new SqlParameter("@PDD004", SqlDbType.NVarChar, 200),
new SqlParameter("@PDD005", SqlDbType.NVarChar, 200),
new SqlParameter("@PDD006", SqlDbType.Int),
new SqlParameter("@PDD007", SqlDbType.NVarChar, 200),
new SqlParameter("@PDD008", SqlDbType.NVarChar, 200),
new SqlParameter("@PDD009", SqlDbType.NVarChar, 200),
new SqlParameter("@PDD011", SqlDbType.NVarChar, 200),
new SqlParameter("@PDD012", SqlDbType.NVarChar, 200),
};
parameter [0].Value = _pdd.PDD001;
parameter [1].Value = _pdd.PDD002;
parameter [2].Value = _pdd.PDD003;
parameter [3].Value = _pdd.PDD004;
parameter [4].Value = _pdd.PDD005;
parameter [5].Value = _pdd.PDD006;
parameter [6].Value = _pdd.PDD007;
parameter [7].Value = _pdd.PDD008;
parameter [8].Value = _pdd.PDD009;
parameter [9].Value = _pdd.PDD011;
parameter [10].Value = _pdd.PDD012;
SQLString.Add(strSql, parameter);
}
void add_pdd(Hashtable SQLString, StringBuilder strSql, Hashtable table_one_pdc, Hashtable table_two_pdc)
{
foreach (string key in table_two_pdc.Keys)
{
MaterileEntity.MaterielPDCEntity _pdc = (MaterileEntity.MaterielPDCEntity)table_two_pdc [key];
MaterileEntity.MaterielPDDEntity _pdd = new MaterileEntity.MaterielPDDEntity( );
_pdd.PDD001 = _pdc.PDC002;
_pdd.PDD011 = _pdc.PDC005;
_pdd.PDD012 = _pdc.PDC001;
DataTable tableTre = ( DataTable )table_one_pdc [key];
DataTable dt = dtpdd(_pdd.PDD011, _pdd.PDD012);
List <string> strList = new List <string> ( );
for (int i = 0; i < tableTre.Rows.Count; i++)
{
_pdd.PDD002 = tableTre.Rows [i] ["PDD002"].ToString( );
_pdd.PDD003 = tableTre.Rows [i] ["PDD003"].ToString( );
_pdd.PDD004 = tableTre.Rows [i] ["PDD004"].ToString( );
_pdd.PDD005 = tableTre.Rows [i] ["PDD005"].ToString( );
_pdd.PDD006 = string.IsNullOrEmpty(tableTre.Rows [i] ["PDD006"].ToString( )) == true ? 0 : Convert.ToInt32(tableTre.Rows [i] ["PDD006"].ToString( ));
_pdd.PDD007 = tableTre.Rows [i] ["PDD007"].ToString( );
_pdd.PDD008 = tableTre.Rows [i] ["PDD008"].ToString( );
_pdd.PDD009 = tableTre.Rows [i] ["PDD009"].ToString( );
if (dt.Select("PDD002='" + _pdd.PDD002 + "'").Length > 0)
{
//if ( dt . Select ( "PDD002='" + _pdd . PDD002 + "' AND PDD003='" + _pdd . PDD003 + "' AND PDD004='" + _pdd . PDD004 + "' AND PDD005='" + _pdd . PDD005 + "' AND PDD006='" + _pdd . PDD006 + "' AND PDD007='" + _pdd . PDD007 + "' AND PDD008='" + _pdd . PDD008 + "' AND PDD009='" + _pdd . PDD009 + "' AND PDD011='" + _pdd . PDD011 + "' AND PDD012='" + _pdd . PDD012 + "'" ) . Length < 1 )
//{
// _pdd . PDD002 = dt . Compute ( "max(PDD002)" ,null ) . ToString ( );
// _pdd . PDD002 = ( Convert . ToInt32 ( _pdd . PDD002 ) + 1 ) . ToString ( );
// _pdd . PDD002 = _pdd . PDD002 . PadLeft ( 3 ,'0' );
// if ( strList . Contains ( _pdd . PDD002 ) == false )
// strList . Add ( _pdd . PDD002 );
// else
// {
// _pdd . PDD002 = strList . Max ( );
// _pdd . PDD002 = ( Convert . ToInt32 ( _pdd . PDD002 ) + 1 ) . ToString ( );
// _pdd . PDD002 = _pdd . PDD002 . PadLeft ( 3 ,'0' );
// strList . Add ( _pdd . PDD002 );
// }
// add_pdd_one ( SQLString ,strSql ,_pdd );
//}
//else
edit_pdd(SQLString, strSql, _pdd);
}
else
{
add_pdd_one(SQLString, strSql, _pdd);
}
}
}
}
void edit_pdd(Hashtable SQLString, StringBuilder strSql, MaterileEntity.MaterielPDDEntity _pdd)
{
strSql = new StringBuilder( );
strSql.Append("UPDATE TENPDD SET ");
strSql.Append("PDD003=@PDD003,");
strSql.Append("PDD004=@PDD004,");
strSql.Append("PDD005=@PDD005,");
strSql.Append("PDD006=@PDD006,");
strSql.Append("PDD007=@PDD007,");
strSql.Append("PDD008=@PDD008,");
strSql.Append("PDD009=@PDD009,");
strSql.Append("PDD001=@PDD001 ");
strSql.Append("WHERE ");
strSql.Append("PDD002=@PDD002 AND PDD011=@PDD011 AND PDD012=@PDD012");
SqlParameter [] parameter =
{
new SqlParameter("@PDD001", SqlDbType.NVarChar, 200),
new SqlParameter("@PDD002", SqlDbType.NVarChar, 10),
new SqlParameter("@PDD003", SqlDbType.NVarChar, 200),
new SqlParameter("@PDD004", SqlDbType.NVarChar, 200),
new SqlParameter("@PDD005", SqlDbType.NVarChar, 200),
new SqlParameter("@PDD006", SqlDbType.Int),
new SqlParameter("@PDD007", SqlDbType.NVarChar, 200),
new SqlParameter("@PDD008", SqlDbType.NVarChar, 200),
new SqlParameter("@PDD009", SqlDbType.NVarChar, 200),
new SqlParameter("@PDD011", SqlDbType.NVarChar, 200),
new SqlParameter("@PDD012", SqlDbType.NVarChar, 200)
};
parameter [0].Value = _pdd.PDD001;
parameter [1].Value = _pdd.PDD002;
parameter [2].Value = _pdd.PDD003;
parameter [3].Value = _pdd.PDD004;
parameter [4].Value = _pdd.PDD005;
parameter [5].Value = _pdd.PDD006;
parameter [6].Value = _pdd.PDD007;
parameter [7].Value = _pdd.PDD008;
parameter [8].Value = _pdd.PDD009;
parameter [9].Value = _pdd.PDD011;
parameter [10].Value = _pdd.PDD012;
SQLString.Add(strSql, parameter);
}
