ORM 框架代码,C#代码库,德仔网

代码语言

代码分类

【C#】 ORM 框架

作者:哲天 / 发布于2016/4/6/ 464

功能强大，性能卓越，简单集成，简单易用，多数据库支持（DB2,ORACLE,MSSQL,MYSQL,SQLIST,INFORMAX,SYBASE,ACCESS)，开发阶段事务防死锁检查。支持自定义ＳＱＬ语句，自定义数据库函数，存储过程，嵌套查询，树状结构查询，分组统计，数据库排序。

public static object MORefQuery(int PageIndex, int PageSize, int InvOrgId, string MoName, string MoType, 
         string WorkshopID, string LineID, string PrintState, DateTime DATETIME_SCHE_START_Begin, DateTime DATETIME_SCHE_START_End)
     {
         CmdVwSfcMoSimple MO = new CmdVwSfcMoSimple();
         MO.Where(MO.ColInvOrgId == InvOrgId,MO.ColState == StateConverter.Active);
 
         if (!string.IsNullOrEmpty(MoName))
             MO.Where(MO.ColMoName.Like(MoName));///动态添加查询条件
         if (!string.IsNullOrEmpty(MoType))
             MO.Where(MO.ColMoCode == MoType);
         if (!string.IsNullOrEmpty(WorkshopID))
             MO.Where(MO.ColWorkshopId == WorkshopID);
         if (!string.IsNullOrEmpty(LineID))
             MO.Where(MO.ColLineId == LineID);
 
         MO.Where(MO.ColDatetimeScheStart >= DATETIME_SCHE_START_Begin.Date);
         MO.Where(MO.ColDatetimeScheStart <= DATETIME_SCHE_START_End.Date.AddDays(1));
 
         CmdSfcBarcode BC = new CmdSfcBarcode();
         var sub = BC.Where(BC.ColState == StateConverter.Active, BC.ColBarcodeState != "SCRAP")
             .Groupby(BC.ColMoId).Having(BC.ColId.Count > 0) ///分组统计
             .ToView(BC.ColMoId, BC.ColId.Count.As("Cnt"));　///子查询嵌套，重命名字段
 
         switch (PrintState)
         {
             case "未打印":
                 {
                     MO.LeftJoin(sub, MO.ColId == sub.CreateColumn(BC.ColMoId.ColumnName))///连接查询，sub子查询
                     .Where(sub.CreateColumn(BC.ColMoId.ColumnName).IsNull);
                 }
                 break;
             case "部分打印":
                 {
                     MO.LeftJoin(sub, MO.ColId == sub.CreateColumn(BC.ColMoId.ColumnName))
                     .Where(sub.CreateColumn("Cnt") > 0, (sub.CreateColumn("Cnt") < MO.ColPlanQty));
                 }
                 break;
             case "全部打印":
                 {
                     MO.LeftJoin(sub, MO.ColId == sub.CreateColumn(BC.ColMoId.ColumnName))
                     .Where(sub.CreateColumn("Cnt") >= MO.ColPlanQty);
                 }
                 break;
             default:
                 break;
         }
         var TotalRows = 0;
         var data = MO.SelectM((PageIndex - 1) * PageSize, PageSize, out TotalRows);　///数据库分页，即时对象模型转换
         return new { TotalRows = TotalRows, DataSource = data };
     }




