/// <summary> /// 更新一条数据 /// </summary> public void Update(MobileSoft.Model.HSPR.Tb_HSPR_IncidentRemindersInfo model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@InfoID", SqlDbType.BigInt, 8), new SqlParameter("@IncidentID", SqlDbType.BigInt, 8), new SqlParameter("@CommID", SqlDbType.Int, 4), new SqlParameter("@RemindersType", SqlDbType.NVarChar, 50), new SqlParameter("@RemindersDate", SqlDbType.DateTime), new SqlParameter("@UserID", SqlDbType.NVarChar, 50), new SqlParameter("@UserName", SqlDbType.NVarChar, 50), new SqlParameter("@InfoContent", SqlDbType.NVarChar, 500), new SqlParameter("@Remark", SqlDbType.NVarChar, 200), new SqlParameter("@IsSendMessage", SqlDbType.Bit, 1), new SqlParameter("@SendMessage", SqlDbType.NVarChar, 500), new SqlParameter("@IsDelete", SqlDbType.Int, 4) }; parameters[0].Value = model.InfoID; parameters[1].Value = model.IncidentID; parameters[2].Value = model.CommID; parameters[3].Value = model.RemindersType; parameters[4].Value = model.RemindersDate; parameters[5].Value = model.UserID; parameters[6].Value = model.UserName; parameters[7].Value = model.InfoContent; parameters[8].Value = model.Remark; parameters[9].Value = model.IsSendMessage; parameters[10].Value = model.SendMessage; parameters[11].Value = model.IsDelete; DbHelperSQL.RunProcedure("Proc_Tb_HSPR_IncidentRemindersInfo_Update", parameters, out rowsAffected); }
/// <summary> /// 得到一个对象实体 /// </summary> public MobileSoft.Model.HSPR.Tb_HSPR_IncidentRemindersInfo GetModel(long InfoID) { SqlParameter[] parameters = { new SqlParameter("@InfoID", SqlDbType.BigInt) }; parameters[0].Value = InfoID; MobileSoft.Model.HSPR.Tb_HSPR_IncidentRemindersInfo model = new MobileSoft.Model.HSPR.Tb_HSPR_IncidentRemindersInfo(); DataSet ds = DbHelperSQL.RunProcedure("Proc_Tb_HSPR_IncidentRemindersInfo_GetModel", parameters, "ds"); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["InfoID"].ToString() != "") { model.InfoID = long.Parse(ds.Tables[0].Rows[0]["InfoID"].ToString()); } if (ds.Tables[0].Rows[0]["IncidentID"].ToString() != "") { model.IncidentID = long.Parse(ds.Tables[0].Rows[0]["IncidentID"].ToString()); } if (ds.Tables[0].Rows[0]["CommID"].ToString() != "") { model.CommID = int.Parse(ds.Tables[0].Rows[0]["CommID"].ToString()); } model.RemindersType = ds.Tables[0].Rows[0]["RemindersType"].ToString(); if (ds.Tables[0].Rows[0]["RemindersDate"].ToString() != "") { model.RemindersDate = DateTime.Parse(ds.Tables[0].Rows[0]["RemindersDate"].ToString()); } model.UserID = ds.Tables[0].Rows[0]["UserID"].ToString(); model.UserName = ds.Tables[0].Rows[0]["UserName"].ToString(); model.InfoContent = ds.Tables[0].Rows[0]["InfoContent"].ToString(); model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString(); if (ds.Tables[0].Rows[0]["IsSendMessage"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsSendMessage"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsSendMessage"].ToString().ToLower() == "true")) { model.IsSendMessage = true; } else { model.IsSendMessage = false; } } model.SendMessage = ds.Tables[0].Rows[0]["SendMessage"].ToString(); if (ds.Tables[0].Rows[0]["IsDelete"].ToString() != "") { model.IsDelete = int.Parse(ds.Tables[0].Rows[0]["IsDelete"].ToString()); } return(model); } else { return(null); } }