コード例 #1
0
        public bool ExecuteTransaction()
        {
            if (!Connection())
            {
                return(false);
            }

            SqlTransaction transaction = CN.BeginTransaction();

            try
            {
                foreach (SqlCommand cmd in TransactionCommands)
                {
                    cmd.Transaction = transaction;
                    cmd.ExecuteNonQuery();
                }
                transaction.Commit();
                return(true);
            }
            catch (Exception ex)
            {
                transaction.Rollback();
                _error = ex.Message;
            }



            return(false);
        }
コード例 #2
0
ファイル: CNTests.cs プロジェクト: umamimolecule/classnames
        public void HandleFunction()
        {
            var values   = new Func <string>(() => "apple");
            var expected = "apple";

            CN.Create(values).ShouldBe(expected);
        }
コード例 #3
0
ファイル: CNTests.cs プロジェクト: umamimolecule/classnames
        public void HandleTupleWithFunction()
        {
            var values   = ("apple", new Func <bool>(() => true));
            var expected = "apple";

            CN.Create(values).ShouldBe(expected);
        }
コード例 #4
0
ファイル: CNTests.cs プロジェクト: umamimolecule/classnames
        public void HandleTuple()
        {
            var values   = ("apple", true);
            var expected = "apple";

            CN.Create(values).ShouldBe(expected);
        }
コード例 #5
0
ファイル: CNTests.cs プロジェクト: umamimolecule/classnames
        public void HandleKeyValuePair()
        {
            var values   = new KeyValuePair <string, bool>("apple", true);
            var expected = "apple";

            CN.Create(values).ShouldBe(expected);
        }
コード例 #6
0
ファイル: KCT_BuildListVessel.cs プロジェクト: nepphhh/KCT
        public List <PseudoPart> GetPseudoParts()
        {
            List <PseudoPart> retList = new List <PseudoPart>();

            ConfigNode[] partNodes = shipNode.GetNodes("PART");
            // KCTDebug.Log("partNodes count: " + partNodes.Length);

            foreach (ConfigNode CN in partNodes)
            {
                string name = CN.GetValue("part");
                string pID  = "";
                if (name != null)
                {
                    string[] split = name.Split('_');
                    name = split[0];
                    pID  = split[1];
                }
                else
                {
                    name = CN.GetValue("name");
                    pID  = CN.GetValue("uid");
                }

                //for (int i = 0; i < split.Length - 1; i++)
                //    pName += split[i];
                PseudoPart returnPart = new PseudoPart(name, pID);
                retList.Add(returnPart);
            }
            return(retList);
        }
