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 FetchRecords CreateFetchRecords(Dictionary <String, Object> dic)
{
FetchRecords fetchRecords = new FetchRecords();
fetchRecords.Person = (String)dic["fetch_person"];
fetchRecords.medName = (String)dic["med_name"];
fetchRecords.PatientName = (String)dic["patient_name"];
fetchRecords.Amount = (int)dic["amount"];
fetchRecords.PatientNum = (String)dic["patient_num"];
fetchRecords.FetchTime = (String)dic["fetch_time"];
fetchRecords.FetchNumber = (int)dic["fetch_num"];
return(fetchRecords);
}
//查询取药记录
public static List <FetchRecords> QueryFetchByNum(String patientNum)
{
List <Dictionary <String, Object> > sqlResult = DatabaseTool.ExecSqlReturn(String.Format(QUERY_FETCHRECORDS_SQL, patientNum));
List <FetchRecords> fetchRecords = new List <FetchRecords>();
if (sqlResult == null || sqlResult.Count < 1) //如果结果为空，返回空对象
{
return(fetchRecords);
}
else
{
foreach (Dictionary <String, Object> dic in sqlResult) //遍历结果集，每一条都加入list
{
fetchRecords.Add(FetchRecords.CreateFetchRecords(dic));
}
}
return(fetchRecords);
}
