在else Part中插入值并选择值 [英] Inserting Value in else Part and selecting the value
本文介绍了在else Part中插入值并选择值的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
DROP PROCEDURE IF EXISTS hms.Select_Parameter1;
CREATE PROCEDURE hms.`Select_Parameter1`(_Branch_Id int,
_Tenant_Id int,
_disease_Id int,_Patient_Id int)
BEGIN
IF EXISTS
(SELECT b.Target_Value
FROM patient_progress_tracking_header b
WHERE b.DiseaseId = _disease_Id)
THEN
SELECT a.ParameterName,
a.Target_Value,
b.Measurement_Frequency,
date_format(c.Last_Date,"%y/%d/%m") as 'Last_Date',
c.Result,
date_format(c.Next_Due_Date,"%y/%d/%m") as 'Next_Due_Date',
date_format(c.Current_Test_Date,"%y/%d/%m") as 'Current_Test_Date',
c.Test_Result,
a.ParameterId
FROM patient_progress_tracking_header b
RIGHT JOIN Disease_parameter a
ON b.DiseaseId=a.DiseaseId
INNER JOIN patient_progress_tracking_details c
ON b.DiseaseId = c.DiseaseId
WHERE a.Branch_Id = _Branch_Id
AND a.Tenant_Id = _Tenant_Id
AND a.DiseaseId = _disease_Id
AND a.Patient_Id=_Patient_Id;
ELSE
Insert Into patient_progress_tracking_header(Branch_Id,Tenant_Id,Patient_Id,DiseaseId)values(_Branch_Id,_Tenant_Id,_Patient_Id,_disease_Id);
Insert Into patient_progress_tracking_details(DiseaseId,Patient_Id,Branch_Id,Tenant_Id)values(_disease_Id,_Patient_Id,_Branch_Id,_Tenant_Id);
SELECT a.ParameterName,
a.Target_Value,
b.Measurement_Frequency,
date_format(c.Last_Date,"%y/%d/%m") as 'Last_Date',
c.Result,
date_format(c.Next_Due_Date,"%y/%d/%m") as 'Next_Due_Date',
date_format(c.Current_Test_Date,"%y/%d/%m") as 'Current_Test_Date',
c.Test_Result,
a.ParameterId
FROM patient_progress_tracking_header b
RIGHT JOIN Disease_parameter a
ON b.DiseaseId =a.DiseaseId
INNER JOIN patient_progress_tracking_details c
ON b.DiseaseId = c.DiseaseId
WHERE a.Branch_Id = _Branch_Id
AND a.Tenant_Id = _Tenant_Id
AND a.DiseaseId = _disease_Id
AND a.Patient_Id=_Patient_Id;
END IF;
END;
CS file ....
protected void BindCarePlan()
{
MySqlConnection strConnection = null;
MySqlCommand strCommand = null;
try
{
strConnection = new MySqlConnection();
strConnection.ConnectionString = StrConn;
strConnection.Open();
strCommand = new MySqlCommand();
strCommand.CommandType = CommandType.StoredProcedure;
strCommand.CommandText = "Select_Parameter1";
strCommand.Connection = strConnection;
strCommand.Parameters.AddWithValue("_Tenant_Id", 1);
strCommand.Parameters.AddWithValue("_Branch_Id", 1);
strCommand.Parameters.AddWithValue("_Patient_Id", 1);
strCommand.Parameters.AddWithValue("_disease_Id", ddlselectdisease.SelectedValue);
// strCommand.Parameters.AddWithValue("_ParameterId", 1);
MySqlDataAdapter da = new MySqlDataAdapter(strCommand);
DataSet ds = new DataSet();
da.Fill(ds);
grdcareplan.DataSource = ds;
grdcareplan.DataBind();
}
catch (Exception ex)
{
obj.InfoEntry(DateTime.Now + " " + " BindCarePlan" + " " + "HomeHealthCare.aspx" + " " + ex.Message, "");
obj.InfoEntry(DateTime.Now + " " + ex.StackTrace, "");
Session["strerrormsg"] = DateTime.Now + " " + " BindCarePlan" + " " + "HomeHealthCare.aspx" + " " + ex.Message;
Session["strerrortrace"] = DateTime.Now + " " + ex.StackTrace;
Response.Redirect("ErrorPage.aspx");
}
finally
{
strCommand.Dispose();
strConnection.Close();
}
}
ASPX file
<table style="width:954px; margin-removed20px">
<tr>
<td class="leftimgboxtd">
<asp:Image ID="Image3" CssClass="leftimgboxstyle" ImageUrl="~/images/left_1.jpg"
runat="server" />
</td>
<td class="midimgboxstyle">
<table>
<tr >
<td class="popuplbltdwithpadding">
<asp:Label ID="lblPatientname" runat="server" CssClass="style2" Text="Patient Name:"></asp:Label>
</td>
<td class="popuplbltdwithpadding">
<asp:Label ID="lblname" runat="server" CssClass="LblDetailstyle" Text="Label"></asp:Label>
</td>
<td class="popuplbltdwithpadding" style="padding-removed100px">
<asp:Label ID="lblpatientregno" runat="server" CssClass="style2" Text="Reg No."></asp:Label>
</td>
<td class="popuplbltdwithpadding">
<asp:Label ID="lblregno" runat="server" CssClass="LblDetailstyle" Text="Label"></asp:Label>
</td>
<td class="popuplbltdwithpadding" style="padding-removed50px">
<asp:Label ID="Label1" runat="server" Text="Chief Complaint" CssClass="style2"></asp:Label>
</td>
<td style="vertical-align:bottom;padding-removed50px" >
<asp:DropDownList
ID="ddlselectdisease" runat="server" Height="25px" Width="209px"
CssClass="DropDownCSS" AutoPostBack="True"
onselectedindexchanged="ddlselectdisease_SelectedIndexChanged"
DataTextField="DiseaseName" DataValueField="DiseaseId" >
<asp:ListItem></asp:ListItem>
</asp:DropDownList>
</td>
</tr>
</table>
</td>
<td class="rightimgboxtd">
<asp:Image ID="Image4" CssClass="rightimgboxstyle" ImageUrl="~/images/right_1.jpg"
runat="server" />
</td>
</tr>
</table>
</td>
</tr>
</table>
<table class="allmasterpagewidth">
<tr>
<td style="height: 386px; width: 950px;" align="center"
valign="top" width="640px">
<asp:GridView ID="grdcareplan" runat="server" CellPadding="5" CssClass="CustomGrid" ShowFooter="True"
AutoGenerateColumns="False" GridLines="Horizontal" AllowPaging="True" DataKeyNames="ParameterId"
Width="950px" onselectedindexchanged="grdcareplan_SelectedIndexChanged1"
onpageindexchanging="grdcareplan_PageIndexChanging" Height="16px"
style="margin-right: 0px" onrowediting="grdcareplan_RowEditing" onrowcancelingedit="grdcareplan_RowCancelingEdit"
onrowupdating="grdcareplan_RowUpdating"
onrowdeleting="grdcareplan_RowDeleting"
EmptyDataText="No Record found for this Item">
<Columns>
<asp:CommandField EditText="<img src='~/images/HMS Buttons/edit_icon.png'/>" ShowEditButton="true" UpdateText="<img src='~/images/HMS Buttons/Upload.png'/>"/>
<asp:TemplateField>
<ItemStyle CssClass="w" />
<ItemTemplate>
<asp:ImageButton ID="Imgbtnsave" runat="server"
ImageUrl="~/images/HMS Buttons/LaunchIcon.png" CssClass="icon"
onclick="Imgbtnsave_Click"/>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="ParameterName" HeaderText="Scheduled Items"
ReadOnly="True" />
<asp:TemplateField HeaderText="Target Value">
<ItemTemplate>
<asp:Label ID="Label6" runat="server" Text='<%# Bind("Target_Value") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txttargetvalue" runat="server"
Text='<%# Bind("Target_Value") %>' CssClass="textboxInGrid"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<%--<asp:BoundField DataField="UOM" HeaderText="UOM" ReadOnly="True" />--%>
<asp:TemplateField HeaderText="Last dt">
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("Last_Date") %>'>
</asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:Label ID="Label5" runat="server" Text='<%# Bind("Last_Date") %>'></asp:Label>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Result">
<ItemTemplate>
<asp:Label ID="Label3" runat="server" Text='<%# Bind("Result") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:Label ID="Label7" runat="server" Text='<%# Bind("Result") %>'></asp:Label>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Test dt">
<ItemTemplate>
<asp:Label ID="Label9" runat="server" Text='<%# Bind("Current_Test_Date") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txttestdate" runat="server" Text='<%# Bind("Current_Test_Date") %>' CssClass="textboxInGrid"></asp:TextBox>
<asp:CalendarExtender ID="CalendarExtender1" runat="server" TargetControlID="txttestdate" Format="yy/dd/MM">
</asp:CalendarExtender>
</EditItemTemplate>
</asp:TemplateField>
<%-- <asp:BoundField HeaderText="Test Result" />--%>
<asp:TemplateField HeaderText="Test Result">
<ItemTemplate>
<asp:Label ID="Label8" runat="server" Text='<%# Bind("Test_Result") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txttestresult" runat="server" Text='<%# Bind("Test_Result") %>' CssClass="textboxInGrid"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Measurement Frequency">
<ItemTemplate>
<asp:Label ID="Label2" runat="server"
Text='<%# Bind("Measurement_Frequency") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:DropDownList ID="ddlMeasurementFrequency" runat="server" AutoPostBack="true"
onselectedindexchanged="ddlMeasurementFrequency_SelectedIndexChanged">
<asp:ListItem>Select Frequency</asp:ListItem>
<asp:ListItem Value="1">Daily</asp:ListItem>
<asp:ListItem Value="2">Weekly</asp:ListItem>
<asp:ListItem Value="3">Fortnightly</asp:ListItem>
<asp:ListItem Value="4">Monthly</asp:ListItem>
<asp:ListItem Value="5">Quarterly</asp:ListItem>
<asp:ListItem Value="6"> Half Yearly</asp:ListItem>
<asp:ListItem Value="7">Yearly</asp:ListItem>
<asp:ListItem Value="8">Others</asp:ListItem>
</asp:DropDownList>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Next Due dt">
<ItemTemplate>
<asp:Label ID="Label4" runat="server" Text='<%# Bind("Next_Due_Date") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtnextduedate" runat="server" Text='<%# Bind("Next_Due_Date") %>' CssClass="textboxInGrid"></asp:TextBox>
<asp:CalendarExtender ID="CalendarExtender2" runat="server" TargetControlID="txtnextduedate" Format="yy/dd/MM">
</asp:CalendarExtender>
</EditItemTemplate>
</asp:TemplateField>
</Columns>
<FooterStyle CssClass="GridFooter" />
<HeaderStyle CssClass="grdheaderstyle"></HeaderStyle>
<RowStyle CssClass="grdrowstyle" />
</asp:GridView>
</td>In else Part when I am Inserting Value and after that I am selecting ,Two values Of diseaseId get Inserted Into both table that is 0 and 1 for only one ParameterName,...
I want to Insert Only one record for one parameterName..what Should I do?and Also i want the target value get inserted into patient_progress_tracking_header table in else part..what should i do..
In else Part when I am Inserting Value and after that I am selecting ,Two values Of diseaseId get Inserted Into both table that is 0 and 1 for only one ParameterName,...
I want to Insert Only one record for one parameterName..what Should I do?and Also i want the target value get inserted into patient_progress_tracking_header table in else part..what should i do..
推荐答案
Hi. Firstly I suggest you to remove ASP.NET tag from you question (or please provide a code with issue) and add SQL tag to it (or T-SQL it depends which relative database engine you use).
Secondly, the first part of your question has insufficient data. It could occur due to your code or some other issues. I suggest you to create a key or constraint to prevent this. But the best solution is to check what is really happening. For example try to use SQL Server trace utility (if you are using SLQ server).
Thirdly, the second part may be solved by using OUTPUT clause in your insert statements with INSERTED table. Please refer this link for details:
http://msdn.microsoft.com/en-us/library/ms177564.aspx[^]
Hi. Firstly I suggest you to remove ASP.NET tag from you question (or please provide a code with issue) and add SQL tag to it (or T-SQL it depends which relative database engine you use).
Secondly, the first part of your question has insufficient data. It could occur due to your code or some other issues. I suggest you to create a key or constraint to prevent this. But the best solution is to check what is really happening. For example try to use SQL Server trace utility (if you are using SLQ server).
Thirdly, the second part may be solved by using OUTPUT clause in your insert statements with INSERTED table. Please refer this link for details:
http://msdn.microsoft.com/en-us/library/ms177564.aspx[^]
Check your tables for triggers, if something is happening more than is in the SQL.
This is a SQL question, it has nothing to do with ASP.NET
Check your tables for triggers, if something is happening more than is in the SQL.
This is a SQL question, it has nothing to do with ASP.NET
这篇关于在else Part中插入值并选择值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
