public static ModelMedicalRecord getById(int intId)
{
string strSQL = @"SELECT * FROM medical_record WHERE id = @id";
MySqlParameter[] aryParams = new MySqlParameter[1];
aryParams[0] = new MySqlParameter("@id", intId);
DataTable objDT = HelperMySql.GetDataTable(strSQL, aryParams);
if (objDT == null || objDT.Rows.Count <= 0)
{
return(null);
}
ModelMedicalRecord model = new ModelMedicalRecord();
model.id = Convert.ToInt32(objDT.Rows[0]["id"]);
model.sickbed_number = Convert.ToString(objDT.Rows[0]["sickbed_number"]);
model.name_real = Convert.ToString(objDT.Rows[0]["name_real"]);
model.sex = Convert.ToString(objDT.Rows[0]["sex"]);
model.birthday = Convert.ToDateTime(objDT.Rows[0]["birthday"]);
model.department = Convert.ToString(objDT.Rows[0]["department"]);
model.name_disease = Convert.ToString(objDT.Rows[0]["name_disease"]);
model.time_in = Convert.ToDateTime(objDT.Rows[0]["time_in"]);
model.time_out = Convert.ToDateTime(objDT.Rows[0]["time_out"]);
model.situation_out = Convert.ToString(objDT.Rows[0]["situation_out"]);
model.situation_in = Convert.ToString(objDT.Rows[0]["situation_in"]);
model.photo_urls = Convert.ToString(objDT.Rows[0]["photo_urls"]);
model.comment = Convert.ToString(objDT.Rows[0]["comment"]);
model.time_create = Convert.ToDateTime(objDT.Rows[0]["time_create"]);
model.id_admin = Convert.ToInt32(objDT.Rows[0]["id_admin"]);
model.is_deleted = Convert.ToInt16(objDT.Rows[0]["is_deleted"]);
return(model);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int intAdminId = HelperUtility.hasPurviewPage("MedicalRecord_update");
ViewState["AdminId"] = intAdminId;
// 本页只能从list.aspx的编辑页转过来
// 因此要得到要修改的id值和页面的page值用于修改成功后返回
int intId = HelperUtility.getQueryInt("id");
ViewState["id"] = intId;
int intPage = HelperUtility.getQueryInt("page");
ViewState["page"] = intPage;
// 根据入库单id查询得到入库单model
ModelMedicalRecord model = BllMedicalRecord.getById(intId);
tbSickbedNumber.Value = model.sickbed_number;
tbNameReal.Value = model.name_real;
rblSex.SelectedValue = model.sex;
tbBirthday.Value = model.birthday.ToString("yyyy-MM-dd");
tbDepartment.Value = model.department;
tbNameDisease.Value = model.name_disease;
tbTimeIn.Value = model.time_in.ToString("yyyy-MM-dd");
tbTimeOut.Value = model.time_out.ToString("yyyy-MM-dd");
cblSituationOut.SelectedValue = model.situation_out;
tbComment.Text = model.comment;
string strPhotoUrls = model.photo_urls;
if (!"".Equals(strPhotoUrls))
{
string strImgUrl, strJS;
List <string> listPhotoUrls = strPhotoUrls.Split(',').ToList();
intPhotoAmounts = listPhotoUrls.Count;
for (int i = 0; i < intPhotoAmounts; i++)
{
strImgUrl = listPhotoUrls[i];
strJS = "<div id=\"img-" + i + "\" class=\"wrapper-photo-show\">";
strJS += "<img width=\"100\" height=\"100\" src=\"" + strImgUrl + "\" /><br />";
strJS += "<input type=\"button\" id=\"btnDelPhoto\" class=\"btn btn-sm btn-warning\"" +
" onclick=\"delPhoto(" + i + ")\" value=\"删除\" /></div>";
ltrShowPhoto.Text += strJS;
}
}
tbPhotoUrls.Value = strPhotoUrls;
}
}
public static void update(ModelMedicalRecord model)
{
string strSQL = @"
UPDATE medical_record
SET
sickbed_number = @sickbed_number,
name_real = @name_real,
sex = @sex,
birthday = @birthday,
department = @department,
name_disease = @name_disease,
time_in = @time_in,
time_out = @time_out,
situation_out = @situation_out,
situation_in = @situation_in,
photo_urls = @photo_urls,
comment = @comment,
time_create = @time_create,
id_admin = @id_admin,
is_deleted = @is_deleted
WHERE
id = @id
";
MySqlParameter[] aryParams = new MySqlParameter[16];
aryParams[0] = new MySqlParameter("@sickbed_number", model.sickbed_number);
aryParams[1] = new MySqlParameter("@name_real", model.name_real);
aryParams[2] = new MySqlParameter("@sex", model.sex);
aryParams[3] = new MySqlParameter("@birthday", model.birthday);
aryParams[4] = new MySqlParameter("@department", model.department);
aryParams[5] = new MySqlParameter("@name_disease", model.name_disease);
aryParams[6] = new MySqlParameter("@time_in", model.time_in);
aryParams[7] = new MySqlParameter("@time_out", model.time_out);
aryParams[8] = new MySqlParameter("@situation_out", model.situation_out);
aryParams[9] = new MySqlParameter("@situation_in", model.situation_in);
aryParams[10] = new MySqlParameter("@photo_urls", model.photo_urls);
aryParams[11] = new MySqlParameter("@comment", model.comment);
aryParams[12] = new MySqlParameter("@time_create", model.time_create);
aryParams[13] = new MySqlParameter("@id_admin", model.id_admin);
aryParams[14] = new MySqlParameter("@is_deleted", model.is_deleted);
aryParams[15] = new MySqlParameter("@id", model.id);
HelperMySql.ExecuteNonQuery(strSQL, aryParams);
}
public static int add(ModelMedicalRecord model)
{
return(DalMedicalRecord.add(model));
}
public static void update(ModelMedicalRecord model)
{
DalMedicalRecord.update(model);
}
public static int add(ModelMedicalRecord model)
{
string strSQL = @"
INSERT INTO medical_record (
sickbed_number,
name_real,
sex,
birthday,
department,
name_disease,
time_in,
time_out,
situation_out,
situation_in,
photo_urls,
comment,
time_create,
id_admin,
is_deleted
) VALUES (
@sickbed_number,
@name_real,
@sex,
@birthday,
@department,
@name_disease,
@time_in,
@time_out,
@situation_out,
@situation_in,
@photo_urls,
@comment,
@time_create,
@id_admin,
@is_deleted
)";
MySqlParameter[] aryParams = new MySqlParameter[15];
aryParams[0] = new MySqlParameter("@sickbed_number", model.sickbed_number);
aryParams[1] = new MySqlParameter("@name_real", model.name_real);
aryParams[2] = new MySqlParameter("@sex", model.sex);
aryParams[3] = new MySqlParameter("@birthday", model.birthday);
aryParams[4] = new MySqlParameter("@department", model.department);
aryParams[5] = new MySqlParameter("@name_disease", model.name_disease);
aryParams[6] = new MySqlParameter("@time_in", model.time_in);
aryParams[7] = new MySqlParameter("@time_out", model.time_out);
aryParams[8] = new MySqlParameter("@situation_out", model.situation_out);
aryParams[9] = new MySqlParameter("@situation_in", model.situation_in);
aryParams[10] = new MySqlParameter("@photo_urls", model.photo_urls);
aryParams[11] = new MySqlParameter("@comment", model.comment);
aryParams[12] = new MySqlParameter("@time_create", model.time_create);
aryParams[13] = new MySqlParameter("@id_admin", model.id_admin);
aryParams[14] = new MySqlParameter("@is_deleted", model.is_deleted);
if (HelperMySql.ExecuteNonQuery(strSQL, aryParams) > 0)
{
strSQL = "SELECT MAX(id) FROM medical_record";
object objReturn = HelperMySql.ExecuteScalar(strSQL);
return(objReturn == null ? 0 : Convert.ToInt32(objReturn));
}
else
{
return(0);
}
}
protected void btnEdit_Click(object sender, EventArgs e)
{
if (!HelperUtility.hasPurviewOP("MedicalRecord_update"))
{
HelperUtility.showAlert("没有操作权限", "/BackManager/home.aspx");
}
int intAdminId = Convert.ToInt32(ViewState["AdminId"]);
int intId = Convert.ToInt32(ViewState["id"]);
int intPage = Convert.ToInt32(ViewState["page"]);
string strThisPageUrl = "edit.aspx?id=" + intId + "&page=" + intPage;
string strMsgError = "";
string strSickbedNumber = tbSickbedNumber.Value.Trim();
string strNameReal = tbNameReal.Value.Trim();
string strBirthday = tbBirthday.Value.Trim();
string strDepartment = tbDepartment.Value.Trim();
string strNameDisease = tbNameDisease.Value.Trim();
string strTimeIn = tbTimeIn.Value.Trim();
string strTimeOut = tbTimeOut.Value.Trim();
string strPhotoUrls = tbPhotoUrls.Value.Trim();
string strComment = tbComment.Text.Trim();
if ("".Equals(strNameReal))
{
strMsgError += "姓名不能为空！\n";
}
if ("".Equals(strBirthday))
{
strMsgError += "出生年月不能为空！\n";
}
if ("".Equals(strNameDisease))
{
strMsgError += "疾病名称不能为空！\n";
}
if ("".Equals(strTimeIn))
{
strMsgError += "入院日期不能为空！\n";
}
if ("".Equals(strTimeOut))
{
strMsgError += "出院日期不能为空！\n";
}
if (!HelperUtility.isDateType(strBirthday))
{
strMsgError += "出生年月格式不正确！\n";
}
if (!HelperUtility.isDateType(strTimeIn))
{
strMsgError += "入院日期格式不正确！\n";
}
if (!HelperUtility.isDateType(strTimeOut))
{
strMsgError += "出院日期格式不正确！\n";
}
if (!"".Equals(strMsgError))
{
HelperUtility.showAlert(strMsgError, strThisPageUrl);
}
// 验证完毕，提交数据
ModelMedicalRecord model = BllMedicalRecord.getById(intId);
model.sickbed_number = strSickbedNumber;
model.name_real = strNameReal;
model.sex = rblSex.SelectedValue.Trim();
model.birthday = Convert.ToDateTime(strBirthday);
model.department = strDepartment;
model.name_disease = strNameDisease;
model.time_in = Convert.ToDateTime(strTimeIn);
model.time_out = Convert.ToDateTime(strTimeOut);
model.situation_out = cblSituationOut.SelectedValue;
model.photo_urls = strPhotoUrls;
model.comment = strComment;
// 更新数据库记录
BllMedicalRecord.update(model);
// 跳转回列表页
Response.Redirect("/BackManager/medical_record/list.aspx?page=" + intPage);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (!HelperUtility.hasPurviewOP("MedicalRecord_add"))
{
string strUrl = "/BackManager/home.aspx";
HelperUtility.showAlert("没有操作权限", strUrl);
}
string strMsgError = "";
string strSickbedNumber = tbSickbedNumber.Value.Trim();
string strNameReal = tbNameReal.Value.Trim();
string strBirthday = tbBirthday.Value.Trim();
string strDepartment = tbDepartment.Value.Trim();
string strNameDisease = tbNameDisease.Value.Trim();
string strTimeIn = tbTimeIn.Value.Trim();
string strTimeOut = tbTimeOut.Value.Trim();
string strSituationOut = cblSituationOut.SelectedValue;
string strSituationIn = "";
string strPhotoUrls = tbPhotoUrls.Value.Trim();
string strComment = tbComment.Text.Trim();
int intAdminId = Convert.ToInt32(ViewState["AdminId"]);
if ("".Equals(strNameReal))
{
strMsgError += "姓名不能为空！\n";
}
if ("".Equals(strBirthday))
{
strMsgError += "出生年月不能为空！\n";
}
if ("".Equals(strNameDisease))
{
strMsgError += "疾病名称不能为空！\n";
}
if ("".Equals(strTimeIn))
{
strMsgError += "入院日期不能为空！\n";
}
if ("".Equals(strTimeOut))
{
strMsgError += "出院日期不能为空！\n";
}
if (!HelperUtility.isDateType(strBirthday))
{
strMsgError += "出生年月格式不正确！\n";
}
if (!HelperUtility.isDateType(strTimeIn))
{
strMsgError += "入院日期格式不正确！\n";
}
if (!HelperUtility.isDateType(strTimeOut))
{
strMsgError += "出院日期格式不正确！\n";
}
if (!"".Equals(strMsgError))
{
HelperUtility.showAlert(strMsgError, "add.aspx");
}
// 验证完毕，提交数据
ModelMedicalRecord model = new ModelMedicalRecord();
model.sickbed_number = strSickbedNumber;
model.name_real = strNameReal;
model.sex = rblSex.SelectedValue.Trim();
model.birthday = Convert.ToDateTime(strBirthday);
model.department = strDepartment;
model.name_disease = strNameDisease;
model.time_in = Convert.ToDateTime(strTimeIn);
model.time_out = Convert.ToDateTime(strTimeOut);
model.situation_out = strSituationOut;
model.situation_in = strSituationIn;
model.photo_urls = strPhotoUrls;
model.comment = strComment;
model.time_create = DateTime.Now;
model.id_admin = intAdminId;
model.is_deleted = 0;
int intId = BllMedicalRecord.add(model);
if (intId > 0)
{
string strUrl = "list.aspx";
HelperUtility.showAlert("添加成功！", strUrl);
}
else
{
string strUrl = "add.aspx";
HelperUtility.showAlert("添加失败，请联系管理员！", strUrl);
}
}
