/// <summary> /// 得到一个对象实体 /// </summary> public MobileSoft.Model.Information.Tb_Information_WebEditor GetModel(long ID) { SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.BigInt) }; parameters[0].Value = ID; MobileSoft.Model.Information.Tb_Information_WebEditor model = new MobileSoft.Model.Information.Tb_Information_WebEditor(); DataSet ds = DbHelperSQL.RunProcedure("Proc_Tb_Information_WebEditor_GetModel", parameters, "ds"); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ID"].ToString() != "") { model.ID = long.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } if (ds.Tables[0].Rows[0]["BussId"].ToString() != "") { model.BussId = long.Parse(ds.Tables[0].Rows[0]["BussId"].ToString()); } model.WebContent = ds.Tables[0].Rows[0]["WebContent"].ToString(); model.Image1 = ds.Tables[0].Rows[0]["Image1"].ToString(); model.Image2 = ds.Tables[0].Rows[0]["Image2"].ToString(); model.Image3 = ds.Tables[0].Rows[0]["Image3"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(MobileSoft.Model.Information.Tb_Information_WebEditor model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.BigInt, 8), new SqlParameter("@BussId", SqlDbType.BigInt, 8), new SqlParameter("@WebContent", SqlDbType.NVarChar), new SqlParameter("@Image1", SqlDbType.NVarChar, 500), new SqlParameter("@Image2", SqlDbType.NVarChar, 500), new SqlParameter("@Image3", SqlDbType.NVarChar, 500) }; parameters[0].Value = model.ID; parameters[1].Value = model.BussId; parameters[2].Value = model.WebContent; parameters[3].Value = model.Image1; parameters[4].Value = model.Image2; parameters[5].Value = model.Image3; DbHelperSQL.RunProcedure("Proc_Tb_Information_WebEditor_Update", parameters, out rowsAffected); }
/// <summary> /// 增加一条数据 /// </summary> public long Add(MobileSoft.Model.Information.Tb_Information_WebEditor model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.BigInt, 8), new SqlParameter("@BussId", SqlDbType.BigInt, 8), new SqlParameter("@WebContent", SqlDbType.NVarChar), new SqlParameter("@Image1", SqlDbType.NVarChar, 500), new SqlParameter("@Image2", SqlDbType.NVarChar, 500), new SqlParameter("@Image3", SqlDbType.NVarChar, 500) }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.BussId; parameters[2].Value = model.WebContent; parameters[3].Value = model.Image1; parameters[4].Value = model.Image2; parameters[5].Value = model.Image3; DbHelperSQL.RunProcedure("Proc_Tb_Information_WebEditor_ADD", parameters, out rowsAffected); return((long)parameters[0].Value); }