/// <summary> /// 构造查询SQL条件 /// </summary> /// <param name="sCargoType">货物类型</param> /// <param name="bllid">订单号</param> /// <returns>Sql</returns> private string GetSQLCondition(string sCargoType = "", string bllid = "") { string sSQLWhere = string.Empty; //获取查询的货物类型 sCargoType = CommonReport.InputText(sCargoType, sCargoType.Length); if (!string.IsNullOrWhiteSpace(sCargoType)) { sSQLWhere += " lading_type ='" + sCargoType + "'"; } if (!string.IsNullOrWhiteSpace(bllid)) { sSQLWhere += " AND bill_id = '" + bllid + "'"; } return(sSQLWhere); }