/// <summary> /// 生成运输记录流水号 /// </summary> /// <param name="carType">车类型</param> /// <param name="dt"></param> /// <returns></returns> public string CreateNewTransportSerialNumber(eCarType carType, DateTime dt) { string prefix = "Null"; if (carType == eCarType.入厂煤) { prefix = "RCM"; CmcsBuyFuelTransport entity = SelfDber.Entity <CmcsBuyFuelTransport>("where to_char(CreateDate,'yyyymmdd')=to_char(:CreateDate,'yyyymmdd') and SerialNumber like :Prefix || '%' order by InFactoryTime desc", new { CreateDate = dt, Prefix = prefix }); if (entity == null) { return(prefix + dt.ToString("yyMMdd") + "001"); } else { return(prefix + dt.ToString("yyMMdd") + (Convert.ToInt16(entity.SerialNumber.Replace(prefix + dt.ToString("yyMMdd"), "")) + 1).ToString().PadLeft(3, '0')); } } else if (carType == eCarType.销售煤) { prefix = "XSM"; CmcsSaleFuelTransport entity = SelfDber.Entity <CmcsSaleFuelTransport>("where to_char(CreateDate,'yyyymmdd')=to_char(:CreateDate,'yyyymmdd') and SerialNumber like :Prefix || '%' order by InFactoryTime desc", new { CreateDate = dt, Prefix = prefix }); if (entity == null) { return(prefix + dt.ToString("yyMMdd") + "001"); } else { return(prefix + dt.ToString("yyMMdd") + (Convert.ToInt16(entity.SerialNumber.Replace(prefix + dt.ToString("yyMMdd"), "")) + 1).ToString().PadLeft(3, '0')); } } else if (carType == eCarType.其他物资) { prefix = "WZ"; CmcsGoodsTransport entity = SelfDber.Entity <CmcsGoodsTransport>("where to_char(CreateDate,'yyyymmdd')=to_char(:CreateDate,'yyyymmdd') and SerialNumber like :Prefix || '%' order by InFactoryTime desc", new { CreateDate = dt, Prefix = prefix }); if (entity == null) { return(prefix + dt.ToString("yyMMdd") + "001"); } else { return(prefix + dt.ToString("yyMMdd") + (Convert.ToInt16(entity.SerialNumber.Replace(prefix + dt.ToString("yyMMdd"), "")) + 1).ToString().PadLeft(3, '0')); } } return(prefix + dt.ToString("yyMMdd") + DateTime.Now.Second.ToString().PadLeft(3, '0')); }
/// <summary> /// 通过类型获取地图路线模板表 /// </summary> public static CSTable.MapWayData GetMapWayDataByType(eCamp camp, eNpcType type) { var tplMapWays = CSTable.StaticDataManager.MapWay.Dict; foreach (var tpl in tplMapWays.Values) { eCarType carType = eCarType.None; switch (type) { case eNpcType.FoodCar: carType = eCarType.FoodCar; break; case eNpcType.MoneyCar: carType = eCarType.MoneyCar; break; } if (tpl.camp == (int)camp && tpl.cartype == (int)carType) { return(tpl); } } return(null); }