public static List<ReprintTemplate> GetPrintTemplates(decimal inv_org_id, string[] mo_ids)
 {
     CmdSfcBarcode BC = new CmdSfcBarcode();
     CmdSfcBarcodeTmpl BCT = new CmdSfcBarcodeTmpl();
     CmdSfcBarcodeController BCC = new CmdSfcBarcodeController();
     CmdSfcBarcodePrintTmpl BCPL = new CmdSfcBarcodePrintTmpl();
 
     BC.Where(BC.ColState == "A", BCT.ColState == "A", BC.ColInvOrgId == inv_org_id);
 
     if (mo_ids.Length > 0)
         BC.Where(BC.ColMoId.In(mo_ids));///in 语句
 
     List<ReprintTemplate> MList = BCC
         .InnerJoin(BCPL, BCC.ColSchemaId == BCPL.ColSchemaId, BCPL.ColState == "A")　///内连接
         .InnerJoin(BCT, BCPL.ColTmplId == BCT.ColId, BCT.ColState == "A")
         .Where(BCC.ColId.In(BC, BC.ColControllerId), BCC.ColState == "A")  ////IN语句子查询
         .Select<ReprintTemplate>(BCT.ColTmplName, BCT.ColId.As("tmpl_ID"), BCT.ColTmplFilename, BCC.ColVisaulInfo,
                         BCC.ColPrintString, BCC.ColMoId, BCT.ColMd5value, BCT.ColTmplData);
 
     var returnList = new List<ReprintTemplate>();
 
     foreach (ReprintTemplate tmpl in MList)
     {
         if (returnList.Any(p => p.tmpl_ID == tmpl.tmpl_ID))
         {
             continue;
         }
         returnList.Add(new ReprintTemplate()
         {
             Md5value = tmpl.Md5value,
             TMPL_DATA = tmpl.TMPL_DATA,　　/////二进制大对象，oracle的blob 
             tmpl_ID = tmpl.tmpl_ID,
             print_string = tmpl.print_string,
             TMPL_FILENAME = tmpl.TMPL_FILENAME,
             tmpl_name = tmpl.tmpl_name,
             visaul_info = tmpl.visaul_info,
         });
 
     }
     return returnList;
 }




ODATransaction tran = BC.BeginTransaction();　//事务开始
 
try
{
    ///数据插入
    BC.Insert(BC.ColId == controller_id, BC.ColState == "A", BC.ColInvOrgId == PrintParam.InvOrgid, BC.ColSemiBarcode == PrintParam.SemiBarcode,
        BC.ColDatetimeCreated == DBNow, BC.ColDatetimeModified == DBNow, BC.ColMoId == PrintParam.Moid, BC.ColMoName == PrintParam.MoName,
        BC.ColPrintBrand == PrintParam.PrintBrand, BC.ColPrintModel == PrintParam.PrintModel, BC.ColPrintString == PrintParam.PrintString,
        BC.ColRequestReason == PrintParam.RequestReason, BC.ColRequestUser == PrintParam.RequestUser, BC.ColSchemaId == SchemaModel.ID,
        BC.ColSeqCurrent == start_seq, BC.ColSeqEnd == end_seq, BC.ColSeqStart == start_seq, BC.ColSku == PrintParam.SKU,
        BC.ColVisaulInfo == PrintParam.PrintVisaul, BC.ColUserModified == PrintParam.RequestUser, BC.ColUserCreated == PrintParam.RequestUser
    );
 
    foreach (ModelSfcBarcodeControllerTmpl m in PrintTmpl)
    {
        string id = Guid.NewGuid().ToString("N").ToUpper();
        CmdSfcBarcodeControllerTmpl C = new CmdSfcBarcodeControllerTmpl();
        C.Tran = tran;
        C.Insert(C.ColId == id, C.ColInvOrgId == m.INV_ORG_ID, C.ColPrintedCount == 0, C.ColState == "A", C.ColControllerId == m.CONTROLLER_ID,
            C.ColTmplId == m.TMPL_ID, C.ColDatetimeModified == DBNow, C.ColDatetimeCreated == DBNow, C.ColUserCreated == m.USER_CREATED,
            C.ColUserModified == m.USER_MODIFIED, C.ColTmplName == m.TMPL_NAME, C.ColTmplType == m.TMPL_TYPE);
    }
    tran.Commit();//事务提交
}
catch (Exception ex)
{
    tran.RollBack();　//事务回滚
    throw ex;
}



CmdSfcBarcodeSequenceMegre seqM = new CmdSfcBarcodeSequenceMegre();
seqM.Where(seqM.ColSchemaType == "SN")
.Update(seqM.ColBarcodePrefix == Prefix, seqM.ColInvOrgId == InvOrgid,
seqM.ColSchemaType == SchemaType, seqM.ColCurrentValue == (seqM.ColCurrentValue + Count )); ////update 语句

评论列表

本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。

试试其它关键字

同语言下

可能有用的

哲天贡献的其它代码(14)