本文整理汇总了C#中OdSqlParameter类的典型用法代码示例。如果您正苦于以下问题:C# OdSqlParameter类的具体用法?C# OdSqlParameter怎么用?C# OdSqlParameter使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
OdSqlParameter类属于命名空间,在下文中一共展示了OdSqlParameter类的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Insert
///<summary>Inserts one LabPanel into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(LabPanel labPanel,bool useExistingPK)
{
if(!useExistingPK && PrefC.RandomKeys) {
labPanel.LabPanelNum=ReplicationServers.GetKey("labpanel","LabPanelNum");
}
string command="INSERT INTO labpanel (";
if(useExistingPK || PrefC.RandomKeys) {
command+="LabPanelNum,";
}
command+="PatNum,RawMessage,LabNameAddress,SpecimenCondition,SpecimenSource,ServiceId,ServiceName,MedicalOrderNum) VALUES(";
if(useExistingPK || PrefC.RandomKeys) {
command+=POut.Long(labPanel.LabPanelNum)+",";
}
command+=
POut.Long (labPanel.PatNum)+","
+DbHelper.ParamChar+"paramRawMessage,"
+"'"+POut.String(labPanel.LabNameAddress)+"',"
//DateTStamp can only be set by MySQL
+"'"+POut.String(labPanel.SpecimenCondition)+"',"
+"'"+POut.String(labPanel.SpecimenSource)+"',"
+"'"+POut.String(labPanel.ServiceId)+"',"
+"'"+POut.String(labPanel.ServiceName)+"',"
+ POut.Long (labPanel.MedicalOrderNum)+")";
if(labPanel.RawMessage==null) {
labPanel.RawMessage="";
}
OdSqlParameter paramRawMessage=new OdSqlParameter("paramRawMessage",OdDbType.Text,labPanel.RawMessage);
if(useExistingPK || PrefC.RandomKeys) {
Db.NonQ(command,paramRawMessage);
}
else {
labPanel.LabPanelNum=Db.NonQ(command,true,paramRawMessage);
}
return labPanel.LabPanelNum;
}
示例2: Insert
///<summary>Inserts one InsSub into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(InsSub insSub,bool useExistingPK)
{
if(!useExistingPK && PrefC.RandomKeys) {
insSub.InsSubNum=ReplicationServers.GetKey("inssub","InsSubNum");
}
string command="INSERT INTO inssub (";
if(useExistingPK || PrefC.RandomKeys) {
command+="InsSubNum,";
}
command+="PlanNum,Subscriber,DateEffective,DateTerm,ReleaseInfo,AssignBen,SubscriberID,BenefitNotes,SubscNote) VALUES(";
if(useExistingPK || PrefC.RandomKeys) {
command+=POut.Long(insSub.InsSubNum)+",";
}
command+=
POut.Long (insSub.PlanNum)+","
+ POut.Long (insSub.Subscriber)+","
+ POut.Date (insSub.DateEffective)+","
+ POut.Date (insSub.DateTerm)+","
+ POut.Bool (insSub.ReleaseInfo)+","
+ POut.Bool (insSub.AssignBen)+","
+"'"+POut.String(insSub.SubscriberID)+"',"
+DbHelper.ParamChar+"paramBenefitNotes,"
+"'"+POut.String(insSub.SubscNote)+"')";
if(insSub.BenefitNotes==null) {
insSub.BenefitNotes="";
}
OdSqlParameter paramBenefitNotes=new OdSqlParameter("paramBenefitNotes",OdDbType.Text,insSub.BenefitNotes);
if(useExistingPK || PrefC.RandomKeys) {
Db.NonQ(command,paramBenefitNotes);
}
else {
insSub.InsSubNum=Db.NonQ(command,true,paramBenefitNotes);
}
return insSub.InsSubNum;
}
示例3: Insert
///<summary>Inserts one EtransMessageText into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(EtransMessageText etransMessageText,bool useExistingPK)
{
if(!useExistingPK && PrefC.RandomKeys) {
etransMessageText.EtransMessageTextNum=ReplicationServers.GetKey("etransmessagetext","EtransMessageTextNum");
}
string command="INSERT INTO etransmessagetext (";
if(useExistingPK || PrefC.RandomKeys) {
command+="EtransMessageTextNum,";
}
command+="MessageText) VALUES(";
if(useExistingPK || PrefC.RandomKeys) {
command+=POut.Long(etransMessageText.EtransMessageTextNum)+",";
}
command+=
DbHelper.ParamChar+"paramMessageText)";
if(etransMessageText.MessageText==null) {
etransMessageText.MessageText="";
}
OdSqlParameter paramMessageText=new OdSqlParameter("paramMessageText",OdDbType.Text,etransMessageText.MessageText);
if(useExistingPK || PrefC.RandomKeys) {
Db.NonQ(command,paramMessageText);
}
else {
etransMessageText.EtransMessageTextNum=Db.NonQ(command,true,paramMessageText);
}
return etransMessageText.EtransMessageTextNum;
}
示例4: Insert
///<summary>Inserts one EobAttach into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(EobAttach eobAttach,bool useExistingPK)
{
if(!useExistingPK && PrefC.RandomKeys) {
eobAttach.EobAttachNum=ReplicationServers.GetKey("eobattach","EobAttachNum");
}
string command="INSERT INTO eobattach (";
if(useExistingPK || PrefC.RandomKeys) {
command+="EobAttachNum,";
}
command+="ClaimPaymentNum,DateTCreated,FileName,RawBase64) VALUES(";
if(useExistingPK || PrefC.RandomKeys) {
command+=POut.Long(eobAttach.EobAttachNum)+",";
}
command+=
POut.Long (eobAttach.ClaimPaymentNum)+","
+ POut.DateT (eobAttach.DateTCreated)+","
+"'"+POut.String(eobAttach.FileName)+"',"
+DbHelper.ParamChar+"paramRawBase64)";
if(eobAttach.RawBase64==null) {
eobAttach.RawBase64="";
}
OdSqlParameter paramRawBase64=new OdSqlParameter("paramRawBase64",OdDbType.Text,eobAttach.RawBase64);
if(useExistingPK || PrefC.RandomKeys) {
Db.NonQ(command,paramRawBase64);
}
else {
eobAttach.EobAttachNum=Db.NonQ(command,true,paramRawBase64);
}
return eobAttach.EobAttachNum;
}
示例5: Insert
///<summary>Inserts one ProcButton into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(ProcButton procButton,bool useExistingPK)
{
if(!useExistingPK && PrefC.RandomKeys) {
procButton.ProcButtonNum=ReplicationServers.GetKey("procbutton","ProcButtonNum");
}
string command="INSERT INTO procbutton (";
if(useExistingPK || PrefC.RandomKeys) {
command+="ProcButtonNum,";
}
command+="Description,ItemOrder,Category,ButtonImage) VALUES(";
if(useExistingPK || PrefC.RandomKeys) {
command+=POut.Long(procButton.ProcButtonNum)+",";
}
command+=
"'"+POut.String(procButton.Description)+"',"
+ POut.Int (procButton.ItemOrder)+","
+ POut.Long (procButton.Category)+","
+DbHelper.ParamChar+"paramButtonImage)";
if(procButton.ButtonImage==null) {
procButton.ButtonImage="";
}
OdSqlParameter paramButtonImage=new OdSqlParameter("paramButtonImage",OdDbType.Text,procButton.ButtonImage);
if(useExistingPK || PrefC.RandomKeys) {
Db.NonQ(command,paramButtonImage);
}
else {
procButton.ProcButtonNum=Db.NonQ(command,true,paramButtonImage);
}
return procButton.ProcButtonNum;
}
示例6: Insert
///<summary>Inserts one SigElementDef into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(SigElementDef sigElementDef,bool useExistingPK)
{
if(!useExistingPK && PrefC.RandomKeys) {
sigElementDef.SigElementDefNum=ReplicationServers.GetKey("sigelementdef","SigElementDefNum");
}
string command="INSERT INTO sigelementdef (";
if(useExistingPK || PrefC.RandomKeys) {
command+="SigElementDefNum,";
}
command+="LightRow,LightColor,SigElementType,SigText,Sound,ItemOrder) VALUES(";
if(useExistingPK || PrefC.RandomKeys) {
command+=POut.Long(sigElementDef.SigElementDefNum)+",";
}
command+=
POut.Byte (sigElementDef.LightRow)+","
+ POut.Int (sigElementDef.LightColor.ToArgb())+","
+ POut.Int ((int)sigElementDef.SigElementType)+","
+"'"+POut.String(sigElementDef.SigText)+"',"
+DbHelper.ParamChar+"paramSound,"
+ POut.Int (sigElementDef.ItemOrder)+")";
if(sigElementDef.Sound==null) {
sigElementDef.Sound="";
}
OdSqlParameter paramSound=new OdSqlParameter("paramSound",OdDbType.Text,sigElementDef.Sound);
if(useExistingPK || PrefC.RandomKeys) {
Db.NonQ(command,paramSound);
}
else {
sigElementDef.SigElementDefNum=Db.NonQ(command,true,paramSound);
}
return sigElementDef.SigElementDefNum;
}
示例7: Insert
///<summary>Inserts one Letter into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(Letter letter,bool useExistingPK)
{
if(!useExistingPK && PrefC.RandomKeys) {
letter.LetterNum=ReplicationServers.GetKey("letter","LetterNum");
}
string command="INSERT INTO letter (";
if(useExistingPK || PrefC.RandomKeys) {
command+="LetterNum,";
}
command+="Description,BodyText) VALUES(";
if(useExistingPK || PrefC.RandomKeys) {
command+=POut.Long(letter.LetterNum)+",";
}
command+=
"'"+POut.String(letter.Description)+"',"
+DbHelper.ParamChar+"paramBodyText)";
if(letter.BodyText==null) {
letter.BodyText="";
}
OdSqlParameter paramBodyText=new OdSqlParameter("paramBodyText",OdDbType.Text,letter.BodyText);
if(useExistingPK || PrefC.RandomKeys) {
Db.NonQ(command,paramBodyText);
}
else {
letter.LetterNum=Db.NonQ(command,true,paramBodyText);
}
return letter.LetterNum;
}
示例8: Insert
///<summary>Inserts one PatientNote into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(PatientNote patientNote,bool useExistingPK)
{
if(!useExistingPK && PrefC.RandomKeys) {
patientNote.PatNum=ReplicationServers.GetKey("patientnote","PatNum");
}
string command="INSERT INTO patientnote (";
if(useExistingPK || PrefC.RandomKeys) {
command+="PatNum,";
}
command+="FamFinancial,ApptPhone,Medical,Service,MedicalComp,Treatment) VALUES(";
if(useExistingPK || PrefC.RandomKeys) {
command+=POut.Long(patientNote.PatNum)+",";
}
command+=
"'"+POut.String(patientNote.FamFinancial)+"',"
+"'"+POut.String(patientNote.ApptPhone)+"',"
+"'"+POut.String(patientNote.Medical)+"',"
+"'"+POut.String(patientNote.Service)+"',"
+DbHelper.ParamChar+"paramMedicalComp,"
+"'"+POut.String(patientNote.Treatment)+"')";
if(patientNote.MedicalComp==null) {
patientNote.MedicalComp="";
}
OdSqlParameter paramMedicalComp=new OdSqlParameter("paramMedicalComp",OdDbType.Text,patientNote.MedicalComp);
if(useExistingPK || PrefC.RandomKeys) {
Db.NonQ(command,paramMedicalComp);
}
else {
patientNote.PatNum=Db.NonQ(command,true,paramMedicalComp);
}
return patientNote.PatNum;
}
示例9: Insert
///<summary>Inserts one UserQuery into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(UserQuery userQuery,bool useExistingPK)
{
if(!useExistingPK && PrefC.RandomKeys) {
userQuery.QueryNum=ReplicationServers.GetKey("userquery","QueryNum");
}
string command="INSERT INTO userquery (";
if(useExistingPK || PrefC.RandomKeys) {
command+="QueryNum,";
}
command+="Description,FileName,QueryText) VALUES(";
if(useExistingPK || PrefC.RandomKeys) {
command+=POut.Long(userQuery.QueryNum)+",";
}
command+=
"'"+POut.String(userQuery.Description)+"',"
+"'"+POut.String(userQuery.FileName)+"',"
+DbHelper.ParamChar+"paramQueryText)";
if(userQuery.QueryText==null) {
userQuery.QueryText="";
}
OdSqlParameter paramQueryText=new OdSqlParameter("paramQueryText",OdDbType.Text,userQuery.QueryText);
if(useExistingPK || PrefC.RandomKeys) {
Db.NonQ(command,paramQueryText);
}
else {
userQuery.QueryNum=Db.NonQ(command,true,paramQueryText);
}
return userQuery.QueryNum;
}
示例10: Insert
///<summary>Inserts one EhrSummaryCcd into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(EhrSummaryCcd ehrSummaryCcd,bool useExistingPK)
{
if(!useExistingPK && PrefC.RandomKeys) {
ehrSummaryCcd.EhrSummaryCcdNum=ReplicationServers.GetKey("ehrsummaryccd","EhrSummaryCcdNum");
}
string command="INSERT INTO ehrsummaryccd (";
if(useExistingPK || PrefC.RandomKeys) {
command+="EhrSummaryCcdNum,";
}
command+="PatNum,DateSummary,ContentSummary) VALUES(";
if(useExistingPK || PrefC.RandomKeys) {
command+=POut.Long(ehrSummaryCcd.EhrSummaryCcdNum)+",";
}
command+=
POut.Long (ehrSummaryCcd.PatNum)+","
+ POut.Date (ehrSummaryCcd.DateSummary)+","
+DbHelper.ParamChar+"paramContentSummary)";
if(ehrSummaryCcd.ContentSummary==null) {
ehrSummaryCcd.ContentSummary="";
}
OdSqlParameter paramContentSummary=new OdSqlParameter("paramContentSummary",OdDbType.Text,ehrSummaryCcd.ContentSummary);
if(useExistingPK || PrefC.RandomKeys) {
Db.NonQ(command,paramContentSummary);
}
else {
ehrSummaryCcd.EhrSummaryCcdNum=Db.NonQ(command,true,paramContentSummary);
}
return ehrSummaryCcd.EhrSummaryCcdNum;
}
示例11: Insert
///<summary>Inserts one ProcNote into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(ProcNote procNote,bool useExistingPK)
{
if(!useExistingPK && PrefC.RandomKeys) {
procNote.ProcNoteNum=ReplicationServers.GetKey("procnote","ProcNoteNum");
}
string command="INSERT INTO procnote (";
if(useExistingPK || PrefC.RandomKeys) {
command+="ProcNoteNum,";
}
command+="PatNum,ProcNum,EntryDateTime,UserNum,Note,SigIsTopaz,Signature) VALUES(";
if(useExistingPK || PrefC.RandomKeys) {
command+=POut.Long(procNote.ProcNoteNum)+",";
}
command+=
POut.Long (procNote.PatNum)+","
+ POut.Long (procNote.ProcNum)+","
+ DbHelper.Now()+","
+ POut.Long (procNote.UserNum)+","
+DbHelper.ParamChar+"paramNote,"
+ POut.Bool (procNote.SigIsTopaz)+","
+"'"+POut.String(procNote.Signature)+"')";
if(procNote.Note==null) {
procNote.Note="";
}
OdSqlParameter paramNote=new OdSqlParameter("paramNote",OdDbType.Text,procNote.Note);
if(useExistingPK || PrefC.RandomKeys) {
Db.NonQ(command,paramNote);
}
else {
procNote.ProcNoteNum=Db.NonQ(command,true,paramNote);
}
return procNote.ProcNoteNum;
}
示例12: Insert
///<summary>Inserts one HL7Msg into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(HL7Msg hL7Msg,bool useExistingPK)
{
if(!useExistingPK && PrefC.RandomKeys) {
hL7Msg.HL7MsgNum=ReplicationServers.GetKey("hl7msg","HL7MsgNum");
}
string command="INSERT INTO hl7msg (";
if(useExistingPK || PrefC.RandomKeys) {
command+="HL7MsgNum,";
}
command+="HL7Status,MsgText,AptNum) VALUES(";
if(useExistingPK || PrefC.RandomKeys) {
command+=POut.Long(hL7Msg.HL7MsgNum)+",";
}
command+=
POut.Int ((int)hL7Msg.HL7Status)+","
+DbHelper.ParamChar+"paramMsgText,"
+ POut.Long (hL7Msg.AptNum)+")";
if(hL7Msg.MsgText==null) {
hL7Msg.MsgText="";
}
OdSqlParameter paramMsgText=new OdSqlParameter("paramMsgText",OdDbType.Text,hL7Msg.MsgText);
if(useExistingPK || PrefC.RandomKeys) {
Db.NonQ(command,paramMsgText);
}
else {
hL7Msg.HL7MsgNum=Db.NonQ(command,true,paramMsgText);
}
return hL7Msg.HL7MsgNum;
}
示例13: Insert
///<summary>Usually set useExistingPK=true. Inserts one Documentm into the database.</summary>
internal static long Insert(Documentm documentm,bool useExistingPK){
if(!useExistingPK) {
documentm.DocNum=ReplicationServers.GetKey("documentm","DocNum");
}
string command="INSERT INTO documentm (";
command+="DocNum,";
command+="CustomerNum,PatNum,RawBase64) VALUES(";
command+=POut.Long(documentm.DocNum)+",";
command+=
POut.Long (documentm.CustomerNum)+","
+ POut.Long (documentm.PatNum)+","
+DbHelper.ParamChar+"paramRawBase64)";
if(documentm.RawBase64==null) {
documentm.RawBase64="";
}
OdSqlParameter paramRawBase64=new OdSqlParameter("paramRawBase64",OdDbType.Text,documentm.RawBase64);
Db.NonQ(command,paramRawBase64);//There is no autoincrement in the mobile server.
return documentm.DocNum;
}
示例14: Insert
///<summary>Inserts one Payment into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(Payment payment,bool useExistingPK)
{
if(!useExistingPK && PrefC.RandomKeys) {
payment.PayNum=ReplicationServers.GetKey("payment","PayNum");
}
string command="INSERT INTO payment (";
if(useExistingPK || PrefC.RandomKeys) {
command+="PayNum,";
}
command+="PayType,PayDate,PayAmt,CheckNum,BankBranch,PayNote,IsSplit,PatNum,ClinicNum,DateEntry,DepositNum,Receipt,IsRecurringCC) VALUES(";
if(useExistingPK || PrefC.RandomKeys) {
command+=POut.Long(payment.PayNum)+",";
}
command+=
POut.Long (payment.PayType)+","
+ POut.Date (payment.PayDate)+","
+"'"+POut.Double(payment.PayAmt)+"',"
+"'"+POut.String(payment.CheckNum)+"',"
+"'"+POut.String(payment.BankBranch)+"',"
+"'"+POut.String(payment.PayNote)+"',"
+ POut.Bool (payment.IsSplit)+","
+ POut.Long (payment.PatNum)+","
+ POut.Long (payment.ClinicNum)+","
+ DbHelper.Now()+","
+ POut.Long (payment.DepositNum)+","
+DbHelper.ParamChar+"paramReceipt,"
+ POut.Bool (payment.IsRecurringCC)+")";
if(payment.Receipt==null) {
payment.Receipt="";
}
OdSqlParameter paramReceipt=new OdSqlParameter("paramReceipt",OdDbType.Text,payment.Receipt);
if(useExistingPK || PrefC.RandomKeys) {
Db.NonQ(command,paramReceipt);
}
else {
payment.PayNum=Db.NonQ(command,true,paramReceipt);
}
return payment.PayNum;
}
示例15: Insert
///<summary>Inserts one Task into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(Task task,bool useExistingPK)
{
if(!useExistingPK && PrefC.RandomKeys) {
task.TaskNum=ReplicationServers.GetKey("task","TaskNum");
}
string command="INSERT INTO task (";
if(useExistingPK || PrefC.RandomKeys) {
command+="TaskNum,";
}
command+="TaskListNum,DateTask,KeyNum,Descript,TaskStatus,IsRepeating,DateType,FromNum,ObjectType,DateTimeEntry,UserNum,DateTimeFinished) VALUES(";
if(useExistingPK || PrefC.RandomKeys) {
command+=POut.Long(task.TaskNum)+",";
}
command+=
POut.Long (task.TaskListNum)+","
+ POut.Date (task.DateTask)+","
+ POut.Long (task.KeyNum)+","
+DbHelper.ParamChar+"paramDescript,"
+ POut.Int ((int)task.TaskStatus)+","
+ POut.Bool (task.IsRepeating)+","
+ POut.Int ((int)task.DateType)+","
+ POut.Long (task.FromNum)+","
+ POut.Int ((int)task.ObjectType)+","
+ POut.DateT (task.DateTimeEntry)+","
+ POut.Long (task.UserNum)+","
+ POut.DateT (task.DateTimeFinished)+")";
if(task.Descript==null) {
task.Descript="";
}
OdSqlParameter paramDescript=new OdSqlParameter("paramDescript",OdDbType.Text,task.Descript);
if(useExistingPK || PrefC.RandomKeys) {
Db.NonQ(command,paramDescript);
}
else {
task.TaskNum=Db.NonQ(command,true,paramDescript);
}
return task.TaskNum;
}