/// <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; }