using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Data.SqlClient;
|
using System.Linq;
|
using System.Text;
|
using YX.Entity;
|
|
namespace YX.DAL
|
{
|
public class SystemAppendProperty_Dal
|
{
|
//static string _connectionString = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"].ToString();
|
/// 业务附加属性列表
|
/// </summary>
|
/// <param name="Function">业务功能</param>
|
/// <returns></returns>
|
// public DataTable AppendProperty_List(string Function)
|
// {
|
|
// try
|
// {
|
// string sql = @"SELECT [Property_ID] as '编号'
|
// ,[Property_Function] as '业务分类'
|
// ,[Property_Control_ID] as '控件ID'
|
// ,[Property_Name] as '控件名称'
|
// ,[Property_Control_DataSource] as '数据源'
|
// ,[Property_Control_Length] as '控件长度'
|
// ,case [Property_Control_Style]
|
// when 'txt' then '文本框'
|
// when 'select' then '下拉框'
|
// when 'richText' then '大文本框'
|
// when 'label' then '标签框'
|
// when 'date' then '日期框' end as '控件类型'
|
// ,[SortCode] as '排序'
|
// FROM Base_AppendProperty
|
// WHERE DeleteMark = 1
|
// AND Property_Function=@Property_Function
|
// ORDER BY SortCode ASC";
|
// SqlParameter[] par = new SqlParameter[]
|
// {
|
// new SqlParameter("@Property_Function", Function)
|
// };
|
|
// return SqlHelper.ExecuteDataset(_connectionString, CommandType.Text, sql,par).Tables[0];
|
// }
|
// catch (Exception ex)
|
// {
|
|
// throw ex;
|
// }
|
// }
|
//业务功能列表
|
public List<string> GetAppendPropertys()
|
{
|
try
|
{
|
using (Sam_DBEntities db = new Sam_DBEntities())
|
{
|
return db.Base_AppendProperty.Select(o => o.Property_Function).Distinct().ToList();
|
}
|
}
|
catch (Exception ex)
|
{
|
|
throw ex;
|
}
|
|
|
}
|
//具体业务功能属性列表
|
public List<Base_AppendProperty> AppendProperty_List(string Property_Function)
|
{
|
try
|
{
|
using (Sam_DBEntities db = new Sam_DBEntities())
|
{
|
return db.Base_AppendProperty.Where(o=>o.DeleteMark==1 && o.Property_Function== Property_Function).OrderBy(o=>o.SortCode).ToList();
|
}
|
}
|
catch (Exception ex)
|
{
|
|
throw ex;
|
}
|
}
|
|
/// <summary>
|
/// 根据业务名称获取附加属性值
|
/// </summary>
|
/// <param name="Property_Function">所属功能</param>
|
/// <param name="Obj_ID">业务主键</param>
|
/// <returns></returns>
|
public List<Base_AppendPropertyInstance> GetPropertyInstancepk(string Property_Function, string Obj_ID)
|
{
|
try
|
{
|
StringBuilder item_value = new StringBuilder();
|
using (Sam_DBEntities db = new Sam_DBEntities())
|
{
|
var query = from I in db.Base_AppendPropertyInstance
|
join A in db.Base_AppendProperty
|
on I.Property_Control_ID equals A.Property_Control_ID
|
where I.Base_UserInfo.User_ID == Obj_ID && A.Property_Function == Property_Function
|
select I;
|
return query.ToList();
|
}
|
}
|
catch (Exception)
|
{
|
|
throw;
|
}
|
|
}
|
/// <summary>
|
/// 添加属性
|
/// </summary>
|
/// <returns></returns>
|
public int AddAppendProperty(Base_AppendProperty info)
|
{
|
try
|
{
|
using (Sam_DBEntities db = new Sam_DBEntities())
|
{
|
db.Base_AppendProperty.Add(info);
|
return db.SaveChanges();
|
}
|
}
|
catch (Exception ex)
|
{
|
|
throw ex;
|
}
|
}
|
/// <summary>
|
/// 修改属性
|
/// </summary>
|
/// <param name="info"></param>
|
/// <returns></returns>
|
public int UpdateAppendProertty(Base_AppendProperty info)
|
{
|
try
|
{
|
using (Sam_DBEntities db = new Sam_DBEntities())
|
{
|
db.Base_AppendProperty.Attach(info);
|
db.Entry(info).State = System.Data.Entity.EntityState.Modified;
|
return db.SaveChanges();
|
}
|
}
|
catch (Exception ex)
|
{
|
|
throw ex;
|
}
|
}
|
/// <summary>
|
/// 删除属性
|
/// </summary>
|
/// <param name="Property_ID"></param>
|
/// <returns></returns>
|
public int DeleteAppendProettty(string Property_ID)
|
{
|
try
|
{
|
using (Sam_DBEntities db=new Sam_DBEntities())
|
{
|
var obj = new Base_AppendProperty { Property_ID= Property_ID };
|
db.Base_AppendProperty.Attach(obj);
|
db.Base_AppendProperty.Remove(obj);
|
return db.SaveChanges();
|
}
|
}
|
catch (Exception ex)
|
{
|
|
throw ex;
|
}
|
}
|
}
|
|
}
|