using Commom.Utility;
|
using Common;
|
using Model;
|
using System;
|
using System.Collections;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Text;
|
|
namespace BLL.DAL
|
{
|
public class DALDictionary
|
{
|
/// <summary>
|
/// 获取数据类别
|
/// </summary>
|
/// <returns></returns>
|
public DataTable GetDictionarys()
|
{
|
try
|
{
|
StringBuilder stringBuilder = new StringBuilder();
|
stringBuilder.Append("select * from Dictionary where IsDel = 0 and topCode is null;");
|
|
DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(stringBuilder);
|
return dt;
|
}
|
catch
|
{
|
throw new NotImplementedException();
|
}
|
}
|
|
public IList<Dictionarys> GetDictionaryItems(Dictionarys dictionarys, ref PageInfo page)
|
{
|
try
|
{
|
StringBuilder stringBuilder = new StringBuilder();
|
stringBuilder.Append("select * from View_Dictionary_Userinfo where IsDel = 0 and TopCode is not null ");
|
if (dictionarys.TopCode != null && dictionarys.TopCode != "")
|
{
|
stringBuilder.Append(" and TopCode = " + dictionarys.TopCode.AddQuotes());
|
}
|
if (dictionarys.TypeName != null && dictionarys.TypeName != "")
|
{
|
stringBuilder.Append(" and TypeName like '%" + dictionarys.TypeName + "%' ");
|
}
|
if (dictionarys.Guid != null && dictionarys.Guid != "")
|
{
|
stringBuilder.Append(" and Guid = " + dictionarys.Guid.AddQuotes());
|
}
|
|
SqlParam[] para = new SqlParam[]
|
{
|
};
|
|
DataTable dt = DataFactory.SqlDataBase().GetPageList(stringBuilder.ToString(), para, "TopCode", "ASC", ref page);
|
IList<Dictionarys> list = ModelConvertHelper<Dictionarys>.DataTableToModel(dt);
|
|
return list;
|
}
|
catch
|
{
|
throw new NotImplementedException();
|
}
|
}
|
|
public bool SetDictionarys(Dictionarys dictionarys, string loginUser)
|
{
|
try
|
{
|
bool bl = false;
|
int rowCount = 0;
|
Hashtable ht = new Hashtable();
|
if (dictionarys.Guid == "")
|
{
|
StringBuilder stringBuilder = new StringBuilder();
|
stringBuilder.Append("select isnull(max(Code),0)+1 from Dictionary where IsDel = 0 and TopCode =" + dictionarys.TopCode.AddQuotes());
|
if (dictionarys.TopCode == "CDStatu")
|
{
|
stringBuilder.Append(" and code != '99';");
|
}
|
DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(stringBuilder);
|
|
ht["Code"] = dt.Rows[0][0].ToString().PadLeft(2,'0').AddQuotes();
|
ht["TypeName"] = dictionarys.TypeName.AddQuotes();
|
ht["TopCode"] = dictionarys.TopCode.AddQuotes();
|
|
ht["CreatUser"] = loginUser.AddQuotes();
|
|
rowCount = DataFactory.SqlDataBase().InsertByHashtableNullParam("Dictionary", ht);
|
}
|
else
|
{
|
ht["TypeName"] = dictionarys.TypeName.AddQuotes();
|
ht["TopCode"] = dictionarys.TopCode.AddQuotes();
|
|
ht["UpdateTime"] = "convert(varchar(20),getdate(),120)";
|
ht["UpdateUser"] = loginUser.AddQuotes();
|
|
rowCount = DataFactory.SqlDataBase().UpdateByHashtable("Dictionary",
|
"Guid", dictionarys.Guid.AddQuotes(), ht);
|
}
|
|
if (rowCount > 0)
|
{
|
bl = true;
|
}
|
|
return bl;
|
}
|
catch
|
{
|
throw new NotImplementedException();
|
}
|
}
|
|
/// <summary>
|
/// 检查是否已存在
|
/// </summary>
|
/// <param name="region"></param>
|
/// <returns></returns>
|
public bool IsExist(Dictionarys dictionarys)
|
{
|
try
|
{
|
bool bl = false;
|
StringBuilder stringBuilder = new StringBuilder();
|
stringBuilder.Append("select count(*) from Dictionary where TypeName = " + dictionarys.TypeName.AddQuotes());
|
stringBuilder.Append(" and TopCode = " + dictionarys.TopCode.AddQuotes() + " and isDel = 0 ");
|
stringBuilder.Append("and Guid != " + dictionarys.Guid.AddQuotes() + ";");
|
DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(stringBuilder);
|
if (dt.Rows[0][0].ToString() != "0")
|
{
|
bl = true;
|
}
|
|
return bl;
|
}
|
catch
|
{
|
throw new NotImplementedException();
|
}
|
}
|
|
public bool DelDictionarys(string[] Guids, string loginUser)
|
{
|
try
|
{
|
bool bl = false;
|
int rowCount = 0;
|
Hashtable ht = new Hashtable();
|
foreach (string Guid in Guids)
|
{
|
ht["IsDel"] = 1;
|
ht["UpdateTime"] = "convert(varchar(20),getdate(),120)";
|
ht["UpdateUser"] = loginUser.AddQuotes();
|
rowCount += DataFactory.SqlDataBase().UpdateByHashtable("Dictionary",
|
"Guid", Guid.AddQuotes(), ht);
|
}
|
|
if (rowCount > 0)
|
{
|
bl = true;
|
}
|
|
return bl;
|
}
|
catch
|
{
|
throw new NotImplementedException();
|
}
|
}
|
}
|
}
|
