void delete_pdu_one(Hashtable SQLString, StringBuilder strSql, MaterileEntity.MaterielPDBEntity _pdb)
{
strSql = new StringBuilder( );
strSql.Append("DELETE FROM TENPDB ");
strSql.AppendFormat("WHERE PDB001='{0}' AND PDB002='{1}'", _pdb.PDB001, _pdb.PDB002);
SQLString.Add(strSql, null);
}
void add_pdb(Hashtable SQLString, StringBuilder strSql, DataTable table, string contractNum)
{
MaterileEntity.MaterielPDBEntity _pdb = new MaterileEntity.MaterielPDBEntity( );
_pdb.PDB001 = contractNum;
DataTable dt = dt_pdb(_pdb.PDB001);
for (int i = 0; i < table.Rows.Count; i++)
{
_pdb.PDB002 = table.Rows [i] ["PDB002"].ToString( );
_pdb.PDB003 = table.Rows [i] ["PDB003"].ToString( );
if (string.IsNullOrEmpty(table.Rows [i] ["PDB004"].ToString( )))
{
_pdb.PDB004 = null;
}
else
{
_pdb.PDB004 = Convert.ToDateTime(table.Rows [i] ["PDB004"].ToString( ));
}
if (string.IsNullOrEmpty(table.Rows [i] ["PDB005"].ToString( )))
{
_pdb.PDB005 = new byte [0];
}
else
{
_pdb.PDB005 = ( byte [] )table.Rows [i] ["PDB005"];
}
if (dt.Select("PDB002='" + _pdb.PDB002 + "'").Length < 1)
{
add_pdu_one(SQLString, strSql, _pdb);
}
else
{
edit_pdu_one(SQLString, strSql, _pdb);
}
}
for (int i = 0; i < dt.Rows.Count; i++)
{
_pdb.PDB002 = dt.Rows [i] ["PDB002"].ToString( );
if (table.Select("PDB002='" + _pdb.PDB002 + "'").Length < 1)
{
delete_pdu_one(SQLString, strSql, _pdb);
}
}
}
void add_pdu_one(Hashtable SQLString, StringBuilder strSql, MaterileEntity.MaterielPDBEntity _pdb)
{
strSql = new StringBuilder( );
strSql.Append("INSERT INTO TENPDB( ");
strSql.Append("PDB001,PDB002,PDB003,PDB004,PDB005) ");
strSql.Append("VALUES (");
strSql.Append("@PDB001,@PDB002,@PDB003,@PDB004,@PDB005) ");
SqlParameter [] parameter =
{
new SqlParameter("@PDB001", SqlDbType.NVarChar, 200),
new SqlParameter("@PDB002", SqlDbType.NVarChar, 200),
new SqlParameter("@PDB003", SqlDbType.NVarChar, 20),
new SqlParameter("@PDB004", SqlDbType.Date),
new SqlParameter("@PDB005", SqlDbType.Image)
};
parameter [0].Value = _pdb.PDB001;
parameter [1].Value = _pdb.PDB002;
parameter [2].Value = _pdb.PDB003;
parameter [3].Value = _pdb.PDB004;
parameter [4].Value = _pdb.PDB005;
SQLString.Add(strSql, parameter);
}
public Form1( )
{
InitializeComponent( );
_pda = new MaterileEntity.MaterielPDAEntity( );
_pdu = new MaterileEntity.MaterielPDUEntity( );
_pdc = new MaterileEntity.MaterielPDCEntity( );
_pdb = new MaterileEntity.MaterielPDBEntity( );
_bll = new MaterielBll.Bll.MaterielBll( );
tableOne = new DataTable( );
tableTwo = new DataTable( );
tableTre = new DataTable( );
printOne = new DataTable( );
printTwo = new DataTable( );
controlUnEnable( );
Utility.GridViewMoHuSelect.SetFilter(bandedGridView1);
FieldInfo fi = typeof(DevExpress.Utils.Paint.XPaint).GetField("graphics", BindingFlags.Static | BindingFlags.NonPublic);
fi.SetValue(null, new DrawXPaint( ));
}
void edit_pdu_one(Hashtable SQLString, StringBuilder strSql, MaterileEntity.MaterielPDBEntity _pdb)
{
strSql = new StringBuilder( );
strSql.Append("UPDATE TENPDB SET ");
strSql.Append("PDB003=@PDB003,");
strSql.Append("PDB004=@PDB004,");
strSql.Append("PDB005=@PDB005 ");
strSql.Append("WHERE PDB001=@PDB001 AND PDB002=@PDB002");
SqlParameter [] parameter =
{
new SqlParameter("@PDB001", SqlDbType.NVarChar, 200),
new SqlParameter("@PDB002", SqlDbType.NVarChar, 200),
new SqlParameter("@PDB003", SqlDbType.NVarChar, 20),
new SqlParameter("@PDB004", SqlDbType.Date),
new SqlParameter("@PDB005", SqlDbType.Image)
};
parameter [0].Value = _pdb.PDB001;
parameter [1].Value = _pdb.PDB002;
parameter [2].Value = _pdb.PDB003;
parameter [3].Value = _pdb.PDB004;
parameter [4].Value = _pdb.PDB005;
SQLString.Add(strSql, parameter);
}
