/// <summary>
/// 读取数据库
/// </summary>
/// <param name="alias">表别名</param>
/// <param name="connection">链接类</param>
/// <param name="top">指定笔数</param>
/// <param name="condition">其他条件（需带入and）</param>
/// <returns>数据</returns>
public static List <FinanceM> ReadDataBase(string alias, IConnectionD connection, int top = 0, string condition = "")
{
List <FinanceM> result = null;
string strTop = "";
if (top != 0)
{
strTop = string.Format("top {0}", top);
}
string fields = GetField(alias);
string from = GetFrom();
string where = string.Format("where 1=1");
if (!string.IsNullOrEmpty(condition))
{
where = string.Format("{0} {1}", where, condition);
}
string orderby = string.Format("order by {0}", TableStructM.Info_Finance.SF_ID);
string sql = string.Format("select {0} {1} from {2} {3} {4}", strTop, fields, from, where, orderby);
connection.DataBaseFactory.GetDataReader(sql);
if (connection.DataBaseFactory.IsEffect())
{
result = AddDataToList(connection.DataBaseFactory.Reader);
}
connection.DataBaseFactory.CloseDataReader();
return(result);
}
/// <summary>
/// 获取数据
/// </summary>
/// <param name="connection">链接类</param>
/// <returns>数据</returns>
public static List <ContractM> GetDataContract(IConnectionD connection)
{
//const string ALIAS_Contract = "a";
//return ReadDataBase(ALIAS_Contract, connection);
return(ReadDataBase(connection));
}
/// <summary>
/// 通过编号获取数据
/// </summary>
/// <param name="id">编号</param>
/// <param name="connection">链接类</param>
/// <returns>数据</returns>
public static ClientsM GetDataByID(string clid, IConnectionD connection)
{
string where = string.Format("and {0}={1}", TableStructM.Info_Clients.CL_ID, clid);
IList <ClientsM> lst = ReadDataBase(where, connection);
return(lst != null && lst.Count > 0 ? lst.FirstOrDefault() : null);
}
/// <summary>
/// 通过编号获取数据
/// </summary>
/// <param name="id">编号</param>
/// <param name="connection">链接类</param>
/// <returns>数据</returns>
public static FinanceM GetDataByID(string id, IConnectionD connection)
{
string where = string.Format(" and {0}={1}", TableStructM.Info_Finance.SF_ID, id);
IList <FinanceM> lst = ReadDataBase(where, connection);
return(lst != null && lst.Count > 0 ? lst.FirstOrDefault() : null);
}
/// <summary>
/// 获取数据
/// </summary>
/// <param name="connection">链接类</param>
/// <returns>数据</returns>
public static List <FinanceM> GetDataFinance(IConnectionD connection)
{
//const string ALIAS_Finance = "a";
//return ReadDataBase(ALIAS_Finance, connection);
return(ReadDataBase(connection));
}
/// <summary>
/// 判断客户是否存在
/// </summary>
/// <param name="clientsname">客户名称</param>
/// <param name="connection">链接类</param>
/// <returns>业主类</returns>
public static ClientsM IsExist_clientsname(string clientsname, string id, IConnectionD connection)
{
ClientsM result = null;
if (id != "")
{
string where = string.Format(" and {0}='{1}' and {2} <> {3}", TableStructM.Info_Clients.CL_NAME, clientsname.ReplaceStr(), TableStructM.Info_Clients.CL_ID, id.ReplaceStr());
IList <ClientsM> lst = ReadDataBase(where, connection);
if (lst != null)
{
result = lst.FirstOrDefault();
}
}
else
{
string where = string.Format(" and {0}='{1}' ", TableStructM.Info_Clients.CL_NAME, clientsname.ReplaceStr(), TableStructM.Info_Clients.CL_ID, id.ReplaceStr());
IList <ClientsM> lst = ReadDataBase(where, connection);
if (lst != null)
{
result = lst.FirstOrDefault();
}
}
return(result);
}
/// <summary>
/// 判断工程量是否存在
/// </summary>
/// <param name="financenname">工程量名</param>
/// <param name="connection">链接类</param>
/// <returns>收付款类</returns>
public static QuantityM IsExist_financename(string quantityname, IConnectionD connection)
{
QuantityM result = null;
string where = string.Format(" and {0}='{1}'", TableStructM.Info_Quantity.QT_ID, quantityname.ReplaceStr());
IList <QuantityM> lst = ReadDataBase(where, connection);
if (lst != null)
{
result = lst.FirstOrDefault();
}
return(result);
}
/// <summary>
/// 判断项目是否存在
/// </summary>
/// <param name="projectsnname">项目名</param>
/// <param name="connection">链接类</param>
/// <returns>项目类</returns>
public static ProjectsM IsExist_projectsname(string projectsname, IConnectionD connection)
{
ProjectsM result = null;
string where = string.Format(" and {0}='{1}'", TableStructM.Info_Projects.PR_NAME, projectsname.ReplaceStr());
IList <ProjectsM> lst = ReadDataBase(where, connection);
if (lst != null)
{
result = lst.FirstOrDefault();
}
return(result);
}
/// <summary>
/// 判断收付款是否存在
/// </summary>
/// <param name="financenname">收付款名</param>
/// <param name="connection">链接类</param>
/// <returns>收付款类</returns>
public static FinanceM IsExist_financename(string financename, IConnectionD connection)
{
FinanceM result = null;
string where = string.Format(" and {0}='{1}'", TableStructM.Info_Finance.SF_CNID, financename.ReplaceStr());
IList <FinanceM> lst = ReadDataBase(where, connection);
if (lst != null)
{
result = lst.FirstOrDefault();
}
return(result);
}
/// <summary>
/// 判断合同是否存在
/// </summary>
/// <param name="contractnname">合同名</param>
/// <param name="connection">链接类</param>
/// <returns>合同类</returns>
public static ContractM IsExist_contractname(string contractname, IConnectionD connection)
{
ContractM result = null;
string where = string.Format(" and {0}='{1}'", TableStructM.Info_Contract.CT_NAME, contractname.ReplaceStr());
IList <ContractM> lst = ReadDataBase(where, connection);
if (lst != null)
{
result = lst.FirstOrDefault();
}
return(result);
}
/// <summary>
/// 读取数据库
/// </summary>
/// <param name="condition">其他条件（需带入and）</param>
/// <param name="connection">链接类</param>
/// <returns>数据</returns>
public static List <QuantityM> ReadDataBase(IConnectionD connection = null)
{
List <QuantityM> result = null;
string fields = GetField();
string from = GetFrom();
string where = string.Format("where 1=1");
string sql = string.Format("select {0} from {1} {2} ", fields, from, where);
connection.DataBaseFactory.GetDataReader(sql);
if (connection.DataBaseFactory.IsEffect())
{
result = AddDataToList(connection.DataBaseFactory.Reader);
}
connection.DataBaseFactory.CloseDataReader();
return(result);
}
/// <summary>
/// 读取数据库
/// </summary>
/// <param name="condition">其他条件（需带入and）</param>
/// <param name="connection">链接类</param>
/// <returns>数据</returns>
//public static List<ProjectsM> ReadDataBase(string condition = "", IConnectionD connection = null)
public static List <ProjectsTeamM> ReadDataBase(IConnectionD connection = null)
{
List <ProjectsTeamM> result = null;
string fields = GetField();
string from = GetFrom();
string where = string.Format("where 1=1");
//if (!string.IsNullOrEmpty(condition)) where = string.Format("{0} {1}", where, condition);
string sql = string.Format("select {0} from {1} {2} ", fields, from, where);
connection.DataBaseFactory.GetDataReader(sql);
if (connection.DataBaseFactory.IsEffect())
{
result = AddDataToList(connection.DataBaseFactory.Reader);
}
connection.DataBaseFactory.CloseDataReader();
return(result);
}
/// <summary>
/// 初始化
/// </summary>
/// <param name="connectiond">链接类</param>
public FinanceD(IConnectionD connectiond)
{
this._connectiond = connectiond;
this._dbfactory = connectiond.DataBaseFactory;
}
/// <summary>
/// 获取数据
/// </summary>
/// <param name="connection">链接类</param>
/// <returns>数据</returns>
public static List <ClientsM> GetDataClients(IConnectionD connection)
{
//const string ALIAS_Clients = "a";
return(ReadDataBase(connection));
//return ReadDataBase(ALIAS_Clients, connection);
}
/// <summary>
/// 实例化对象
/// </summary>
/// <param name="strNameSpace">命名空间</param>
/// <param name="strInstance">实例名</param>
void InstanceObject(string strNameSpace, string strInstance)
{
this._connectiond = PublicMethods.Methods.InstanceObject(strNameSpace, strInstance) as IConnectionD;
}
/// <summary>
/// 初始化
/// </summary>
/// <param name="connectiond">链接类</param>
public ProjectsTeamD(IConnectionD connectiond)
{
this._connectiond = connectiond;
this._dbfactory = connectiond.DataBaseFactory;
}
/// <summary>
/// 获取分页数据
/// </summary>
/// <param name="start">起始数据</param>
/// <param name="size">显示笔数</param>
/// <param name="alias">表别名</param>
/// <param name="alias_group">alias_group表别名</param>
/// <param name="connection">链接类</param>
/// <param name="condition">其他条件（需带入and）</param>
/// <param name="order">排序条件（无需带入order by）</param>
/// <returns></returns>
public static List <FinanceM> GetPageData(ref long count, long start, int size, string key, string order, OrderType orderway, string belong, IConnectionD connection)
{
string where = "", orderby = "";
//if (!string.IsNullOrEmpty(key)) where = string.Format("{0} and({1} like '%{2}%')", where, TableStructM.Info_Finance.SF_NAME, key.ReplaceStr());
if (!string.IsNullOrEmpty(order))
{
orderby = string.Format("{0} {1}", order, (orderway == OrderType.otAsc ? "asc" : "desc"));
}
//if (!string.IsNullOrEmpty(belong )) where = string.Format("{0} and {1} ={2}", where, TableStructM.Info_Finance.SF_BELONG, belong.ReplaceStr());
string condition = GetFrom();
count = connection.DataBaseFactory.GetCount(TableStructM.Info_Finance.TABLENAME, string.Format("where 1=1 {0}", where));
return(ReadPageDataBase(start, size, where, orderby, connection));
}
/// <summary>
/// 读取数据库
/// </summary>
/// <param name="condition">其他条件（需带入and）</param>
/// <param name="start">起始数据</param>
/// <param name="size">显示笔数</param>
/// <param name="order">排序条件（无需带入order by）</param>
/// <param name="connection">链接类</param>
/// <returns>数据</returns>
public static List <FinanceM> ReadPageDataBase(long start, int size, string condition = "", string order = "", IConnectionD connection = null)
{
List <FinanceM> result = null;
string tablename = TableStructM.Info_Finance.TABLENAME;
string fields = GetField();
string from = GetFrom();
string orderby = string.Format("order by {0}", order);
string condition_where = string.Format("where 1=1");
string where = string.Format("where {0} not in (select top {1} {0} from {2} {3}{4}{5})", TableStructM.Info_Finance.SF_ID, start, from, condition_where, condition, orderby);
if (!string.IsNullOrEmpty(condition))
{
where = string.Format("{0} {1}", where, condition);
}
string sql = string.Format("select top {0} {1} from {2} {3} {4}", size, fields, from, where, orderby);
connection.DataBaseFactory.GetDataReader(sql);
if (connection.DataBaseFactory.IsEffect())
{
result = AddDataToList(connection.DataBaseFactory.Reader);
}
connection.DataBaseFactory.CloseDataReader();
return(result);
}
/// <summary>
/// 初始化
/// </summary>
/// <param name="connectiond">链接类</param>
public MenuD(IConnectionD connectiond)
{
this._dbfactory = connectiond.DataBaseFactory;
}
/// <summary>
/// 获取数据
/// </summary>
/// <param name="connection">链接类</param>
/// <returns>数据</returns>
public static List <QuantityM> GetDataQuantity(IConnectionD connection)
{
return(ReadDataBase(connection));
}
/// <summary>
/// 获取数据
/// </summary>
/// <param name="connection">链接类</param>
/// <returns>数据</returns>
public static List <MenuM> GetDataMenu(IConnectionD connection)
{
const string ALIAS_MENU = "a";
return(ReadDataBase(ALIAS_MENU, connection));
}
/// <summary>
/// 初始化
/// </summary>
/// <param name="connectiond">链接类</param>
public ClientsD(IConnectionD connectiond)
{
this._connectiond = connectiond;
this._dbfactory = connectiond.DataBaseFactory;
}
/// <summary>
/// 获取分页数据
/// </summary>
/// <param name="start">起始数据</param>
/// <param name="size">显示笔数</param>
/// <param name="alias">表别名</param>
/// <param name="alias_group">alias_group表别名</param>
/// <param name="connection">链接类</param>
/// <param name="condition">其他条件（需带入and）</param>
/// <param name="order">排序条件（无需带入order by）</param>
/// <returns></returns>
public static List <QuantityM> GetPageData(ref long count, long start, int size, string key, string order, OrderType orderway, IConnectionD connection)
{
string where = "", orderby = "";
if (!string.IsNullOrEmpty(order))
{
orderby = string.Format("{0} {1}", order, (orderway == OrderType.otAsc ? "asc" : "desc"));
}
string condition = GetFrom();
count = connection.DataBaseFactory.GetCount(TableStructM.Info_Quantity.TABLENAME, string.Format("where 1=1 {0}", where));
return(ReadPageDataBase(start, size, where, orderby, connection));
}
/// <summary>
/// 获取数据
/// </summary>
/// <param name="connection">链接类</param>
/// <returns>数据</returns>
public static List <ProjectsTeamM> GetDataProjectsTeam(IConnectionD connection)
{
//const string ALIAS_Projects = "a";
return(ReadDataBase(connection));
//return ReadDataBase(ALIAS_Projects, connection);
}
/// <summary>
/// 初始化
/// </summary>
/// <param name="connectiond">链接类</param>
public QuantityD(IConnectionD connectiond)
{
this._connectiond = connectiond;
this._dbfactory = connectiond.DataBaseFactory;
}
