/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.record_FamilyProblem DataRowToModel(DataRow row)
{
Maticsoft.Model.record_FamilyProblem model=new Maticsoft.Model.record_FamilyProblem();
if (row != null)
{
if(row["F_FamilyID"]!=null && row["F_FamilyID"].ToString()!="")
{
model.F_FamilyID=int.Parse(row["F_FamilyID"].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;
}
protected void Button2_Click(object sender, EventArgs e)
{
Maticsoft.BLL.record_FamilyProblem record_FamilyProblem_bll = new Maticsoft.BLL.record_FamilyProblem();
Maticsoft.Model.record_FamilyProblem record_FamilyProblem_model = record_FamilyProblem_bll.GetModel(FamilyID);
if (record_FamilyProblem_model == null)
{
record_FamilyProblem_model = new Maticsoft.Model.record_FamilyProblem();
}
record_FamilyProblem_model.F_RecordTime = (DateTime)Common.sink(this.F_RecordTime.UniqueID, MethodType.Post, 255, 0, DataType.Dat);
record_FamilyProblem_model.F_StartTime = (DateTime)Common.sink(this.F_StartTime.UniqueID, MethodType.Post, 255, 0, DataType.Dat);
record_FamilyProblem_model.F_endTime = (DateTime)Common.sink(this.F_endTime.UniqueID, MethodType.Post, 255, 0, DataType.Dat);
record_FamilyProblem_model.F_OverviewProblem = (string)Common.sink(this.F_OverviewProblem.UniqueID, MethodType.Post, 255, 0, DataType.Str);
record_FamilyProblem_model.F_DetailProblem = (string)Common.sink(this.F_DetailProblem.UniqueID, MethodType.Post, 255, 0, DataType.Str);
record_FamilyProblem_model.F_FillingUserID = Convert.ToInt32(this.F_FillingUserID.Value);
if (record_FamilyProblem_model.F_FamilyID == 0)
{
CMD_Txt = "增加";
record_FamilyProblem_model.F_FamilyID = FamilyID;
record_FamilyProblem_bll.Add(record_FamilyProblem_model);
}
else
{
CMD_Txt = "修改";
record_FamilyProblem_bll.Update(record_FamilyProblem_model);
}
All_Title_Txt = CMD_Txt + App_Txt;
//以下方法的第4个参数需要更改
EventMessage.MessageBox(1, "操作成功", string.Format("{1}ID({0})成功!", record_FamilyProblem_model.F_FamilyID, All_Title_Txt), Icon_Type.OK, Common.GetHomeBaseUrl("default.aspx"));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.record_FamilyProblem GetModel(int F_FamilyID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 F_FamilyID,F_RecordTime,F_StartTime,F_endTime,F_OverviewProblem,F_DetailProblem,F_FillingUserID from record_FamilyProblem ");
strSql.Append(" where F_FamilyID=@F_FamilyID ");
SqlParameter[] parameters = {
new SqlParameter("@F_FamilyID", SqlDbType.Int,4) };
parameters[0].Value = F_FamilyID;
Maticsoft.Model.record_FamilyProblem model=new Maticsoft.Model.record_FamilyProblem();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
