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();
}
}
public static int JudgeFetchDuplicate(String fetchNum)
{
List <FetchRecords> fetchRecords = new List <FetchRecords>();
fetchRecords = FetchRecordService.QueryFetchByNum(fetchNum);
if (fetchRecords.Count == 0)
{
return(0);
}
else
{
return(-1);
}
}
protected void Button2_Click1(object sender, EventArgs e)
{
List <FetchRecords> fetchRecords = new List <FetchRecords>();
fetchRecords = FetchRecordService.QueryFetchByNum(patientId.Text);
if (fetchRecords.Count == 0)
{
Response.Write("<script language=javascript>window.alert('无此病人信息，请重新输入编号！');</script>");
}
else
{
addFetchRecords(fetchRecords);
}
}