public void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtF_FimaryCode.Text.Trim().Length == 0)
{
strErr += "家庭编号不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtF_RecordTime.Text))
{
strErr += "记录时间格式错误！\\n";
}
if (!PageValidate.IsDateTime(txtF_StartTime.Text))
{
strErr += "发生时间格式错误！\\n";
}
if (!PageValidate.IsDateTime(txtF_endTime.Text))
{
strErr += "结束时间格式错误！\\n";
}
if (this.txtF_OverviewProblem.Text.Trim().Length == 0)
{
strErr += "问题概述不能为空！\\n";
}
if (this.txtF_DetailProblem.Text.Trim().Length == 0)
{
strErr += "问题详述不能为空！\\n";
}
if (!PageValidate.IsNumber(txtF_FillingUserID.Text))
{
strErr += "建档医生格式错误！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string F_FimaryCode = this.txtF_FimaryCode.Text;
DateTime F_RecordTime = DateTime.Parse(this.txtF_RecordTime.Text);
DateTime F_StartTime = DateTime.Parse(this.txtF_StartTime.Text);
DateTime F_endTime = DateTime.Parse(this.txtF_endTime.Text);
string F_OverviewProblem = this.txtF_OverviewProblem.Text;
string F_DetailProblem = this.txtF_DetailProblem.Text;
int F_FillingUserID = int.Parse(this.txtF_FillingUserID.Text);
Maticsoft.Model.record_FimaryProblem model = new Maticsoft.Model.record_FimaryProblem();
model.F_FimaryCode = F_FimaryCode;
model.F_RecordTime = F_RecordTime;
model.F_StartTime = F_StartTime;
model.F_endTime = F_endTime;
model.F_OverviewProblem = F_OverviewProblem;
model.F_DetailProblem = F_DetailProblem;
model.F_FillingUserID = F_FillingUserID;
Maticsoft.BLL.record_FimaryProblem bll = new Maticsoft.BLL.record_FimaryProblem();
bll.Update(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "list.aspx");
}
public void btnSave_Click(object sender, EventArgs e)
{
string strErr="";
if(this.txtF_FimaryCode.Text.Trim().Length==0)
{
strErr+="家庭编号不能为空！\\n";
}
if(!PageValidate.IsDateTime(txtF_RecordTime.Text))
{
strErr+="记录时间格式错误！\\n";
}
if(!PageValidate.IsDateTime(txtF_StartTime.Text))
{
strErr+="发生时间格式错误！\\n";
}
if(!PageValidate.IsDateTime(txtF_endTime.Text))
{
strErr+="结束时间格式错误！\\n";
}
if(this.txtF_OverviewProblem.Text.Trim().Length==0)
{
strErr+="问题概述不能为空！\\n";
}
if(this.txtF_DetailProblem.Text.Trim().Length==0)
{
strErr+="问题详述不能为空！\\n";
}
if(!PageValidate.IsNumber(txtF_FillingUserID.Text))
{
strErr+="建档医生格式错误！\\n";
}
if(strErr!="")
{
MessageBox.Show(this,strErr);
return;
}
string F_FimaryCode=this.txtF_FimaryCode.Text;
DateTime F_RecordTime=DateTime.Parse(this.txtF_RecordTime.Text);
DateTime F_StartTime=DateTime.Parse(this.txtF_StartTime.Text);
DateTime F_endTime=DateTime.Parse(this.txtF_endTime.Text);
string F_OverviewProblem=this.txtF_OverviewProblem.Text;
string F_DetailProblem=this.txtF_DetailProblem.Text;
int F_FillingUserID=int.Parse(this.txtF_FillingUserID.Text);
Maticsoft.Model.record_FimaryProblem model=new Maticsoft.Model.record_FimaryProblem();
model.F_FimaryCode=F_FimaryCode;
model.F_RecordTime=F_RecordTime;
model.F_StartTime=F_StartTime;
model.F_endTime=F_endTime;
model.F_OverviewProblem=F_OverviewProblem;
model.F_DetailProblem=F_DetailProblem;
model.F_FillingUserID=F_FillingUserID;
Maticsoft.BLL.record_FimaryProblem bll=new Maticsoft.BLL.record_FimaryProblem();
bll.Update(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this,"保存成功！","list.aspx");
}
private void ShowInfo()
{
Maticsoft.BLL.record_FimaryProblem bll = new Maticsoft.BLL.record_FimaryProblem();
Maticsoft.Model.record_FimaryProblem model = bll.GetModel();
this.lblF_FimaryCode.Text = model.F_FimaryCode;
this.lblF_RecordTime.Text = model.F_RecordTime.ToString();
this.lblF_StartTime.Text = model.F_StartTime.ToString();
this.lblF_endTime.Text = model.F_endTime.ToString();
this.lblF_OverviewProblem.Text = model.F_OverviewProblem;
this.lblF_DetailProblem.Text = model.F_DetailProblem;
this.lblF_FillingUserID.Text = model.F_FillingUserID.ToString();
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.record_FimaryProblem model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update record_FimaryProblem set ");
strSql.Append("F_FimaryCode=@F_FimaryCode,");
strSql.Append("F_RecordTime=@F_RecordTime,");
strSql.Append("F_StartTime=@F_StartTime,");
strSql.Append("F_endTime=@F_endTime,");
strSql.Append("F_OverviewProblem=@F_OverviewProblem,");
strSql.Append("F_DetailProblem=@F_DetailProblem,");
strSql.Append("F_FillingUserID=@F_FillingUserID");
strSql.Append(" where ");
SqlParameter[] parameters =
{
new SqlParameter("@F_FimaryCode", SqlDbType.VarChar, 30),
new SqlParameter("@F_RecordTime", SqlDbType.DateTime),
new SqlParameter("@F_StartTime", SqlDbType.DateTime),
new SqlParameter("@F_endTime", SqlDbType.DateTime),
new SqlParameter("@F_OverviewProblem", SqlDbType.NVarChar, 255),
new SqlParameter("@F_DetailProblem", SqlDbType.Text),
new SqlParameter("@F_FillingUserID", SqlDbType.Int, 4)
};
parameters[0].Value = model.F_FimaryCode;
parameters[1].Value = model.F_RecordTime;
parameters[2].Value = model.F_StartTime;
parameters[3].Value = model.F_endTime;
parameters[4].Value = model.F_OverviewProblem;
parameters[5].Value = model.F_DetailProblem;
parameters[6].Value = model.F_FillingUserID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.record_FimaryProblem GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 F_FimaryCode,F_RecordTime,F_StartTime,F_endTime,F_OverviewProblem,F_DetailProblem,F_FillingUserID from record_FimaryProblem ");
strSql.Append(" where ");
SqlParameter[] parameters =
{
};
Maticsoft.Model.record_FimaryProblem model = new Maticsoft.Model.record_FimaryProblem();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.record_FimaryProblem DataRowToModel(DataRow row)
{
Maticsoft.Model.record_FimaryProblem model=new Maticsoft.Model.record_FimaryProblem();
if (row != null)
{
if(row["F_FimaryCode"]!=null)
{
model.F_FimaryCode=row["F_FimaryCode"].ToString();
}
if(row["F_RecordTime"]!=null && row["F_RecordTime"].ToString()!="")
{
model.F_RecordTime=DateTime.Parse(row["F_RecordTime"].ToString());
}
if(row["F_StartTime"]!=null && row["F_StartTime"].ToString()!="")
{
model.F_StartTime=DateTime.Parse(row["F_StartTime"].ToString());
}
if(row["F_endTime"]!=null && row["F_endTime"].ToString()!="")
{
model.F_endTime=DateTime.Parse(row["F_endTime"].ToString());
}
if(row["F_OverviewProblem"]!=null)
{
model.F_OverviewProblem=row["F_OverviewProblem"].ToString();
}
if(row["F_DetailProblem"]!=null)
{
model.F_DetailProblem=row["F_DetailProblem"].ToString();
}
if(row["F_FillingUserID"]!=null && row["F_FillingUserID"].ToString()!="")
{
model.F_FillingUserID=int.Parse(row["F_FillingUserID"].ToString());
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.record_FimaryProblem DataRowToModel(DataRow row)
{
Maticsoft.Model.record_FimaryProblem model = new Maticsoft.Model.record_FimaryProblem();
if (row != null)
{
if (row["F_FimaryCode"] != null)
{
model.F_FimaryCode = row["F_FimaryCode"].ToString();
}
if (row["F_RecordTime"] != null && row["F_RecordTime"].ToString() != "")
{
model.F_RecordTime = DateTime.Parse(row["F_RecordTime"].ToString());
}
if (row["F_StartTime"] != null && row["F_StartTime"].ToString() != "")
{
model.F_StartTime = DateTime.Parse(row["F_StartTime"].ToString());
}
if (row["F_endTime"] != null && row["F_endTime"].ToString() != "")
{
model.F_endTime = DateTime.Parse(row["F_endTime"].ToString());
}
if (row["F_OverviewProblem"] != null)
{
model.F_OverviewProblem = row["F_OverviewProblem"].ToString();
}
if (row["F_DetailProblem"] != null)
{
model.F_DetailProblem = row["F_DetailProblem"].ToString();
}
if (row["F_FillingUserID"] != null && row["F_FillingUserID"].ToString() != "")
{
model.F_FillingUserID = int.Parse(row["F_FillingUserID"].ToString());
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.record_FimaryProblem GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 F_FimaryCode,F_RecordTime,F_StartTime,F_endTime,F_OverviewProblem,F_DetailProblem,F_FillingUserID from record_FimaryProblem ");
strSql.Append(" where ");
SqlParameter[] parameters = {
};
Maticsoft.Model.record_FimaryProblem model=new Maticsoft.Model.record_FimaryProblem();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
