随笔分类 - MySQL
摘要：SELECT * FROM information_schema.columns WHERE TABLE_SCHEMA='fineex_inventory_01' AND COLUMN_NAME='OperationType'
阅读全文
摘要：List作为查询条件 public List<tm_master_commodity> SelectCommodity(List<int> CommodityID) { var sql = @"select CommodityID, MemberID, BarCode,CommodityCode,C
阅读全文
摘要：C#查询：数据查询层 public List<PackageBox> GetPackageBoxList(int memberID) { using (var wmsconn = DapperConnection.GetConnection(DatabaseEnum.WMS_Main_Read.To
阅读全文
摘要：两个系统共用一张表，系统A和系统B数据类型有两种：20:回寄中30:已签收，系统A插入:10,系统B插入:20, 查询表中字段TransOrderID唯一且OrderBackType=10，Status=30的数据数量 表：orderbackdetail sql语句： SELECT COUNT(1)
阅读全文
摘要：1 //$可以使参数sortVolumesq融入到sql语句中 3 var sql = $@"SELECT 4 t.`MemberID`,t2.`MemberName`,SUM(t1.`Volumn`)AS TotalVolume,COUNT(t.`MemberID`)AS TotalOrder 5
阅读全文
摘要：SELECT COUNT(*)AS AddOrder, IFNULL(SUM(m.OrderReceived), 0) AS OrderReceived, IFNULL(SUM(m.WaitingDelivery), 0)AS WaitingDelivery, IFNULL(SUM(m.PlanDe
阅读全文
摘要：为表添加新的字段： ALTER TABLE `tt_tms_orderback` ADD (`BackType` INT(2) NOT NULL DEFAULT '1' COMMENT '1按扫描2按时间', `DateRange` VARCHAR(50) DEFAULT NULL COMMENT
阅读全文
