/// <summary> /// 退货通知单详情 /// </summary> /// <param name="phoneNumber"></param> /// <param name="groupId"></param> /// <param name="fBillNo"></param> /// <returns></returns> public SalesReturnNoticeDetail GetSalesReturnNoticeDetail(string phoneNumber, string fBillNo) { try { SalesReturnNoticeDetail returnNoticeDetail = new SalesReturnNoticeDetail(); var fields = GetUserGroupFieldDisplayed(phoneNumber, "002"); returnNoticeDetail.Field = fields; var field = string.Join(",", fields.Select(f => f.FFieldName).ToArray()); SqlParameter[] sqlParameter = new SqlParameter[] { new SqlParameter { ParameterName = "@FBillNo", Value = fBillNo, SqlDbType = SqlDbType.NVarChar } }; string sql = "select " + field + " from tm_v_SalesReturnNotice where FBillNo=@FBillNo"; var res = SqlHelper.ExecuteDataTable(CommandType.Text, sql, sqlParameter); returnNoticeDetail.Order = res; LoggerHelper.Info("退货通知单详情"); return(returnNoticeDetail); } catch (Exception e) { LoggerHelper.Info("退货通知单详情,[" + phoneNumber + "],fBillNo:" + fBillNo + e); return(null); } }
/// <summary> /// 退货通知单详情 /// </summary> /// <param name="phoneNumber"></param> /// <param name="groupId"></param> /// <param name="fBillNo"></param> /// <returns></returns> public SalesReturnNoticeDetail GetSalesReturnNoticeDetail(string phoneNumber, string fBillNo) { SalesReturnNoticeDetail returnNoticeDetail = new SalesReturnNoticeDetail(); var fields = GetUserGroupFieldDisplayed(phoneNumber, "002"); returnNoticeDetail.Field = fields; var field = string.Join(",", fields.Select(f => f.FFieldName).ToArray()); SqlParameter[] sqlParameter = new SqlParameter[] { new SqlParameter { ParameterName = "@FBillNo", Value = fBillNo, SqlDbType = SqlDbType.NVarChar } }; string sql = $"select {field} from tm_v_SalesReturnNotice where FBillNo=@FBillNo"; var res = SqlHelper.ExecuteDataTable(CommandType.Text, sql, sqlParameter); returnNoticeDetail.Order = res; return(returnNoticeDetail); }