コード例 #1
0
ファイル: Query.cs プロジェクト: mnisl/OD
		///<summary>Parameters only get displayed the first time this function is run.  After that, those parameters are used repeatedly without reprompting the user again.</summary>
		public string Get(string query,string parameters){
			if(Cancel){
				return "";
			}
			if(parameters!="" && Parameters.Count==0){//if this is the first time through
				//assemble parameters
				string[] paramList=parameters.Split(new char[] {'~'});
				string[] paramFields;
				Parameter param;
				//string fieldValue;
				for(int i=0;i<paramList.Length;i++){
					paramFields=paramList[i].Split(new char[] {';'});
					param=new Parameter();
					for(int f=0;f<paramFields.Length;f++){
						if(paramFields[f].StartsWith("Name=")){
							param.Name=paramFields[f].Replace("Name=","");
						}
						//param.OutputValue="1";//never passed in
						else if(paramFields[f].StartsWith("ValueType=")){
							switch(paramFields[f].Replace("ValueType=","")){
								case "Date":
									param.ValueType=ParamValueType.Date;
									break;
								case "String":
									param.ValueType=ParamValueType.String;
									break;
								case "Boolean":
									param.ValueType=ParamValueType.Boolean;
									break;
								case "Integer":
									param.ValueType=ParamValueType.Integer;
									break;
								case "Number":
									param.ValueType=ParamValueType.Number;
									break;
								case "Enum":
									param.ValueType=ParamValueType.Enum;
									break;
								case "QueryData":
									param.ValueType=ParamValueType.QueryData;
									break;
								default:
									MessageBox.Show("Error in ValueType field: "+paramFields[f]);
									return "";
							}
						}
						//param.CurrentValues=new ArrayList();//never passed in
						//param.defaultValues=new ArrayList();//not functional yet
						else if(paramFields[f].StartsWith("Prompt=")){
							param.Prompt=paramFields[f].Replace("Prompt=","");
						}
						else if(paramFields[f].StartsWith("Snippet=")){
							param.Snippet=paramFields[f].Replace("Snippet=","");
						}
						else if(paramFields[f].StartsWith("EnumerationType=")){
							switch(paramFields[f].Replace("EnumerationType=","")){
								case "PatientStatus":
									param.EnumerationType=EnumType.PatientStatus;
									break;
							}
						}
						else{
							MessageBox.Show("Error. Unrecognized field: "+paramFields[f]);
							return "";
						}
					}
					Parameters.Add(param);
				}
				//pass parameters to a form for display
				FormParameterInput FormP=new FormParameterInput(ref Parameters);
				FormP.ShowDialog();
				if(FormP.DialogResult==DialogResult.Cancel){
					Cancel=true;
					return "";
				}
				//MessageBox.Show("parameter info: "+parameters);
			}
			return Get(query);
		}
コード例 #2
0
ファイル: Query.cs プロジェクト: steev90/opendental
        ///<summary>Parameters only get displayed the first time this function is run.  After that, those parameters are used repeatedly without reprompting the user again.</summary>
        public string Get(string query, string parameters)
        {
            if (Cancel)
            {
                return("");
            }
            if (parameters != "" && Parameters.Count == 0)        //if this is the first time through
            //assemble parameters
            {
                string[]  paramList = parameters.Split(new char[] { '~' });
                string[]  paramFields;
                Parameter param;
                //string fieldValue;
                for (int i = 0; i < paramList.Length; i++)
                {
                    paramFields = paramList[i].Split(new char[] { ';' });
                    param       = new Parameter();
                    for (int f = 0; f < paramFields.Length; f++)
                    {
                        if (paramFields[f].StartsWith("Name="))
                        {
                            param.Name = paramFields[f].Replace("Name=", "");
                        }
                        //param.OutputValue="1";//never passed in
                        else if (paramFields[f].StartsWith("ValueType="))
                        {
                            switch (paramFields[f].Replace("ValueType=", ""))
                            {
                            case "Date":
                                param.ValueType = ParamValueType.Date;
                                break;

                            case "String":
                                param.ValueType = ParamValueType.String;
                                break;

                            case "Boolean":
                                param.ValueType = ParamValueType.Boolean;
                                break;

                            case "Integer":
                                param.ValueType = ParamValueType.Integer;
                                break;

                            case "Number":
                                param.ValueType = ParamValueType.Number;
                                break;

                            case "Enum":
                                param.ValueType = ParamValueType.Enum;
                                break;

                            case "QueryData":
                                param.ValueType = ParamValueType.QueryData;
                                break;

                            default:
                                MessageBox.Show("Error in ValueType field: " + paramFields[f]);
                                return("");
                            }
                        }
                        //param.CurrentValues=new ArrayList();//never passed in
                        //param.defaultValues=new ArrayList();//not functional yet
                        else if (paramFields[f].StartsWith("Prompt="))
                        {
                            param.Prompt = paramFields[f].Replace("Prompt=", "");
                        }
                        else if (paramFields[f].StartsWith("Snippet="))
                        {
                            param.Snippet = paramFields[f].Replace("Snippet=", "");
                        }
                        else if (paramFields[f].StartsWith("EnumerationType="))
                        {
                            switch (paramFields[f].Replace("EnumerationType=", ""))
                            {
                            case "PatientStatus":
                                param.EnumerationType = EnumType.PatientStatus;
                                break;
                            }
                        }
                        else
                        {
                            MessageBox.Show("Error. Unrecognized field: " + paramFields[f]);
                            return("");
                        }
                    }
                    Parameters.Add(param);
                }
                //pass parameters to a form for display
                FormParameterInput FormP = new FormParameterInput(ref Parameters);
                FormP.ShowDialog();
                if (FormP.DialogResult == DialogResult.Cancel)
                {
                    Cancel = true;
                    return("");
                }
                //MessageBox.Show("parameter info: "+parameters);
            }
            return(Get(query));
        }