protected void Page_Load(object sender, EventArgs e)
{
if (Session["loginModel"] == null)
{
Response.Write("<script>alert('请重新登录');opener.top.location.href='../../Default.aspx';window.close();</script>");
return;
}
id = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(Request.QueryString["id"]));
bedManagementMode = new BedManagementModel();
bedManagementBLL = new BedManagementBLL();
bedManagementMode = bedManagementBLL.GetModelById(id);
students_real_name.Text = bedManagementMode.students_real_name.ToString();
training_base_name.Text = bedManagementMode.training_base_name.ToString();
professional_base_name.Text = bedManagementMode.professional_base_name.ToString();
rotary_dept.SelectedItem.Text = bedManagementMode.dept_name.ToString();
rotary_dept.SelectedItem.Value = bedManagementMode.dept_code.ToString();
Teacher.SelectedItem.Text = bedManagementMode.TeacherName.ToString();
Teacher.SelectedItem.Value = bedManagementMode.TeacherId.ToString();
patient_name.Text = bedManagementMode.patient_name.ToString();
patient_id.Text = bedManagementMode.patient_id.ToString();
bed_id.Text = bedManagementMode.bed_id.ToString();
bed_card.Text = bedManagementMode.bed_card.ToString();
bed_price.Text = bedManagementMode.bed_price.ToString();
bed_status.Text = bedManagementMode.bed_status.ToString();
room_id.Text = bedManagementMode.room_id.ToString();
building_id.Text = bedManagementMode.building_id.ToString();
comment.Text = bedManagementMode.comment.ToString();
writor.Text = bedManagementMode.writor.ToString();
register_date.Text = bedManagementMode.register_date.ToString();
}
public bool UpdateCheckByTeacher(BedManagementModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update GP_Bed_Management set ");
strSql.Append("teacher_check=@teacher_check");
strSql.Append(" where id=@id ");
SqlParameter[] parameters =
{
new SqlParameter("@teacher_check", SqlDbType.NVarChar, 50),
new SqlParameter("@id", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.teacher_check;
parameters[1].Value = model.id;
int rows = db.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public List <Model.BedManagementModel> GetPagedList(string students_name, string training_base_code, string dept_name,
string patient_name, string bed_id, string bed_status, string room_id, string building_id,
int start, int end)
{
string sql = "select * from (select row_number() over(order by register_date desc) as num,* from GP_Bed_Management where students_name='" + students_name + "' and training_base_code='" + training_base_code + "'";
if (!string.IsNullOrEmpty(dept_name))
{
sql += "and dept_name like '%" + dept_name + "%'";
}
if (!string.IsNullOrEmpty(patient_name))
{
sql += "and patient_name like '%" + patient_name + "%'";
}
if (!string.IsNullOrEmpty(bed_id))
{
sql += "and bed_id like '%" + bed_id + "%'";
}
if (!string.IsNullOrEmpty(bed_status))
{
sql += "and bed_status like '%" + bed_status + "%'";
}
if (!string.IsNullOrEmpty(room_id))
{
sql += "and room_id like '%" + room_id + "%'";
}
if (!string.IsNullOrEmpty(building_id))
{
sql += "and building_id like '%" + building_id + "%'";
}
sql += ")as t where t.num>=@start and t.num<=@end";
SqlParameter[] pars =
{
new SqlParameter("@start", SqlDbType.Int),
new SqlParameter("@end", SqlDbType.Int)
};
pars[0].Value = start;
pars[1].Value = end;
DataTable dt = db.RunDataTable(sql, pars);
List <BedManagementModel> list = null;
if (dt.Rows.Count > 0)
{
list = new List <BedManagementModel>();
BedManagementModel model = null;
foreach (DataRow row in dt.Rows)
{
model = new BedManagementModel();
model = DataRowToModel(row);
list.Add(model);
}
}
return(list);
}
public BedManagementModel GetModelById(string id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,students_name,students_real_name,training_base_code,training_base_name,professional_base_code,professional_base_name,dept_code,dept_name,patient_name,patient_id,bed_id,bed_card,bed_price,bed_status,room_id,building_id,comment,writor,register_date,teacher_check,kzr_check,base_check,manager_check,TeacherId,TeacherName from GP_Bed_Management ");
strSql.Append(" where id=@id ");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.NVarChar, 50)
};
parameters[0].Value = id;
BedManagementModel model = new BedManagementModel();
DataSet ds = db.RunDataSet(strSql.ToString(), parameters, "tbName");
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public bool Update(BedManagementModel model, string id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update GP_Bed_Management set ");
strSql.Append("dept_code=@dept_code,");
strSql.Append("dept_name=@dept_name,");
strSql.Append("patient_name=@patient_name,");
strSql.Append("patient_id=@patient_id,");
strSql.Append("bed_id=@bed_id,");
strSql.Append("bed_card=@bed_card,");
strSql.Append("bed_price=@bed_price,");
strSql.Append("bed_status=@bed_status,");
strSql.Append("room_id=@room_id,");
strSql.Append("building_id=@building_id,");
strSql.Append("comment=@comment,");
strSql.Append("writor=@writor,");
strSql.Append("register_date=@register_date,");
strSql.Append("TeacherId=@TeacherId,");
strSql.Append("TeacherName=@TeacherName");
strSql.Append(" where id=@id ");
SqlParameter[] parameters =
{
new SqlParameter("@dept_code", SqlDbType.NVarChar, 50),
new SqlParameter("@dept_name", SqlDbType.NVarChar, 500),
new SqlParameter("@patient_name", SqlDbType.NVarChar, 50),
new SqlParameter("@patient_id", SqlDbType.NVarChar, 50),
new SqlParameter("@bed_id", SqlDbType.NVarChar, 50),
new SqlParameter("@bed_card", SqlDbType.NVarChar, 50),
new SqlParameter("@bed_price", SqlDbType.NVarChar, 50),
new SqlParameter("@bed_status", SqlDbType.NVarChar, 50),
new SqlParameter("@room_id", SqlDbType.NVarChar, 50),
new SqlParameter("@building_id", SqlDbType.NVarChar, 50),
new SqlParameter("@comment", SqlDbType.NVarChar, 1000),
new SqlParameter("@writor", SqlDbType.NVarChar, 50),
new SqlParameter("@register_date", SqlDbType.NVarChar, 50),
new SqlParameter("@TeacherId", SqlDbType.NVarChar, 50),
new SqlParameter("@TeacherName", SqlDbType.NVarChar, 50),
new SqlParameter("@id", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.dept_code;
parameters[1].Value = model.dept_name;
parameters[2].Value = model.patient_name;
parameters[3].Value = model.patient_id;
parameters[4].Value = model.bed_id;
parameters[5].Value = model.bed_card;
parameters[6].Value = model.bed_price;
parameters[7].Value = model.bed_status;
parameters[8].Value = model.room_id;
parameters[9].Value = model.building_id;
parameters[10].Value = model.comment;
parameters[11].Value = model.writor;
parameters[12].Value = model.register_date;
parameters[13].Value = model.TeacherId;
parameters[14].Value = model.TeacherName;
parameters[15].Value = id;
int rows = db.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public BedManagementModel DataRowToModel(DataRow row)
{
BedManagementModel model = new BedManagementModel();
if (row != null)
{
if (row["id"] != null)
{
model.id = row["id"].ToString();
}
if (row["students_name"] != null)
{
model.students_name = row["students_name"].ToString();
}
if (row["students_real_name"] != null)
{
model.students_real_name = row["students_real_name"].ToString();
}
if (row["training_base_code"] != null)
{
model.training_base_code = row["training_base_code"].ToString();
}
if (row["training_base_name"] != null)
{
model.training_base_name = row["training_base_name"].ToString();
}
if (row["professional_base_code"] != null)
{
model.professional_base_code = row["professional_base_code"].ToString();
}
if (row["professional_base_name"] != null)
{
model.professional_base_name = row["professional_base_name"].ToString();
}
if (row["dept_code"] != null)
{
model.dept_code = row["dept_code"].ToString();
}
if (row["dept_name"] != null)
{
model.dept_name = row["dept_name"].ToString();
}
if (row["patient_name"] != null)
{
model.patient_name = row["patient_name"].ToString();
}
if (row["patient_id"] != null)
{
model.patient_id = row["patient_id"].ToString();
}
if (row["bed_id"] != null)
{
model.bed_id = row["bed_id"].ToString();
}
if (row["bed_card"] != null)
{
model.bed_card = row["bed_card"].ToString();
}
if (row["bed_price"] != null)
{
model.bed_price = row["bed_price"].ToString();
}
if (row["bed_status"] != null)
{
model.bed_status = row["bed_status"].ToString();
}
if (row["room_id"] != null)
{
model.room_id = row["room_id"].ToString();
}
if (row["building_id"] != null)
{
model.building_id = row["building_id"].ToString();
}
if (row["comment"] != null)
{
model.comment = row["comment"].ToString();
}
if (row["writor"] != null)
{
model.writor = row["writor"].ToString();
}
if (row["register_date"] != null)
{
model.register_date = row["register_date"].ToString();
}
if (row["teacher_check"] != null)
{
model.teacher_check = row["teacher_check"].ToString();
}
if (row["kzr_check"] != null)
{
model.kzr_check = row["kzr_check"].ToString();
}
if (row["base_check"] != null)
{
model.base_check = row["base_check"].ToString();
}
if (row["manager_check"] != null)
{
model.manager_check = row["manager_check"].ToString();
}
if (row["TeacherId"] != null)
{
model.TeacherId = row["TeacherId"].ToString();
}
if (row["TeacherName"] != null)
{
model.TeacherName = row["TeacherName"].ToString();
}
}
return(model);
}
public bool Add(BedManagementModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into GP_Bed_Management(");
strSql.Append("id,students_name,students_real_name,training_base_code,training_base_name,professional_base_code,professional_base_name,dept_code,dept_name,patient_name,patient_id,bed_id,bed_card,bed_price,bed_status,room_id,building_id,comment,writor,register_date,teacher_check,kzr_check,base_check,manager_check,TeacherId,TeacherName)");
strSql.Append(" values (");
strSql.Append("@id,@students_name,@students_real_name,@training_base_code,@training_base_name,@professional_base_code,@professional_base_name,@dept_code,@dept_name,@patient_name,@patient_id,@bed_id,@bed_card,@bed_price,@bed_status,@room_id,@building_id,@comment,@writor,@register_date,@teacher_check,@kzr_check,@base_check,@manager_check,@TeacherId,@TeacherName)");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.NVarChar, 50),
new SqlParameter("@students_name", SqlDbType.NVarChar, 50),
new SqlParameter("@students_real_name", SqlDbType.NVarChar, 50),
new SqlParameter("@training_base_code", SqlDbType.NVarChar, 50),
new SqlParameter("@training_base_name", SqlDbType.NVarChar, 50),
new SqlParameter("@professional_base_code", SqlDbType.NVarChar, 50),
new SqlParameter("@professional_base_name", SqlDbType.NVarChar, 50),
new SqlParameter("@dept_code", SqlDbType.NVarChar, 50),
new SqlParameter("@dept_name", SqlDbType.NVarChar, 500),
new SqlParameter("@patient_name", SqlDbType.NVarChar, 50),
new SqlParameter("@patient_id", SqlDbType.NVarChar, 50),
new SqlParameter("@bed_id", SqlDbType.NVarChar, 50),
new SqlParameter("@bed_card", SqlDbType.NVarChar, 50),
new SqlParameter("@bed_price", SqlDbType.NVarChar, 50),
new SqlParameter("@bed_status", SqlDbType.NVarChar, 50),
new SqlParameter("@room_id", SqlDbType.NVarChar, 50),
new SqlParameter("@building_id", SqlDbType.NVarChar, 50),
new SqlParameter("@comment", SqlDbType.NVarChar, 1000),
new SqlParameter("@writor", SqlDbType.NVarChar, 50),
new SqlParameter("@register_date", SqlDbType.NVarChar, 50),
new SqlParameter("@teacher_check", SqlDbType.NVarChar, 50),
new SqlParameter("@kzr_check", SqlDbType.NVarChar, 50),
new SqlParameter("@base_check", SqlDbType.NVarChar, 50),
new SqlParameter("@manager_check", SqlDbType.NVarChar, 50),
new SqlParameter("@TeacherId", SqlDbType.NVarChar, 50),
new SqlParameter("@TeacherName", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.id;
parameters[1].Value = model.students_name;
parameters[2].Value = model.students_real_name;
parameters[3].Value = model.training_base_code;
parameters[4].Value = model.training_base_name;
parameters[5].Value = model.professional_base_code;
parameters[6].Value = model.professional_base_name;
parameters[7].Value = model.dept_code;
parameters[8].Value = model.dept_name;
parameters[9].Value = model.patient_name;
parameters[10].Value = model.patient_id;
parameters[11].Value = model.bed_id;
parameters[12].Value = model.bed_card;
parameters[13].Value = model.bed_price;
parameters[14].Value = model.bed_status;
parameters[15].Value = model.room_id;
parameters[16].Value = model.building_id;
parameters[17].Value = model.comment;
parameters[18].Value = model.writor;
parameters[19].Value = model.register_date;
parameters[20].Value = model.teacher_check;
parameters[21].Value = model.kzr_check;
parameters[22].Value = model.base_check;
parameters[23].Value = model.manager_check;
parameters[24].Value = model.TeacherId;
parameters[25].Value = model.TeacherName;
int rows = db.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["loginModel"] == null)
{
Response.Write("<script>alert('请重新登录');opener.top.location.href='../../Default.aspx';window.close();</script>");
return;
}
id = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(Request.QueryString["id"]));
pi = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(Request.QueryString["pi"]));
if (!IsPostBack)
{
loginModel = new LoginModel();
studentsPersonalInformationModel = new StudentsPersonalInformation2Model();
studentsPersonalInformationBLL = new StudentsPersonalInformation2BLL();
dt = new DataTable();
professionalBaseDeptBLL = new ProfessionalBaseDeptBLL();
loginModel = (LoginModel)Session["loginModel"];
writor.Text = loginModel.real_name;
students_real_name.Text = loginModel.real_name; students_real_name.ReadOnly = true;
if (string.IsNullOrEmpty(id))
{
register_date.Text = DateTime.Now.Date.ToString("yyyy-MM-dd");
}
na = loginModel.name;
students_name.Value = na;
tbcode = loginModel.training_base_code;
studentsPersonalInformationModel = studentsPersonalInformationBLL.GetModelByNameTBCode(na, tbcode);
if (studentsPersonalInformationModel == null)
{
Response.Write("<script> alert('请完善个人基本信息');window.close();</script>");
return;
}
else
{
TrainingBaseCode.Value = studentsPersonalInformationModel.TrainingBaseCode.ToString();
training_base_name.Text = studentsPersonalInformationModel.TrainingBaseName.ToString(); training_base_name.ReadOnly = true;
ProfessionalBaseCode.Value = studentsPersonalInformationModel.ProfessionalBaseCode.ToString();
professional_base_name.Text = studentsPersonalInformationModel.ProfessionalBaseName.ToString(); professional_base_name.ReadOnly = true;
dt = professionalBaseDeptBLL.GetDeptDataTableByCode(studentsPersonalInformationModel.ProfessionalBaseCode.ToString());
RotaryDept.DataSource = dt;
RotaryDept.DataTextField = "dept_name";
RotaryDept.DataValueField = "dept_code";
RotaryDept.DataBind();
RotaryDept.Items.Insert(0, new ListItem("==请选择==", "0"));
}
if (!string.IsNullOrEmpty(id))
{//如果不是表单提交，并且带了id值来做修改操作，则在界面上把值都呈现出来
bedManagementMode = new BedManagementModel();
bedManagementBLL = new BedManagementBLL();
bedManagementMode = bedManagementBLL.GetModelById(id);
students_real_name.Text = bedManagementMode.students_real_name.ToString();
training_base_name.Text = bedManagementMode.training_base_name.ToString();
professional_base_name.Text = bedManagementMode.professional_base_name.ToString();
//RotaryDept.SelectedItem.Text = bedManagementMode.dept_name.ToString();
RotaryDept.SelectedValue = bedManagementMode.dept_code.ToString();
//RotaryDept.Items.Insert(0, new ListItem("==请选择==", "0"));
dt = new LoginBLL().GetTeachersDtByDeptCode(bedManagementMode.training_base_code, bedManagementMode.professional_base_code, bedManagementMode.dept_code, "teachers");
Teacher.DataSource = dt;
Teacher.DataTextField = "real_name";
Teacher.DataValueField = "name";
Teacher.DataBind();
Teacher.Items.Insert(0, new ListItem("==请选择==", "0"));
Teacher.SelectedValue = bedManagementMode.TeacherId;
//Teacher.SelectedItem.Text = bedManagementMode.TeacherName.ToString();
//Teacher.SelectedItem.Value = bedManagementMode.TeacherId.ToString();
patient_name.Text = bedManagementMode.patient_name.ToString();
patient_id.Text = bedManagementMode.patient_id.ToString();
bed_id.Text = bedManagementMode.bed_id.ToString();
bed_card.Text = bedManagementMode.bed_card.ToString();
bed_price.Text = bedManagementMode.bed_price.ToString();
bed_status.Text = bedManagementMode.bed_status.ToString();
room_id.Text = bedManagementMode.room_id.ToString();
building_id.Text = bedManagementMode.building_id.ToString();
comment.Text = bedManagementMode.comment.ToString();
writor.Text = bedManagementMode.writor.ToString();
register_date.Text = bedManagementMode.register_date.ToString();
}
}
}
protected void save_Click(object sender, EventArgs e)
{
bedManagementMode = new BedManagementModel();
bedManagementBLL = new BedManagementBLL();
bedManagementMode.dept_code = CommonFunc.FilterSpecialString(RotaryDept.SelectedItem.Value);
bedManagementMode.dept_name = CommonFunc.FilterSpecialString(RotaryDept.SelectedItem.Text);
bedManagementMode.TeacherId = CommonFunc.FilterSpecialString(Teacher.SelectedItem.Value);
bedManagementMode.TeacherName = CommonFunc.FilterSpecialString(Teacher.SelectedItem.Text);
bedManagementMode.patient_name = CommonFunc.FilterSpecialString(patient_name.Text);
bedManagementMode.patient_id = CommonFunc.FilterSpecialString(patient_id.Text);
bedManagementMode.bed_id = CommonFunc.FilterSpecialString(bed_id.Text);
bedManagementMode.bed_card = CommonFunc.FilterSpecialString(bed_card.Text);
bedManagementMode.bed_price = CommonFunc.FilterSpecialString(bed_price.Text);
bedManagementMode.bed_status = CommonFunc.FilterSpecialString(bed_status.Text);
bedManagementMode.room_id = CommonFunc.FilterSpecialString(room_id.Text);
bedManagementMode.building_id = CommonFunc.FilterSpecialString(building_id.Text);
bedManagementMode.comment = CommonFunc.FilterSpecialString(comment.Text);
bedManagementMode.writor = CommonFunc.FilterSpecialString(writor.Text);
bedManagementMode.register_date = CommonFunc.FilterSpecialString(register_date.Text.Trim());
if (string.IsNullOrEmpty(id))
{
id = Guid.NewGuid().ToString();
bedManagementMode.id = id;
bedManagementMode.students_name = students_name.Value.ToString();
bedManagementMode.students_real_name = CommonFunc.FilterSpecialString(students_real_name.Text.Trim());
bedManagementMode.training_base_code = CommonFunc.FilterSpecialString(TrainingBaseCode.Value);
bedManagementMode.training_base_name = CommonFunc.FilterSpecialString(training_base_name.Text);
bedManagementMode.professional_base_code = CommonFunc.FilterSpecialString(ProfessionalBaseCode.Value);
bedManagementMode.professional_base_name = CommonFunc.FilterSpecialString(professional_base_name.Text);
bedManagementMode.teacher_check = teacher_check;
bedManagementMode.kzr_check = kzr_check;
bedManagementMode.base_check = base_check;
bedManagementMode.manager_check = manager_check;
if (bedManagementMode.dept_code == "0" || bedManagementMode.dept_name == "==请选择==")
{
ShowMessageBox.Showmessagebox(this, "轮转科室不能为空", null);
return;
}
if (bedManagementMode.TeacherId == "0" || bedManagementMode.TeacherName == "==请选择==")
{
ShowMessageBox.Showmessagebox(this, "指导医师不能为空", null);
return;
}
if (string.IsNullOrEmpty(bedManagementMode.patient_name))
{
ShowMessageBox.Showmessagebox(this, "病人姓名不能为空", null);
return;
}
if (string.IsNullOrEmpty(bedManagementMode.bed_id))
{
ShowMessageBox.Showmessagebox(this, "床位编号不能为空", null);
return;
}
if (string.IsNullOrEmpty(bedManagementMode.bed_status))
{
ShowMessageBox.Showmessagebox(this, "床位状态不能为空", null);
return;
}
if (string.IsNullOrEmpty(bedManagementMode.room_id))
{
ShowMessageBox.Showmessagebox(this, "房间号不能为空", null);
return;
}
if (string.IsNullOrEmpty(bedManagementMode.building_id))
{
ShowMessageBox.Showmessagebox(this, "所在楼不能为空", null);
return;
}
if (bedManagementMode.comment.Length > 1000)
{
ShowMessageBox.Showmessagebox(this, "备注字数不能超过1000字", null);
return;
}
if (bedManagementBLL.Add(bedManagementMode))
{
try
{
Response.Write("<script language='javascript'> alert('床位管理信息添加成功');window.opener.parent.frames.bodyFrame.frames.frmright.window.loadPageList(1);window.close();</script>");
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
}
else
{
if (bedManagementMode.dept_code == "0" || bedManagementMode.dept_name == "==请选择==")
{
ShowMessageBox.Showmessagebox(this, "轮转科室不能为空", null);
return;
}
if (string.IsNullOrEmpty(bedManagementMode.patient_name))
{
ShowMessageBox.Showmessagebox(this, "病人姓名不能为空", null);
return;
}
if (string.IsNullOrEmpty(bedManagementMode.bed_id))
{
ShowMessageBox.Showmessagebox(this, "床位编号不能为空", null);
return;
}
if (string.IsNullOrEmpty(bedManagementMode.bed_status))
{
ShowMessageBox.Showmessagebox(this, "床位状态不能为空", null);
return;
}
if (string.IsNullOrEmpty(bedManagementMode.room_id))
{
ShowMessageBox.Showmessagebox(this, "房间号不能为空", null);
return;
}
if (string.IsNullOrEmpty(bedManagementMode.building_id))
{
ShowMessageBox.Showmessagebox(this, "所在楼不能为空", null);
return;
}
if (bedManagementMode.comment.Length > 1000)
{
ShowMessageBox.Showmessagebox(this, "备注字数不能超过1000字", null);
return;
}
if (bedManagementBLL.Update(bedManagementMode, id))
{
try
{
Response.Write("<script language='javascript'> alert('床位管理信息修改成功');window.opener.window.loadPageList('" + pi + "');window.close();</script>");
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
}
}
public bool UpdateCheckByTeacher(BedManagementModel model)
{
return(bedManagementDAL.UpdateCheckByTeacher(model));
}
public bool Update(BedManagementModel model, string id)
{
return(bedManagementDAL.Update(model, id));
}
public bool Add(BedManagementModel model)
{
return(bedManagementDAL.Add(model));
}
