/// <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; } }