コード例 #7
0
        public List <CreditNote> GETCNSID()
        {
            DataSet           ds  = new DataSet();
            DBHelper          db  = new DBHelper();
            List <CreditNote> CNs = new List <CreditNote>();

            if (conn.State == System.Data.ConnectionState.Closed)
            {
                try
                {
                    conn.Open();
                }
                catch (Exception ex)
                {
                    log.Error("Cannot open the Database due to: ", ex);
                    return(null);
                }
            }
            try
            {
                using (SqlCommand cmd = new SqlCommand("spr_GetDataSAPPI", conn))
                {
                    cmd.CommandType    = CommandType.StoredProcedure;
                    cmd.CommandTimeout = 300;
                    SqlDataAdapter da = new SqlDataAdapter(cmd);
                    da.Fill(ds);
                    cmd.ExecuteNonQuery();
                    conn.Close();
                }
                DataTable CreNote = ds.Tables[0];
                CNs = CreNote.AsEnumerable().
                      Select(CN => new CreditNote
                {
                    InterfaceType = CN.Field <string>("INTERFACETYPE"),
                    SalesOrg      = CN.Field <string>("SALESORG"),
                    SoldtoParty   = CN.Field <string>("SOLDTOPARTY"),
                    ShiptoParty   = CN.Field <string>("SHIPTOPARTY"),
                    OrderReason   = CN.Field <string>("ORDERREASON"),
                    OrderDate     = CN.Field <DateTime>("ORDERDATE").ToString("yyyy-MM-dd HH:mm:ss.fff",
                                                                              CultureInfo.InvariantCulture),
                    RequestDeliveryDate = CN.Field <DateTime>("REQUESTDELIVERYDATE").ToString("yyyy-MM-dd HH:mm:ss.fff",
                                                                                              CultureInfo.InvariantCulture),
                    CustomerDocument = CN.Field <string>("CUSTOMERDOCUMENT"),
                    MaterialNumber   = CN.Field <string>("MATERIALNUMBER"),
                    OrderQuantity    = CN.Field <decimal>("ORDERQUANTITY").ToString(),
                    SalesUnit        = CN.Field <string>("SALESUNIT"),
                    ConditionalType  = CN.Field <string>("CONDITIONTYPE"),
                    Amount           = CN.Field <Decimal>("AMOUNT").ToString(),
                    IONumber         = CN.Field <string>("IONUMBER"),
                    GUI = CN.Field <string>("GUI")
                }).ToList();
                log.Info("Get CreditNotes successfull total record: " + CreNote.Rows.Count);
                return(CNs);
            }
            catch (Exception ex)
            {
                log.Error("Cannot get CreditNotes due to: ", ex);
                return(null);
            }
        }
コード例 #8
0
ファイル: CNTests.cs プロジェクト: umamimolecule/classnames
        public void HandleKeyValuePairWithFunction()
        {
            var values   = new KeyValuePair <string, Func <bool> >("apple", new Func <bool>(() => true));
            var expected = "apple";

            CN.Create(values).ShouldBe(expected);
        }
コード例 #9
0
 /// <summary>
 /// Get formatted name from a CN instance.
 /// </summary>
 /// <param name="cn">CN instance.</param>
 /// <returns>Formatted name string.</returns>
 internal static string GetNameStringFromCN(CN cn)
 {
     if (cn != null)
     {
         return((string.IsNullOrEmpty(cn.prefix) ? string.Empty : cn.prefix + " ") + cn.givenname + " " + cn.familyname + (string.IsNullOrEmpty(cn.suffix) ? string.Empty : " " + cn.suffix));
     }
     else
     {
         return(null);
     }
 }
コード例 #10
0
 /// <summary>
 /// fecha a conexão
 /// </summary>
 private static void CloseConnection()
 {
     if (!(CN == null))
     {
         if (CN.State == 1)
         {
             CN.Close();
         }
         CN = null;
     }
 }
コード例 #11
0
ファイル: CNTests.cs プロジェクト: umamimolecule/classnames
        public void HandleKeyValuePairs()
        {
            var values = new object[]
            {
                new KeyValuePair <string, bool>("apple", true),
                new KeyValuePair <string, bool>("banana", false),
                new KeyValuePair <string, bool>("cherry", true)
            };
            var expected = "apple cherry";

            CN.Create(values).ShouldBe(expected);
        }
コード例 #12
0
ファイル: CNTests.cs プロジェクト: umamimolecule/classnames
        public void HandleDictionary()
        {
            var values = new Dictionary <string, bool>()
            {
                { "apple", true },
                { "banana", false },
                { "cherry", true },
            };
            var expected = "apple cherry";

            CN.Create(values).ShouldBe(expected);
        }
コード例 #13
0
ファイル: CNTests.cs プロジェクト: umamimolecule/classnames
        public void HandleTuples()
        {
            var values = new object[]
            {
                ("apple", true),
                ("banana", false),
                ("cherry", true)
            };
            var expected = "apple cherry";

            CN.Create(values).ShouldBe(expected);
        }
コード例 #14
0
ファイル: CNTests.cs プロジェクト: umamimolecule/classnames
        public void HandleFunctions()
        {
            var values = new Func <string>[]
            {
                () => "apple",
                () => null,
                () => "banana",
            };
            var expected = "apple banana";

            CN.Create(values).ShouldBe(expected);
        }
