KC_HL7_HN_Webservice/SqlQuery.cs

using SI.Common;
using System;


public class SqlQuery
{
    
    private Sql _QueryHCare;

    private Sql QueryHCare
    {
        get
        {
            if (_QueryHCare == null)
            {
                try
                {
                    _QueryHCare = new Sql("HealthCare");
                }
                catch
                {
                    _QueryHCare = new Sql("HealthCare");
                }
            }
            return _QueryHCare;
        }
    }

    /* 查询操作
     * QueryHCare.Command.Clear();
     * QueryHCare.Command.Add("select * from table");
     * QueryHCare.ParamByName("StartTime").SetDate(StartTime);
     * QueryHCare.ExecuteQuery();
     * 
     * 
     */
    public SqlQuery()
	{
        {
            string SqlStr = @"insert into HL7_Receive(ID,
SourceID,
MsgConID,
MsgContent,
ReceivingTime,
IP,
ReplyMsg,
TaskStatus,
MessageID, 
MessageType ,Sequeue
)
values(
@ID,
@SourceID,
@MsgConID,
@MsgContent,
@ReceivingTime,
@IP,
@ReplyMsg,
1, 
@MessageID, 
@MessageType ,@Sequeue
)";
        QueryHCare.Command.Clear();
        QueryHCare.Command.Add(SqlStr);
        QueryHCare.ParamByName("ID").SetDate(Guid.NewGuid());
        QueryHCare.ParamByName("ID").SetDate(Guid.NewGuid());
        QueryHCare.ExecuteQuery();

        }
        
	}
}