Пример #1
0
        internal int InsertOIStgInputCompanyMatchRefresh(OIInpCompanyEntityMatchRefresh objCompany)
        {
            int result = 0;

            try
            {
                StoredProcedureEntity sproc = new StoredProcedureEntity();
                sproc.StoredProcedureName = "oi.OIInsertStgInputCompanyMatchRefresh";
                sproc.StoredProceduresParameter.Add(GetParam("@ImportProcessId", objCompany.ImportProcessId.ToString().Trim(), SQLServerDatatype.IntDataType));
                sproc.StoredProceduresParameter.Add(GetParam("@orb_num", !string.IsNullOrEmpty(objCompany.OrbNumber) ? objCompany.OrbNumber.ToString().Trim() : null, SQLServerDatatype.VarcharDataType));
                result = Convert.ToInt32(sql.ExecuteScalar(CommandType.StoredProcedure, sproc));
            }
            catch (Exception)
            {
                throw;
            }
            return(result);
        }
Пример #2
0
 public int InsertOIStgInputCompanyMatchRefresh(OIInpCompanyEntityMatchRefresh objCompany)
 {
     return(rep.InsertOIStgInputCompanyMatchRefresh(objCompany));
 }