コード例 #15
0
        private void CMDCAl_Click(object sender, EventArgs e)
        {
            //Programa que asigne el valor numerico a las calificaciones dadas
            //en literal.
            //Excelente =10, Muy bien =9, Bien =8, Regular =7, Suficiente =6 y No
            //Acreditado=5
            //Silva Reyes Luis Adrian 19210549
            //Ejemplo#9B

            //Declaracion de variables
            int    CN;
            string CL;

            //Asignacion de valor
            CL = TXTCAL.Text;
            CN = 0;

            //Seleccion multiple
            switch (CL)
            {
            case "Excelente":
                CN = 10;
                break;

            case "Muy bien":
                CN = 9;
                break;

            case "Bien":
                CN = 8;
                break;

            case "Regular":
                CN = 7;
                break;

            case "Suficiente":
                CN = 6;
                break;

            case "No acreditado":
                CN = 5;
                break;

            default:
                LBLERROR.Text = "No valida";
                break;
            }
            LBLCAL1.Text = CN.ToString();
        }
コード例 #16
0
ファイル: OBR.cs プロジェクト: tristanwilson111/nHapi
        ///<summary>
        /// Returns a single repetition of ORDERING PROVIDER(OBR-16).
        /// throws HL7Exception if the repetition number is invalid.
        /// <param name="rep">The repetition number (this is a repeating field)</param>
        ///</summary>
        public CN GetORDERINGPROVIDER(int rep)
        {
            CN ret = null;

            try
            {
                IType t = this.GetField(16, rep);
                ret = (CN)t;
            } catch (System.Exception ex) {
                HapiLogFactory.GetHapiLog(GetType()).Error("Unexpected problem obtaining field value.  This is a bug.", ex);
                throw new System.Exception("An unexpected error ocurred", ex);
            }
            return(ret);
        }
コード例 #17
0
        /**
         * Returns a single repetition of RESULTS COPIES TO(ORO-3).
         * @param rep the repetition number (this is a repeating field)
         * @throws HL7Exception if the repetition number is invalid.
         */
        public CN getRESULTSCOPIESTO(int rep)
        {
            CN ret = null;

            try
            {
                Type t = this.getField(3, rep);
                ret = (CN)t;
            } catch (System.Exception ex) {
                HapiLogFactory.getHapiLog(GetType()).error("Unexpected problem obtaining field value.  This is a bug.", ex);
                throw new System.Exception("An unexpected error ocurred", ex);
            }
            return(ret);
        }
コード例 #18
0
ファイル: CNTests.cs プロジェクト: umamimolecule/classnames
        public void HandleTuplesWithFunctions()
        {
            var falseFunc = new Func <bool>(() => false);
            var trueFunc  = new Func <bool>(() => true);

            var values = new object[]
            {
                ("apple", trueFunc),
                ("banana", falseFunc),
                ("cherry", trueFunc)
            };
            var expected = "apple cherry";

            CN.Create(values).ShouldBe(expected);
        }
コード例 #19
0
ファイル: PV1.cs プロジェクト: carlhuth/GenXSource
        /// <summary> Returns a single repetition of CONSULTING DOCTOR (PV1-9).</summary>
        /// <param name="rep">the repetition number (this is a repeating field)
        /// </param>
        /// <throws>  HL7Exception if the repetition number is invalid. </throws>
        public virtual CN getCONSULTINGDOCTOR(int rep)
        {
            CN ret = null;

            try
            {
                Type t = this.getField(9, rep);
                ret = (CN)t;
            }
            catch (System.InvalidCastException)
            {
                throw new Exception();
            }
            return(ret);
        }
