Beispiel #1
0
    protected void fetch_Click1(object sender, EventArgs e)
    {
        List <FetchRecords> fetchRecords = new List <FetchRecords>();

        for (int i = 0; i < this.notFetchOrders.Rows.Count; i++)
        {
            if (((CheckBox)notFetchOrders.Rows[i].FindControl("select")).Checked)
            {
                FetchRecords f = new FetchRecords();
                f.PatientNum  = notFetchOrders.Rows[i].Cells[1].Text.ToString();
                f.FetchTime   = System.DateTime.Now.ToString();
                f.Person      = fetchPerson.Text;
                f.medName     = notFetchOrders.Rows[i].Cells[5].Text.ToString();
                f.Amount      = Convert.ToInt32(notFetchOrders.Rows[i].Cells[4].Text);
                f.PatientName = DatabaseTool.ExeclSqlReturnItem(String.Format("select * from patient where p_number =\"{0}\" ", f.PatientNum), "p_name").ToString();
                f.MedcineNum  = notFetchOrders.Rows[i].Cells[6].Text.ToString();
                f.OrderNum    = notFetchOrders.Rows[i].Cells[7].Text.ToString();
                fetchRecords.Add(f);
            }
        }
        if (FetchRecordService.AddFetchRecords(fetchRecords) > 0)
        {
            Response.Write("<script language=javascript>window.alert('取药成功!');</script>");
            notFetchOrders.DataSource = DatabaseTool.ExecSqlReturnDataSet(String.Format("select* from orders where patient_num=\"{0}\" and isfetch=0 and type=1", patientNum.Text));
            notFetchOrders.DataBind();
        }
        else
        {
            Response.Write("<script language=javascript>window.alert('存在取药数量大于库存量失败的取药记录!');</script>");
            notFetchOrders.DataSource = DatabaseTool.ExecSqlReturnDataSet(String.Format("select* from orders where patient_num=\"{0}\" and isfetch=0 and type=1", patientNum.Text));
            notFetchOrders.DataBind();
        }
    }
Beispiel #2
0
    /* protected void searchOrders_Click(object sender, EventArgs e)
     * {
     *   notFetchOrders.DataSource = DatabaseTool.ExecSqlReturnDataSet(String.Format("select* from orders where patient_num=\"{0}\" and isfetch=0 and type=1",patientNum.Text));
     *   notFetchOrders.DataBind();
     * }*/

    /*  protected void fetch_Click(object sender, EventArgs e)
     * {
     *    List<FetchRecords> fetchRecords = new List<FetchRecords>();
     *    for(int i = 0; i < this.notFetchOrders.Rows.Count; i++)
     *    {
     *        if (((CheckBox)notFetchOrders.Rows[i].FindControl("select")).Checked)
     *        {
     *            FetchRecords f = new FetchRecords();
     *            f.PatientNum = notFetchOrders.Rows[i].Cells[1].Text.ToString();
     *            f.FetchTime = System.DateTime.Now.ToString();
     *            f.Person = fetchPerson.Text;
     *            f.medName = notFetchOrders.Rows[i].Cells[5].Text.ToString();
     *            f.Amount = Convert.ToInt32(notFetchOrders.Rows[i].Cells[4].Text);
     *            f.PatientName = DatabaseTool.ExeclSqlReturnItem(String.Format("select * from patient where p_number =\"{0}\" ", f.PatientName), "p_name").ToString();
     *            f.MedcineNum = notFetchOrders.Rows[i].Cells[6].Text.ToString();
     *            f.OrderNum = notFetchOrders.Rows[i].Cells[7].Text.ToString();
     *            fetchRecords.Add(f);
     *        }
     *    }
     *    if (FetchRecordService.AddFetchRecords(fetchRecords) > 0)
     *    {
     *        Response.Write("<script language=javascript>window.alert('取药成功!');</script>");
     *        notFetchOrders.DataSource = DatabaseTool.ExecSqlReturnDataSet(String.Format("select* from orders where patient_num=\"{0}\" and isfetch=0 and type=1", patientNum.Text));
     *        notFetchOrders.DataBind();
     *    }
     *    else
     *    {
     *        Response.Write("<script language=javascript>window.alert('存在取药数量大于库存量失败的取药记录!');</script>");
     *        notFetchOrders.DataSource = DatabaseTool.ExecSqlReturnDataSet(String.Format("select* from orders where patient_num=\"{0}\" and isfetch=0 and type=1", patientNum.Text));
     *        notFetchOrders.DataBind();
     *    }
     *
     * }*/

    protected void searchOrders_Click1(object sender, EventArgs e)
    {
        notFetchOrders.DataSource = DatabaseTool.ExecSqlReturnDataSet(String.Format("select* from orders where patient_num=\"{0}\" and isfetch=0 and type=1", patientNum.Text));
        notFetchOrders.DataBind();
    }