16,721
社区成员




#region 检测功能测试--得到指定病人的过敏史
/// <summary>
/// 得到指定病人的过敏史
/// </summary>
/// <param name="patientAllergen"></param>
/// <param name="tbName_PatientAllergen"></param>
/// <returns></returns>
public DataSet GetPatientAllergenByPatientId(cPatientAllergen patientAllergen,string tbName_PatientAllergen)
{
SqlParameter[] prams = {
data.MakeInParam("@patientid",SqlDbType.Int,4,patientAllergen.PatientId),
};
return (data.RunProcReturn("SELECT CASE C_inp_no WHEN 1 THEN CAST('1' as bit) ELSE CAST('0' as bit) END AS C_inp_no "
+",c_patient_id,c_allergen_code,c_allergen_name,c_drug_source"
+ ",c_allergen_symptom FROM his_allergen_info WHERE c_patient_id = @patientid ORDER BY c_patient_id",
prams, tbName_PatientAllergen));
}
#endregion
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if(e.Row.RowType == DataControlRowType.Header)
{
for(int i = 1;i<Zm_list.Count+1;i++)
{
e.Row.Cells[i].Text="<a herf='#'style='cursor:hand;' onclick='linkyl("+Zm_list[i-1]+")'>"+ZmName_list[i-1]+"</a>";//此处你可以添加你要的checkbox
}
}
}
//还有种方法,代码如下:
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" Width="100%" AllowPaging="True" OnPageIndexChanging="GridView1_PageIndexChanging" CssClass="Table_Bgcolor" BorderStyle="None" BorderWidth="0px" CellPadding="1" CellSpacing="1" OnRowDataBound="GridView1_RowDataBound">
<FooterStyle HorizontalAlign="Right" />
<Columns>
<asp:TemplateField HeaderText="序号">
<ItemStyle HorizontalAlign="Center" Width="5%" />
<HeaderStyle CssClass="Title_Font" />
</asp:TemplateField>
<asp:TemplateField>
<HeaderTemplate>
<asp:CheckBox ID="CheckBox2" runat="server" AutoPostBack="True" OnCheckedChanged="CheckBox2_CheckedChanged" />
</HeaderTemplate>
<ItemStyle HorizontalAlign="Center" Width="5%" />
<HeaderStyle CssClass="Title_Font" />
<ItemTemplate>
<asp:CheckBox ID="CheckBox1" runat="server" OnCheckedChanged="CheckBox1_CheckedChanged" />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="编辑">
<ItemStyle HorizontalAlign="Center" Width="5%" />
<HeaderStyle CssClass="Title_Font" HorizontalAlign="Center" />
<ItemTemplate>
<asp:ImageButton ID="ImgBtnEdit" runat="server" SkinID="Edit" ImageUrl="~/Images/edit.gif" ToolTip="编辑用户信息" OnClick="ImgBtnEdit_Click" />
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="USERNAME" HeaderText="姓名">
<ItemStyle HorizontalAlign="Center" Width="10%" />
<HeaderStyle CssClass="Title_Font" />
</asp:BoundField>
<asp:BoundField DataField="USERLOGINNAME" HeaderText="登录帐号 ">
<ItemStyle HorizontalAlign="Center" Width="10%" />
<HeaderStyle CssClass="Title_Font" />
</asp:BoundField>
<asp:BoundField DataField="COMID" HeaderText="单位">
<ItemStyle HorizontalAlign="Left" Width="10%" />
<HeaderStyle CssClass="Title_Font" />
</asp:BoundField>
<asp:BoundField DataField="TEL" HeaderText="联系电话">
<ItemStyle HorizontalAlign="Center" Width="15%" />
<HeaderStyle CssClass="Title_Font" />
</asp:BoundField>
<asp:BoundField DataField="EMAIL" HeaderText="电子邮件">
<ItemStyle HorizontalAlign="Center" Width="15%" />
<HeaderStyle CssClass="Title_Font" />
</asp:BoundField>
<asp:BoundField DataField="USERID" HeaderText="系统角色">
<ItemStyle HorizontalAlign="Center" Width="15%" />
<HeaderStyle CssClass="Title_Font" />
</asp:BoundField>
<asp:BoundField DataField="ISUSING" HeaderText="启用停用">
<ItemStyle HorizontalAlign="Center" Width="10%" />
<HeaderStyle CssClass="Title_Font" />
</asp:BoundField>
<asp:TemplateField>
<HeaderTemplate>
<asp:ImageButton ID="ImageButton1" runat="server" OnClick="ImageButton1_Click"
SkinID="Delete" ImageUrl="~/Images/delete.gif" ToolTip="点击删除所选项用户信息" OnClientClick="return confirm('确认要删除本页选中的吗?');" />
</HeaderTemplate>
<ItemStyle HorizontalAlign="Center" Width="10%" />
<HeaderStyle CssClass="Title_Font" HorizontalAlign="Center" />
<ItemTemplate>
<asp:ImageButton ID="ImageButton2" runat="server" OnClick="ImageButton1_Click1" SkinID="Delete" ImageUrl="~/Images/delete.gif" ToolTip="点击删除该项用户信息" OnClientClick="return confirm('确认要删除该项吗?');" />
</ItemTemplate>
</asp:TemplateField>
</Columns>
<RowStyle CssClass="Table_Tr_Bgcolor" />
<PagerStyle CssClass="Table_Tr_Bgcolor" HorizontalAlign="Right" />
<PagerSettings Visible="False" />
</asp:GridView>