コード例 #20
0
        /// <summary> Returns a single repetition of COLLECTOR IDENTIFIER (OBR-10).</summary>
        /// <param name="rep">the repetition number (this is a repeating field)
        /// </param>
        /// <throws>  HL7Exception if the repetition number is invalid. </throws>
        public virtual CN getCOLLECTORIDENTIFIER(int rep)
        {
            CN ret = null;

            try
            {
                Type t = this.getField(10, rep);
                ret = (CN)t;
            }
            catch (System.InvalidCastException)
            {
                throw new Exception();
            }
            return(ret);
        }
コード例 #21
0
        /// <summary> Returns a single repetition of ORDERING PROVIDER (OBR-16).</summary>
        /// <param name="rep">the repetition number (this is a repeating field)
        /// </param>
        /// <throws>  HL7Exception if the repetition number is invalid. </throws>
        public virtual CN getORDERINGPROVIDER(int rep)
        {
            CN ret = null;

            try
            {
                Type t = this.getField(16, rep);
                ret = (CN)t;
            }
            catch (System.InvalidCastException)
            {
                throw new Exception();
            }
            return(ret);
        }
コード例 #22
0
ファイル: CNTests.cs プロジェクト: umamimolecule/classnames
        public void HandleKeyValuePairsWithFunctions()
        {
            var falseFunc = new Func <bool>(() => false);
            var trueFunc  = new Func <bool>(() => true);

            var values = new object[]
            {
                new KeyValuePair <string, Func <bool> >("apple", trueFunc),
                new KeyValuePair <string, Func <bool> >("banana", falseFunc),
                new KeyValuePair <string, Func <bool> >("cherry", trueFunc)
            };
            var expected = "apple cherry";

            CN.Create(values).ShouldBe(expected);
        }
コード例 #23
0
ファイル: OBR.cs プロジェクト: carlhuth/GenXSource
        /// <summary> Returns a single repetition of Collector Identifier (OBR-10).</summary>
        /// <param name="rep">the repetition number (this is a repeating field)
        /// </param>
        /// <throws>  HL7Exception if the repetition number is invalid. </throws>
        public virtual CN getCollectorIdentifier(int rep)
        {
            CN ret = null;

            try
            {
                Type t = this.getField(10, rep);
                ret = (CN)t;
            }
            catch (System.InvalidCastException)
            {
                throw new Exception();
            }
            return(ret);
        }
コード例 #24
0
ファイル: OBR.cs プロジェクト: carlhuth/GenXSource
        /// <summary> Returns a single repetition of Result Copies To (OBR-28).</summary>
        /// <param name="rep">the repetition number (this is a repeating field)
        /// </param>
        /// <throws>  HL7Exception if the repetition number is invalid. </throws>
        public virtual CN getResultCopiesTo(int rep)
        {
            CN ret = null;

            try
            {
                Type t = this.getField(28, rep);
                ret = (CN)t;
            }
            catch (System.InvalidCastException)
            {
                throw new Exception();
            }
            return(ret);
        }
コード例 #25
0
ファイル: CNTests.cs プロジェクト: umamimolecule/classnames
        public void HandleDictionaryWithFunction()
        {
            var falseFunc = new Func <bool>(() => false);
            var trueFunc  = new Func <bool>(() => true);

            var values = new Dictionary <string, Func <bool> >()
            {
                { "apple", trueFunc },
                { "banana", falseFunc },
                { "cherry", trueFunc },
            };
            var expected = "apple cherry";

            CN.Create(values).ShouldBe(expected);
        }
コード例 #26
0
        /// <summary> Returns a single repetition of Consulting Doctor (PV1-9).</summary>
        /// <param name="rep">the repetition number (this is a repeating field)
        /// </param>
        /// <throws>  HL7Exception if the repetition number is invalid. </throws>
        public virtual CN getConsultingDoctor(int rep)
        {
            CN ret = null;

            try
            {
                Type t = this.getField(9, rep);
                ret = (CN)t;
            }
            catch (System.InvalidCastException)
            {
                throw new Exception();
            }
            return(ret);
        }
