/// <summary>
/// add sru
/// </summary>
/// <param name="SQLString"></param>
/// <param name="strSql"></param>
/// <param name="_model"></param>
void add_SRU(Hashtable SQLString, StringBuilder strSql, ProductionErpEntity.SingRowTableSRUEntity model)
{
strSql = new StringBuilder( );
strSql.Append("INSERT INTO MOXSRU (");
strSql.Append("SRU001,SRU002,SRU003,SRU004,SRU005,SRU006,SRU007) ");
strSql.Append("VALUES (");
strSql.Append("@SRU001,@SRU002,@SRU003,@SRU004,@SRU005,@SRU006,@SRU007) ");
SqlParameter [] parameters =
{
new SqlParameter("@SRU001", SqlDbType.NVarChar, 50),
new SqlParameter("@SRU002", SqlDbType.NVarChar, 50),
new SqlParameter("@SRU003", SqlDbType.NVarChar, 50),
new SqlParameter("@SRU004", SqlDbType.NVarChar, 50),
new SqlParameter("@SRU005", SqlDbType.NVarChar, 50),
new SqlParameter("@SRU006", SqlDbType.Int, 4),
new SqlParameter("@SRU007", SqlDbType.VarChar, 50)
};
parameters [0].Value = model.SRU001;
parameters [1].Value = model.SRU002;
parameters [2].Value = model.SRU003;
parameters [3].Value = model.SRU004;
parameters [4].Value = model.SRU005;
parameters [5].Value = model.SRU006;
parameters [6].Value = model.SRU007;
SQLString.Add(strSql, parameters);
}
/// <summary>
/// save data to sru
/// </summary>
/// <param name="table"></param>
/// <returns></returns>
public bool GenerMOXSRU(DataTable table)
{
ProductionErpEntity.SingRowTableSRUEntity _model = new ProductionErpEntity.SingRowTableSRUEntity( );
Hashtable SQLString = new Hashtable( );
StringBuilder strSql = new StringBuilder( );
Hashtable strList = new Hashtable( );
bool check = false;
_model.SRU001 = getOddNum_SRU( );
for (int i = 0; i < table.Rows.Count; i++)
{
check = string.IsNullOrEmpty(table.Rows [i] ["checkTwo"].ToString( )) == true ? false : ( bool )table.Rows [i] ["checkTwo"];
if (check)
{
_model.SRU002 = table.Rows [i] ["RAA001"].ToString( );
_model.SRU003 = table.Rows [i] ["RAA015"].ToString( );
if (Exists_SRU(_model))
{
_model.SRU004 = table.Rows [i] ["DEA002"].ToString( );
_model.SRU005 = table.Rows [i] ["DEA057"].ToString( );
_model.SRU006 = string.IsNullOrEmpty(table.Rows [i] ["RAA018"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["RAA018"].ToString( ));
_model.SRU007 = codeNum_SRU(_model.SRU002, table.Rows [i] ["DEA004"].ToString( ), strList);
add_SRU(SQLString, strSql, _model);
}
}
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
/// <summary>
/// does it exists job number and product num
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
bool Exists_SRU(ProductionErpEntity.SingRowTableSRUEntity _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("SELECT COUNT(1) FROM MOXSRU ");
strSql.AppendFormat("WHERE SRU002='{0}' AND SRU003='{1}'", _model.SRU002, _model.SRU003);
return(SqlHelper.Exists(strSql.ToString( )));
}
