使用EntitysCodeGenerate

weixin_34061482

于 2015-10-08 10:40:00 发布

阅读量234

点赞数

文章标签：数据库

http://bbs.csdn.net/topics/360256700

public DataSet xxx(DateTime start, DateTime end, string type)
        {
                        string[,] strArray = new string[6, 2] {{"0", "11"}, {"1", "11"}, {"2", "22"}, {"3", "11"}, {"4", "11"}, {"5", "11"}};

            DataSet dst = new DataSet();
            DbCore dbCore = new DbCore(DatabaseType.Oracle, BaseEntity.GetConnectionString());
            dbCore.Open();
            dst = dbCore.Select().SelectColumns(new string[]{A.s_FEECELLED, 
                                                        B.s_SSXCELLED, 
                                                        B.s_MSPHONE1, 
                                                        B.s_MSPHONE2, 
                                                        B.s_MSPHONE3, 
                                                        B.s_MSPHONE4,
                                                        A.s_ADDDATE,
                                                        A.s_ORDERFLAG,
                                                        A.s_RESPTIME})
                            .From(new string[]{A.s_TableName,
                                                B.s_TableName})
                            .Where().ConditionAndEqual(A.s_ORDERTYPE, type)
                                    .ConditionAndBetweenAnd(A.s_ADDDATE, start.ToString(), end.ToString())
                                    .ConditionColumnAndEqual(A.s_FEECELLED, B.s_ADMINCELLING)
                                    .ConditionColumnAndEqual(A.s_USECELLED, B.s_SSXCELLED)
                                    .ConditionAndNotIn(A.s_FEECELLED, 
                                                        new string[] { "136xxxx", "135xxxx", "135xxxx", "136xxxx" }).ExecuteDataSet();
            dbCore.Close();

            DataTable dt = TableHelp.ReplacleTableColValue(dst.Tables[0], dst.Tables[0].Columns["ORDERFLAG"], strArray);
//            TableHelp.SortTable(dst.Tables[0], dst.Tables[0].Columns[6]);
            TableHelp.SortTable(dt, "ADDDATE", SortDirection.Asc);//"ORDERFLAG", SortDirection.Asc);//, 

//            TableHelp.SortTableAsc(dst.Tables[0], dst.Tables[0].Columns["ADDDATE"], dst.Tables[0].Columns["ORDERFLAG"]);
                       return dst;
        }