/// <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( ))); }