コード例 #27
0
ファイル: ORO.cs プロジェクト: carlhuth/GenXSource
        /// <summary> Returns a single repetition of RESULTS COPIES TO (ORO-3).</summary>
        /// <param name="rep">the repetition number (this is a repeating field)
        /// </param>
        /// <throws>  HL7Exception if the repetition number is invalid. </throws>
        public virtual CN getRESULTSCOPIESTO(int rep)
        {
            CN ret = null;

            try
            {
                Type t = this.getField(3, rep);
                ret = (CN)t;
            }
            catch (System.InvalidCastException)
            {
                throw new Exception();
            }
            return(ret);
        }
コード例 #28
0
        private void CMDCAl_Click(object sender, EventArgs e)
        {
            //Programa que asigne valor numerico a las calificaciones
            //dadas en literal. A=10, M=9, B=8, R=7, S=6, N=5
            //Silva Reyes Luis Adrian 19210549
            //Ejemplo#9

            //Declaracion de variables
            int  CN;
            char CL;

            //Asignacion de valor
            CL = System.Char.Parse(TXTCAL.Text);
            CN = 0;

            //Seleccion multiple
            switch (CL)
            {
            case 'A':
                CN = 10;
                break;

            case 'M':
                CN = 9;
                break;

            case 'B':
                CN = 8;
                break;

            case 'R':
                CN = 7;
                break;

            case 'S':
                CN = 6;
                break;

            case 'N':
                CN = 5;
                break;

            default:
                LBLCAL1.Text = "No valida";
                break;
            }
            LBLCAL1.Text = CN.ToString();
        }
コード例 #29
0
        /// <summary>
        /// Creates a PersonName instance from a CN instance.
        /// </summary>
        /// <param name="name">The HL7 V2 CN instance.</param>
        /// <returns></returns>
        internal static IPersonName GetPersonNameFromCn(CN name)
        {
            IPersonName personName = BaseCDAModel.CreatePersonName();

            personName.FamilyName = name.familyname;
            personName.GivenNames = new List <string> {
                name.givenname
            };
            if (!string.IsNullOrWhiteSpace(name.prefix))
            {
                personName.Titles = new List <string> {
                    name.prefix
                };
            }

            return(personName);
        }
コード例 #30
0
 /**
  * Returns all repetitions of RESULTS COPIES TO (ORO-3).
  */
 public CN[] getRESULTSCOPIESTO()
 {
     CN[] ret = null;
     try {
         Type[] t = this.getField(3);
         ret = new CN[t.Length];
         for (int i = 0; i < ret.Length; i++)
         {
             ret[i] = (CN)t[i];
         }
     } catch (HL7Exception he) {
         HapiLogFactory.getHapiLog(this.GetType()).error("Unexpected problem obtaining field value.  This is a bug.", he);
         throw new System.Exception("An unexpected error ocurred", he);
     } catch (System.Exception cce) {
         HapiLogFactory.getHapiLog(GetType()).error("Unexpected problem obtaining field value.  This is a bug.", cce);
         throw new System.Exception("An unexpected error ocurred", cce);
     }
     return(ret);
 }
コード例 #31
0
ファイル: NDL.cs プロジェクト: xuchuansheng/GenXSource
		/// <summary> Creates a NDL.</summary>
		/// <param name="message">the Message to which this Type belongs
		/// </param>
		public NDL(Message message):base(message)
		{
			data = new Type[11];
			data[0] = new CN(message);
			data[1] = new TS(message);
			data[2] = new TS(message);
			data[3] = new IS(message, 0);
			data[4] = new IS(message, 0);
			data[5] = new IS(message, 0);
			data[6] = new HD(message);
			data[7] = new IS(message, 0);
			data[8] = new IS(message, 0);
			data[9] = new IS(message, 0);
			data[10] = new IS(message, 0);
		}